Product Overview

Build Your Own Database Driven Website Using PHP & MySQL

Table Of Contents

- Here's a look at the table of contents:

0. Preface
   • Who Should Read This Book
   • What’s In This Book
   • The Book’s Website
     • The Code Archive
     • Updates and Errata
   • The SitePoint Forums
   • The SitePoint Newsletters
   • Your Feedback
1. Installation
   • Windows Installation
     • Installing MySQL
     • Installing PHP
   • Linux Installation
     • Removing Packaged Software
     • Installing MySQL
     • Installing PHP
   • Mac OS X Installation
     • Installing MySQL
     • Installing PHP
     • Mac OS X and Linux
   • Post-Installation Setup Tasks
   • If Your Web Host Provides PHP and MySQL
   • Your First PHP Script
   • Summary
2. Getting Started with MySQL
   • An Introduction to Databases
   • Logging On to MySQL
   • So, What’s SQL?
   • Creating a Database
   • Creating a Table
   • Inserting Data into a Table
   • Viewing Stored Data
   • Modifying Stored Data
   • Deleting Stored Data
   • Summary
3. Getting Started with PHP
   • Introducing PHP
   • Basic Syntax and Commands
   • Variables and Operators
   • Arrays
   • User Interaction and Forms
   • Control Structures
   • Multipurpose Pages
   • Summary
4. Publishing MySQL Data on the Web
   • A Look Back at First Principles
   • Connecting to MySQL with PHP
   • Sending SQL Queries with PHP
   • Handling SELECT Result Sets
   • Inserting Data into the Database
   • A Challenge
   • Summary
   • “Homework” Solution
5. Relational Database Design
   • Giving Credit where Credit is Due
   • Rule of Thumb: Keep Things Separate
   • Dealing with Multiple Tables
   • Simple Relationships
   • Many-to-Many Relationships
   • Summary
6. A Content Management System
   • The Front Page
   • Managing Authors
   • Deleting Authors
   • Adding Authors
   • Editing Authors
     • Magic Quotes
   • Managing Categories
   • Managing Jokes
     • Searching for Jokes
     • Adding Jokes
     • Editing and Deleting Jokes
   • Summary
7. Content Formatting and Submission
   • Out with the Old
   • Regular Expressions
   • String Replacement with Regular Expressions
     • Boldface and Italic Text
     • Paragraphs
     • Hyperlinks
     • Matching Tags
   • Splitting Text into Pages
   • Putting it all Together
   • Automatic Content Submission
   • Summary
8. MySQL Administration
   • Backing up MySQL Databases
     • Database Backups using mysqldump
     • Incremental Backups using Update Logs
   • MySQL Access Control
     • Using GRANT
     • Using REVOKE
     • Access Control Tips
     • Locked Out?
   • Checking and Repairing MySQL Data Files
   • Summary
9. Advanced SQL Queries
   • Sorting SELECT Query Results
   • Setting LIMITs
   • LOCKing TABLES
   • Column and Table Name Aliases
   • GROUPing SELECT Results
   • LEFT JOINs
   • Limiting Results with HAVING
   • Summary
10. Binary Data
    • Semi-Dynamic Pages
    • Handling File Uploads
      • Assigning Unique File Names
    • Recording Uploaded Files in the Database
      • Binary Column Types
      • Storing Files
      • Viewing Stored Files
    • The Complete Script
    • Large File Considerations
      • MySQL Packet Size
      • PHP Script Timeout
    • Summary
11. Cookies and Sessions in PHP
    • Cookies
    • PHP Sessions
    • A Simple Shopping Cart
    • Summary
12. Structured PHP Programming
    • What is Structured Code?
    • The Need for Structured Code
    • Include Files
      • Types of Includes
      • Including HTML Content
      • Locating Include Files
      • Returning from Includes
    • Custom Functions and Function Libraries
      • Variable Scope and Global Access
      • Optional and Unlimited Arguments
    • Constants
    • Structure In Practice: Access Control
    • Summary

1. MySQL Syntax
   • ALTER TABLE
   • ANALYZE TABLE
   • CREATE DATABASE
   • CREATE INDEX
   • CREATE TABLE
   • DELETE
   • DESCRIBE
   • DROP DATABASE
   • DROP INDEX
   • DROP TABLE
   • EXPLAIN
   • GRANT
   • INSERT
   • LOAD DATA INFILE
   • LOCK/UNLOCK TABLES
   • OPTIMIZE TABLE
   • RENAME TABLE
   • REPLACE
   • REVOKE
   • SELECT
     • Joins
     • Unions
   • SET
   • SHOW
   • UNLOCK TABLES
   • UPDATE
   • USE
2. MySQL Functions
   • Control Flow Functions
   • Mathematical Functions
   • String Functions
   • Date and Time Functions
   • Miscellaneous Functions
   • Functions for Use with GROUP BY Clauses
3. MySQL Column Types
   • Numerical Types
   • Character Types
   • Date/Time Types
4. PHP Functions for Working with MySQL
   • mysql_affected_rows
   • mysql_client_encoding
   • mysql_close
   • mysql_connect
   • mysql_create_db
   • mysql_data_seek
   • mysql_db_name
   • mysql_db_query
   • mysql_drop_db
   • mysql_errno
   • mysql_error
   • mysql_escape_string
   • mysql_fetch_array
   • mysql_fetch_assoc
   • mysql_fetch_field
   • mysql_fetch_lengths
   • mysql_fetch_object
   • mysql_fetch_row
   • mysql_field_flags
   • mysql_field_len
   • mysql_field_name
   • mysql_field_seek
   • mysql_field_table
   • mysql_field_type
   • mysql_free_result
   • mysql_get_client_info
   • mysql_get_host_info
   • mysql_get_proto_info
   • mysql_get_server_info
   • mysql_info
   • mysql_insert_id
   • mysql_list_dbs
   • mysql_list_fields
   • mysql_list_processes
   • mysql_list_tables
   • mysql_num_fields
   • mysql_num_rows
   • mysql_pconnect
   • mysql_ping
   • mysql_query
   • mysql_real_escape_string
   • mysql_result
   • mysql_select_db
   • mysql_stat
   • mysql_tablename
   • mysql_thread_id
   • mysql_unbuffered_query
5. Index

Now that you realize this book can advance you … how can you possibly go wrong investing $39.95 on something that can dramatically change the course of your career?