PHP and MySQL 24-Hour Trainer (Google eBook)

Front Cover
John Wiley & Sons, Oct 7, 2011 - Computers - 456 pages
1 Review
Step-by-step lessons for using PHP and MySQL in a unique book-and-video combination

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.

  

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

LESSON
1
Configuring XAMPP
9
LESSON
10
SECTION IV
16
Try It
18
LESSON
20
GETTING STARTED WITH
22
CONTENTS
30
LESSON 31
202
PREVENTING PROBLEMS
203
Writing Secure Code
217
INDEX
219
USING A DATABASE
225
Introducing MySQL
239
CREATING AND CONNECTING TO THE DATABASE
263
CREATING TABLES
275

Learning PHP Syntax
33
Working with Variables
45
Debugging Code
57
Working with Complex Data
71
WORKING WITH PHP CONTROLS FUNCTIONS
89
Repeating Program Steps
107
Learning about Scope
119
Reusing Code with Functions
125
Creating Forms
141
OBJECTS AND CLASSES
159
Defining Classes
167
Using Classes
177
Using Advanced Techniques
187
ENTERING DATA
295
SELECTING DATA
313
USING MULTIPLE TABLES
331
CHANGING DATA
343
DELETING DATA
361
PREVENTING DATABASE
387
PUTTING IT ALL TOGETHER
397
Turn the Case Study into a Content Management System
419
Creating a Dynamic Menu
443
Next Steps
461
INDEX
467
Copyright

Common terms and phrases

About the author (2011)

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.

Bibliographic information