PHP & MySQL: Your visual blueprint for creating dynamic, database driven Web sites Table of Contents

Setting Up Your Development Environment

Introducing Dynamic Web Sites

Set Up Your Development Environment

Obtain Apache

Install Apache

Obtain MySQL

Install MySQL

Configure MySQL

Install MySQL Administration Programs

Create MySQL Accounts for Use in PHP Scripts

Obtain PHP

Install PHP

Configure Apache to Process PHP Code

Configure PHP

Test Your Development Environment

Learning PHP Basics

How PHP Works

Add PHP Code to a Web Page File

Using PHP Statements

Understanding PHP Output Statements

Using PHP Variables

Using PHP Constants

Work with Numbers

Work with Character Strings

Work with Dates and Times

Modify or Remove Variables

Using Variable Variables

Understanding Error Messages

Add Comments to a Script

Using Arrays

Create an Array

Modify or Remove an Array

Get Information about an Array

Sort an Array

Walk through an Array with Foreach

Walk through an Array Manually

Find Values in an Array

Compare Arrays

Split and Merge Arrays

Convert an Array into a String and Vice Versa

Store a Set of Variables in an Array

Store Array Elements in Separate Variables

Create a Multidimensional Array

Walk through a Multidimensional Array

Using Built-in PHP Arrays

Controlling the Flow of the Script

Change the Order of Statement Execution

Check the Contents of a Variable

Set up Conditions with Comparison Operators

Introducing Regular Expressions

Match Character Strings to Patterns Using Regular Expressions

Join Multiple Comparisons with Logical Operators

Using an if Statement

sing a switch Statement

Using a for Loop

Using a while Loop

Using a do-while Loop

Avoid an Infinite Loop

Break Out of a Loop

Reusing PHP Code

Include a Code File

Configure the Path to the include Files

Include Files Automatically

Store include Files Securely

Define and Use a Function

Using Variables in a Function

Pass Values to a Function

Return Values from a Function

Some Useful PHP Built-in Functions

Format a Number

Round a Number

Find the Largest or Smallest Number

Remove Leading and Trailing Blank Spaces

Change the Case of a String

Format a String

Count the Characters or Substrings in a String

Locate a Substring in a String

Get a Substring

Find and Replace Substrings

Add a Substring to a String

Using Regular Expressions to Replace Text

Pad or Repeat a String

Convert a Character to and from an ASCII Value

Compare Strings

Convert a String into an Array

Send an Email Message

Send an HTTP Header

Read Configuration Settings

Set a Local PHP Configuration Option

Using MySQL Databases

How a MySQL Databas Works

Send a Query with the mysql Client

Send a Query with the MySQL Query Browser

Create, Select, or Remove a MySQL Database

Define a MySQL Table

Create and Remove a MySQL Table

Modify the MySQL Table Structure

Add a Row of Data to a Database

Add Data from a Text File to a Database

Store Incremental Values in a Column

Retrieve Data from a Database

Limit Query Execution to Specific Rows with a WHERE Clause

Retrive Data from Multiple Tables with UNION

Retrieve Data from Multiple Tables by Joining Tables

Update Data in a Database

Remove Data from a Database

Query a MySQL Database from a PHP Script

Display Database Data on a Web Page in a PHP Script

Handle MySQL Errors

Administering MySQL Databases

Understanding MySQL Accounts

View Existing Accounts

Create a MySQL Account

Change the Password of a MySQL Account

Add and Remove Privileges

Change the Name of a MySQL Account

Remove a MySQL Account

Stop and Start the MySQL Server

Using MySQL Logs

Back Up Data

Restore Data

Upgrade MySQL

Adding HTML Forms to a Web Page

Display an HTML Form

Add a Text Field

Add a multiline Text Area

Add a Hidden Field

Add a Dynamic Selection List to a Form

Add a Date Selection List

Add Dynamic Radio Buttons

Add Dynamic Check Boxes

Create One or More Submit Buttons

Choose the POST or GET Method for a Form

Create a Form That Uploads a File

Processing Data from Forms

Process Information from a Form

Display Data from a Form

Display and Process a From in One Script

Check for Blank Fields

Verify Form Data

Clean Form Data

Add Form Data to a Database

Insert Form Data into a Database

Update or Remove Database Data

Process an Uploaded File

Managing User Sessions

Understanding User Sessions

Send a New Web Page to the Browser

Add Information to a URL

Store Information in Cookies

Store Information in a PHP Session

Using PHP sessions without Cookies

Object-oriented Programming in PHP

Understanding Object-Oriented Programming

Create and Use an Object

Set Properties in a Class

Add Methods to a Class

Write a Constructor or a Destructor Method

Using PHP Magic Methods to Get or Set Properties

Using Inheritance in a Class

Using Exceptions

Copy and Compare Objects

Get Information about Objects and Classes

Using Abstract Classes

Using Interfaces

Appendix A: Programming Editors and IDES for PHP

Appendix B: Troubleshooting Tips