O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide

Book Description

When static HTML pages no longer cut it, you need to step up to dynamic, database-driven sites that represent the future of the Web. In PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, the author of best-selling guides to both the database program (MySQL) and the scripting language (PHP) returns to cover the winning pair in tandem¿the way users work with them today to build dynamic sites using Open Source tools. Using step-by-step instructions, clearly written scripts, and expert tips to ease the way, author Larry Ullman discusses PHP and MySQL separately before going on to cover security, sessions and cookies, and using additional Web tools, with several sections devoted to creating sample applications. A companion Web site includes source code and demonstrations of techniques used in the volume. If you¿re already at home with HTML, you¿ll find this volume the perfect launching pad to creating dynamic sites with PHP and MySQL.

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