| |
| |
Preface | |
| |
| |
| |
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 | |
| |
| |
Overview | |
| |
| |
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 | |
| |
| |
| |
Resources | |
| |
| |
| |
The Improved MySQL Library | |
| |
| |
Index | |