Preface

1. Dynamic Content and the Web
HTTP and the Internet
PHP and MySQL's Place in Web Development
The Components of a PHP Application
Integrating Many Sources of Information
Requesting Data from a Web Page

2. Installation
Developing Locally
Working Remotely

3. Exploring PHP
PHP and HTML Text
Coding Building Blocks

4. PHP Decision-Making
Expressions
Operator Concepts
Conditionals
Looping

5. Functions
Calling Functions
Defining Functions
Object-Oriented Programming

6. Arrays
Array Fundamentals

7. Working with MySQL
MySQL Database
Managing the Database
Using phpMyAdmin
Database Concepts
Structured Query Language

8. Database Best Practices
Database Design
Backing Up and Restoring Data
Advanced SQL

9. Getting PHP to Talk to MySQL
The Process
Querying the Database with PHP Functions
Using PEAR

10. Working with Forms
Building a Form
Templates

11. Practical PHP
String Functions
Date and Time Functions
File Manipulation
Calling System Calls

12. XHTML
Why XHTML?
XHTML and XML Namespaces
XHTML Versions
Generating XHTML with PHP

13. Modifying MySQL Objects and PHP Data
Changing Database Objects from PHP
Manipulating Table Data
Displaying Results with Embedded Links
Presenting a Form to Add and Process in One File
Updating Data
Deleting Data
Performing a Subquery

14. Cookies, Sessions, and Access Control
Cookies
PHP and HTTP Authentication
Sessions
Using Auth_HTTP to Authenticate

15. Security
Session Security

16. Validation and Error Handling
Validating User Input with JavaScript
Pattern Matching
Redisplaying a Form After PHP Validation Fails

17. Sample Application
Configuration File
Page Framework
Database
Displaying a Postings Summary
Displaying a Posting and Its Comments
Adding and Changing Posts
Adding and Changing Comments

18. Finishing Your Journey
PHP Coding Standards
PEAR
Frameworks
Ajax
Wikis
Finding Help on the Web

Appendix. Solutions to Chapter Questions
Index