PHP and MySQL 24-Hour Trainer (eBook)
504 Seiten
John Wiley & Sons (Verlag)
978-1-118-17291-9 (ISBN)
Assuming no previous experience with PHP or MySQL, this book-and-video package is ideal reading for anyone who wants to go beyond HTML/CSS in order to provide clients with the most dynamic web sites possible. The approachable tone breaks down the basics of programming and PHP and MySQL in individual lessons starting with the installation of the programs necessary to run PHP. You begin with a static web site and then watch and learn as PHP functionality is added as you work through the lessons.
When working with databases, the MySQL database is introduced with demonstrations that show how to interact with it. The accompanying videos enhance your learning experience, as each lesson in the book is portrayed in the video exercises.
Lessons include:
* Getting started with PHP
* Setting up your workspace
* Adding PHP to a web page
* Learning PHP syntax
* Working with variables
* Debugging code
* Working with complex data
* Making decisions
* Repeating program steps
* Learning about scope
* Reusing code with functions
* Creating forms
* Introducing object-oriented programming
* Defining classes
* Using classes
* Using advanced techniques
* Handling errors
* Writing secure code
* Introducing databases
* Introducing MySQL
* Creating and connecting to the
* Creating tables
* Entering data
* Selecting data
* Using multiple tables
* Changing data
* Deleting data
* Preventing database security issues
* Creating user logins
* Turn the case study into a content management system
Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.
Andrea Tarr has been a programmer and IT manager for 30 years and now spends her time programming websites using PHP/MySQL. She is a member of the Production Leadership Team for Joomla!, a popular PHP/MySQL-based content management system.
INTRODUCTION xvii
SECTION I: GETTING STARTED WITH PHP
LESSON 1: SETTING UP YOUR WORKSPACE 3
LESSON 2: ADDING PHP TO A WEB PAGE 23
LESSON 3: LEARNING PHP SYNTAX 33
LESSON 4: WORKING WITH VARIABLES 45
LESSON 5: DEBUGGING CODE 57
LESSON 6: WORKING WITH COMPLEX DATA 71
SECTION II: WORKING WITH PHP CONTROLS, FUNCTIONS, AND
FORMS
LESSON 7: MAKING DECISIONS 91
LESSON 8: REPEATING PROGRAM STEPS 107
LESSON 9: LEARNING ABOUT SCOPE 119
LESSON 10: REUSING CODE WITH FUNCTIONS 125
LESSON 11: CREATING FORMS 141
SECTION III: OBJECTS AND CLASSES
LESSON 12: INTRODUCING OBJECT-ORIENTED PROGRAMMING 161
LESSON 13: DEFINING CLASSES 167
LESSON 14: USING CLASSES 177
LESSON 15: USING ADVANCED TECHNIQUES 187
SECTION IV: PREVENTING PROBLEMS
LESSON 16: HANDLING ERRORS 205
LESSON 17: WRITING SECURE CODE 217
SECTION V: USING A DATABASE
LESSON 18: INTRODUCING DATABASES 227
LESSON 19: INTRODUCING MYSQL 239
LESSON 20: CREATING AND CONNECTING TO THE DATABASE 263
LESSON 21: CREATING TABLES 275
LESSON 22: ENTERING DATA 295
LESSON 23: SELECTING DATA 313
LESSON 24: USING MULTIPLE TABLES 331
LESSON 25: CHANGING DATA 343
LESSON 26: DELETING DATA 361
LESSON 27: PREVENTING DATABASE SECURITY ISSUES 387
SECTION VI: PUTTING IT ALL TOGETHER
LESSON 28: CREATING USER LOGINS 399
LESSON 29: TURN THE CASE STUDY INTO A CONTENT MANAGEMENT SYSTEM
419
LESSON 30: CREATING A DYNAMIC MENU 443
LESSON 31: NEXT STEPS 461
APPENDIX : WHAT'S ON THE DVD? 463
INDEX 467
Erscheint lt. Verlag | 13.10.2011 |
---|---|
Sprache | englisch |
Themenwelt | Informatik ► Datenbanken ► MySQL |
Mathematik / Informatik ► Informatik ► Programmiersprachen / -werkzeuge | |
Mathematik / Informatik ► Informatik ► Software Entwicklung | |
Mathematik / Informatik ► Informatik ► Web / Internet | |
Schlagworte | Computer Science • Informatik • PHP • Programmierung u. Software-Entwicklung • Programming & Software Development |
ISBN-10 | 1-118-17291-4 / 1118172914 |
ISBN-13 | 978-1-118-17291-9 / 9781118172919 |
Haben Sie eine Frage zum Produkt? |
![PDF](/img/icon_pdf_big.jpg)
Größe: 59,3 MB
Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine
Geräteliste und zusätzliche Hinweise
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich