Product Overview

Build Your Own Database Driven Website Using PHP & MySQL

Table Of Contents

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

  1. 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
  2. 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
  3. 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
  4. Getting Started with PHP
    • Introducing PHP
    • Basic Syntax and Commands
    • Variables and Operators
    • Arrays
    • User Interaction and Forms
    • Control Structures
    • Multipurpose Pages
    • Summary
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. Cookies and Sessions in PHP
    • Cookies
    • PHP Sessions
    • A Simple Shopping Cart
    • Summary
  13. 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?



Buy ANY SitePoint Book — Get A PDF FREE!

Pick any PDFThat's right, order ‘Build Your Own Database Driven Website Using PHP & MySQL’ TODAY and grab ANY PDF you like — FREE!

Choose your FREE PDF

3rd Edition

3rd Edition NOW Available!

What's New?

  • All-new coverage of PHP 5.0 keeps up to date with the latest best practices in PHP
  • New screenshots throughout the book show you how it’s done visually
  • A new chapter on building structured programming that teaches you to build an access control system in PHP
  • Revised and expanded throughout
  • All known errors in the previous edition now corrected
  • 58 pages longer

» Click here to order!

SitePoint Books

  • Advocate best practice techniques
  • Lead you through practical examples
  • Provide working code for your web site
  • Make learning easy and fun

100% Money Back Guarantee