PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide

Table of contents

1. Copyright
2. Acknowledgments
3. Introduction
4. Introduction to PHP
   1. Basic Syntax
   2. Sending Data to the Web Browser
   3. Understanding PHP, HTML, and White Space
   4. Writing Comments
   5. What Are Variables?
   6. About Strings
   7. About Numbers
   8. About Constants
   9. Single vs. Double Quotation Marks
5. Programming with PHP
   1. Creating an HTML Form
   2. Handling an HTML Form
   3. Managing Magic Quotes
   4. Conditionals and Operators
   5. Validating Form Data
   6. Sending Values to a Script Manually
   7. What Are Arrays?
   8. For and While Loops
6. Creating Dynamic Web Sites
   1. Using External Files
   2. Creating and Calling Your Own Functions
   3. Variable Scope
   4. Handling HTML Forms with PHP Redux
   5. Sending Email
   6. HTTP Headers
   7. Making Sticky Forms
   8. Date and Time Functions
7. Introduction to SQL and MySQL
   1. Designing Tables
   2. Using the mysql monitor
   3. Creating Databases and Tables
   4. Inserting Records
   5. Selecting Data
   6. Using Conditionals
   7. Using LIKE and NOT LIKE
   8. Sorting Query Results
   9. Limiting Query Results
   10. Updating Data
   11. Deleting Data
8. Advanced SQL and MySQL
   1. Database Design
   2. Performing Joins
   3. Using Functions
   4. Indexes
9. Using PHP and MySQL
   1. Making the Template
   2. Connecting to MySQL and Selecting the Database
   3. Error Handling
   4. Executing Simple Queries
   5. Retrieving Query Results
   6. Security
   7. Using mysql_num_rows()
   8. Updating Records with PHP
10. Cookies and Sessions
    1. Using Cookies
    2. Using Sessions
    3. Sessions and Cookies
11. Security
    1. HTTP Authentication
    2. Form Validation with JavaScript
    3. Regular Expressions
    4. Database Security
12. Web Application Development
    1. PHP Debugging Techniques
    2. SQL and MySQL Debugging Techniques
    3. PHP Error Management
    4. MySQL Error Management
    5. Improving Web Application Performance
13. Extended Topics
    1. Output Buffering
    2. Page Caching
    3. Web Browser Detection
    4. PHP and JavaScript
    5. Using PEAR
14. Example—Content Management
    1. Creating the Template
    2. Creating the Basic Pages
    3. Managing URLs
    4. Managing Files
15. Example—User Registration
    1. Creating the Templates
    2. Writing the Configuration Scripts
    3. Creating the Home Page
    4. Registration
    5. Logging In and Logging Out
    6. Password Management
    7. Site Administration
16. Example—E-Commerce
    1. Creating the Database
    2. The Administrative Side
    3. Creating the Public Template
    4. The Product Catalog
    5. The Shopping Cart
17. Installation
    1. Installation on Mac OS X
    2. Installation on Windows
    3. MySQL Permissions
    4. Testing Your Installation
18. Third-Party Applications
    1. phpMyAdmin
    2. Template Systems
    3. Forum Software
    4. Content Management
    5. E-Commerce
    6. Search Engines
    7. Code Repositories
19. Reference
    1. PHP
    2. MySQL
20. Resources
    1. PHP
    2. MySQL
    3. SQL
    4. Security
    5. Other