Web database applications with PHP & MySQL

Database Applications and the Web

The Web

Three-Tier Architectures

The PHP Scripting Language

Introducing PHP

Conditions and Branches

Loops

Functions

Working with Types

User-Defined Functions

A Working Example

Arrays, Strings, and Advanced Data Manipulation in PHP

Arrays

Strings

Regular Expressions

Dates and Times

Integers and Floats

Introduction to Object-Oriented Programming with PHP 5

Classes and Objects

Inheritance

Throwing and Catching Exceptions

SQL and MySQL

Database Basics

MySQL Command Interpreter

Managing Databases and Tables

Inserting, Updating, and Deleting Data

Querying with SQL Select

Join Queries

Case Study: Adding a New Wine

Querying Web Databases

Querying a MySQL Database Using PHP

Processing User Input

MySQL Function Reference

Pear

Core Components

Packages

Writing to Web Databases

Database Inserts, Updates, and Deletes

Issues in Writing Data to Databases

Validation with PHP and JavaScript

Validation and Error Reporting Principles

Server-Side Validation with PHP

JavaScript and Client-Side Validation

Sessions

Introducing Session Management

PHP Session Management

Case Study: Using Sessions in Validation

When to Use Sessions

PHP Session API and Configuration

Authentication and Security

HTTP Authentication

HTTP Authentication with PHP

Form-Based Authentication

Protecting Data on the Web

Errors, Debugging, and Deployment

Errors

Common Programming Errors

Custom Error Handlers

Reporting

Creating a Report

Producing PDF

PDF-PHP Reference

Advanced Features of Object-Oriented Programming in PHP 5

Working with Class Hierarchies

Class Type Hints

Abstract Classes and Interfaces

Freight Calculator Example

Advanced SQL

Exploring with SHOW

Advanced Querying

Manipulating Data and Databases

Functions

Automating Querying

Table Types

Backup and Recovery

Managing Users and Privileges

Tuning MySQL

Hugh and Dave's Online Wines: A Case Study

Functional and System Requirements

Application Overview

Common Components

Managing Customers

Code Overview

Customer Validation

The Customer Form

The Shopping Cart

Code Overview

The Winestore Home Page

The Shopping Cart Implementation

Ordering and Shipping at the Online Winestore

Code Overview

Credit Card and Shipping Instructions

Finalizing Orders

HTML and Email Receipts

Searching and Authentication in the Online Winestore

Code Overview

Searching and Browsing

Authentication

Linux Installation Guide

Microsoft Windows Installation Guide

Mac OS X Installation Guide

Web Protocols

Modeling and Designing Relational Databases

Managing Sessions in the Database Tier

The Improved MySQL Library.