"PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide" Table of Contents

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