Beginning PHP and MySQL - From Novice to Professional

Contents at a Glance

Contents

About the Author

About the Technical Reviewers

Acknowledgments

Introduction

Download the Code

Contact Me!

Introducing PHP

History

General Language Features

Summary

Configuring Your Environment

Installation Prerequisites

Installing Apache and PHP on Linux

Installing Apache and PHP on Windows

Installing IIS and PHP on Windows

Testing Your Installation

Configuring PHP

Run- Time Configuration

Choosing a Code Editor

Choosing a Web Hosting Provider

Summary

PHP Basics

Embedding PHP Code in Your Web Pages

Commenting Your Code

Outputting Data to the Browser

PHP’s Supported Datatypes

Identifiers

Variables

Constants

Expressions

String Interpolation

Control Structures

Summary

Functions

Invoking a Function

Creating a Function

Function Libraries

Summary

Arrays

What Is an Array?

Creating an Array

Adding and Removing Array Elements

Locating Array Elements

Traversing Arrays

Determining Array Size and Uniqueness

Sorting Arrays

Merging, Slicing, Splicing, and Dissecting Arrays

Other Useful Array Functions

Summary

Object-Oriented PHP

The Benefits of OOP

Key OOP Concepts

Constructors and Destructors

Static Class Members

The instanceof Keyword

Helper Functions

Autoloading Objects

Summary

Advanced OOP Features

Advanced OOP Features Not Supported by PHP

Object Cloning

Inheritance

Interfaces

Abstract Classes

Introducing Namespaces

Summary

Error and Exception Handling

Configuration Directives

Error Logging

Exception Handling

Summary

Strings and Regular Expressions

Regular Expressions

Other String- Specific Functions

Alternatives for Regular Expression Functions

Taking Advantage of PEAR: Validate_ US

Summary

Working with the File and Operating System

Learning About Files and Directories

Working with Files

Executing Shell Commands

System- Level Program Execution

Summary

PEAR

Popular PEAR Packages

The Power of PEAR: Converting Numeral Formats

Installing and Updating PEAR

Using the PEAR Package Manager

Summary

Date and Time

The Unix Timestamp

PHP’s Date and Time Library

Date Fu

Date and Time Enhancements for PHP 5.1+ Users

Summary

Forms

PHP and Web Forms

Taking Advantage of PEAR: HTML_ QuickForm

Summary

Authenticating Your Users

HTTP Authentication Concepts

PHP Authentication

PHP Authentication Methodologies

User Login Administration

Summary

Handling File Uploads

Uploading Files via HTTP

Uploading Files with PHP

Taking Advantage of PEAR: HTTP_ Upload

Summary

Networking

DNS, Services, and Servers

Mail

Common Networking Tasks

Summary

PHP and LDAP

Using LDAP from PHP

Summary

Session Handlers

What Is Session Handling?

Configuration Directives

Working with Sessions

Practical Session- Handling Examples

Creating Custom Session Handlers

Summary

Templating with Smarty

What’s a Templating Engine?

Introducing Smarty

Installing Smarty

Using Smarty

Smarty’s Presentational Logic

Creating Configuration Files

Using CSS in Conjunction with Smarty

Caching

Summary

Web Services

Why Web Services?

Really Simple Syndication

SimpleXML

SOAP

Summary

Secure PHP Programming

Configuring PHP Securely

Hiding Configuration Details

Hiding Sensitive Data

Sanitizing User Data

Data Encryption

Summary

SQLite

Introduction to SQLite

PHP’s SQLite Library

Summary

Building Web Sites for the World

Translating Web Sites with Gettext

Localizing Dates, Numbers, and Times

Summary

MVC and the Zend Framework

Introducing MVC

PHP’s Framework Solutions

Introducing the Zend Framework

Summary

Introducing MySQL

What Makes MySQL So Popular?

The Evolution of MySQL

Prominent MySQL Users

Summary

Installing and Configuring MySQL

Downloading MySQL

Installing MySQL

Setting the MySQL Administrator Password

Starting and Stopping MySQL

Configuring and Optimizing MySQL

Configuring PHP to Work with MySQL

Summary

The Many MySQL Clients

Introducing the Command- Line Clients

MySQL’s GUI Client Programs

phpMyAdmin

Summary

MySQL Storage Engines and Datatypes

Storage Engines

Datatypes and Attributes

Working with Databases and Tables

Summary

Securing MySQL

What You Should Do First

Securing the mysqld Daemon

The MySQL Access Privilege System

User and Privilege Management

Limiting User Resources

Secure MySQL Connections

Summary

Using PHP with MySQL

Handling Installation Prerequisites

Using the mysqli Extension

Interacting with the Database

Executing Database Transactions

Summary

Introducing PDO

Another Database Abstraction Layer?

Using PDO

Summary

Stored Routines

Should You Use Stored Routines?

How MySQL Implements Stored Routines

Integrating Routines into Web Applications

Summary

MySQL Triggers

Introducing Triggers

MySQL’s Trigger Support

Integrating Triggers into Web Applications

Summary

MySQL Views

Introducing Views

MySQL’s View Support

Incorporating Views into Web Applications

Summary

Practical Database Queries

Sample Data

Creating Tabular Output with PEAR

Sorting Output

Creating Paged Output

Listing Page Numbers

Querying Multiple Tables with Subqueries

Iterating Result Sets with Cursors

Summary

Indexes and Searching

Database Indexing

Forms-Based Searches

Summary

Transactions

What’s a Transaction?

MySQL’s Transactional Capabilities

A Sample Project

Building Transactional Applications with PHP

Summary

Importing and Exporting Data

Sample Table

Using Data Delimitation

Importing Data

Exporting Data

Summary

Index