Table of Contents

•	Table of Contents
•	Index
•	Reviews
•	Reader Reviews
•	Errata
•	Academic

Web Database Application with PHP and MySQL, 2nd Edition
By David Lane, Hugh E. Williams
Publisher	: O'Reilly
Pub Date	: May 2004
ISBN	: 0-596-00543-1
Pages	: 816
				Copyright
		Preface
			What This Book Is About
			What You Need to Know
			How This Book Is Organized
			How to Use This Book
			Conventions Used in This Book
			Using Code Examples
			How to Contact Us
			Web Site and Code Examples
			Acknowledgments
		Chapter 1.  Database Applications and the Web
			Section 1.1.  The Web
			Section 1.2.  Three-Tier Architectures
		Chapter 2.  The PHP Scripting Language
			Section 2.1.  Introducing PHP
			Section 2.2.  Conditions and Branches
			Section 2.3.  Loops
			Section 2.4.  Functions
			Section 2.5.  Working with Types
			Section 2.6.  User-Defined Functions
			Section 2.7.  A Working Example
		Chapter 3.  Arrays, Strings, and Advanced Data Manipulation in PHP
			Section 3.1.  Arrays
			Section 3.2.  Strings
			Section 3.3.  Regular Expressions
			Section 3.4.  Dates and Times
			Section 3.5.  Integers and Floats
		Chapter 4.  Introduction to Object-Oriented Programming with PHP 5
			Section 4.1.  Classes and Objects
			Section 4.2.  Inheritance
			Section 4.3.  Throwing and Catching Exceptions
		Chapter 5.  SQL and MySQL
			Section 5.1.  Database Basics
			Section 5.2.  MySQL Command Interpreter
			Section 5.3.  Managing Databases and Tables
			Section 5.4.  Inserting, Updating, and Deleting Data
			Section 5.5.  Querying with SQL SELECT
			Section 5.6.  Join Queries
			Section 5.7.  Case Study: Adding a New Wine
		Chapter 6.  Querying Web Databases
			Section 6.1.  Querying a MySQL Database Using PHP
			Section 6.2.  Processing User Input
			Section 6.3.  MySQL Function Reference
		Chapter 7.  PEAR
			Section 7.1.  Overview
			Section 7.2.  Core Components
			Section 7.3.  Packages
		Chapter 8.  Writing to Web Databases
			Section 8.1.  Database Inserts, Updates, and Deletes
			Section 8.2.  Issues in Writing Data to Databases
		Chapter 9.  Validation with PHP and JavaScript
			Section 9.1.  Validation and Error Reporting Principles
			Section 9.2.  Server-Side Validation with PHP
			Section 9.3.  JavaScript and Client-Side Validation
		Chapter 10.  Sessions
			Section 10.1.  Introducing Session Management
			Section 10.2.  PHP Session Management
			Section 10.3.  Case Study: Using Sessions in Validation
			Section 10.4.  When to Use Sessions
			Section 10.5.  PHP Session API and Configuration
		Chapter 11.  Authentication and Security
			Section 11.1.  HTTP Authentication
			Section 11.2.  HTTP Authentication with PHP
			Section 11.3.  Form-Based Authentication
			Section 11.4.  Protecting Data on the Web
		Chapter 12.  Errors, Debugging, and Deployment
			Section 12.1.  Errors
			Section 12.2.  Common Programming Errors
			Section 12.3.  Custom Error Handlers
		Chapter 13.  Reporting
			Section 13.1.  Creating a Report
			Section 13.2.  Producing PDF
			Section 13.3.  PDF-PHP Reference
		Chapter 14.  Advanced Features of Object-Oriented Programming in PHP 5
			Section 14.1.  Working with Class Hierarchies
			Section 14.2.  Class Type Hints
			Section 14.3.  Abstract Classes and Interfaces
			Section 14.4.  Freight Calculator Example
		Chapter 15.  Advanced SQL
			Section 15.1.  Exploring with SHOW
			Section 15.2.  Advanced Querying
			Section 15.3.  Manipulating Data and Databases
			Section 15.4.  Functions
			Section 15.5.  Automating Querying
			Section 15.6.  Table Types
			Section 15.7.  Backup and Recovery
			Section 15.8.  Managing Users and Privileges
			Section 15.9.  Tuning MySQL
		Chapter 16.  Hugh and Dave's Online Wines:A Case Study
			Section 16.1.  Functional and System Requirements
			Section 16.2.  Application Overview
			Section 16.3.  Common Components
		Chapter 17.  Managing Customers
			Section 17.1.  Code Overview
			Section 17.2.  Customer Validation
			Section 17.3.  The Customer Form
		Chapter 18.  The Shopping Cart
			Section 18.1.  Code Overview
			Section 18.2.  The Winestore Home Page
			Section 18.3.  The Shopping Cart Implementation
		Chapter 19.  Ordering and Shipping at the Online Winestore
			Section 19.1.  Code Overview
			Section 19.2.  Credit Card and Shipping Instructions
			Section 19.3.  Finalizing Orders
			Section 19.4.  HTML and Email Receipts
		Chapter 20.  Searching and Authentication in the Online Winestore
			Section 20.1.  Code Overview
			Section 20.2.  Searching and Browsing
			Section 20.3.  Authentication
		Appendix A.  Linux Installation Guide
			Section A.1.  Finding Out What's Installed
			Section A.2.  Installation Overview
			Section A.3.  Installing MySQL
			Section A.4.  Installing Apache
			Section A.5.  Installing PHP
			Section A.6.  What's Needed for This Book
		Appendix B.  Microsoft Windows Installation Guide
			Section B.1.  Installation Overview
			Section B.2.  Installing with EasyPHP
			Section B.3.  What's Needed for This Book
		Appendix C.  Mac OS X Installation Guide
			Section C.1.  Getting Started
			Section C.2.  Installing MySQL
			Section C.3.  Setting Up Apache and PHP
			Section C.4.  What's Needed for This Book
		Appendix D.  Web Protocols
			Section D.1.  Network Basics
			Section D.2.  Hypertext Transfer Protocol
		Appendix E.  Modeling and Designing Relational Databases
			Section E.1.  The Relational Model
			Section E.2.  Entity-Relationship Modeling
		Appendix F.  Managing Sessions in theDatabase Tier
			Section F.1.  Using a Database to Keep State
			Section F.2.  PHP Session Management
			Section F.3.  MySQL Session Store
		Appendix G.  Resources
			Section G.1.  Client Tier Resources
			Section G.2.  Middle-Tier Resources
			Section G.3.  Database Tier Resources
			Section G.4.  Security and Cryptography Resources
		Appendix H.  The Improved MySQL Library
			Section H.1.  New Features
			Section H.2.  Getting Started
			Section H.3.  Using the New Features
		Colophon
		Index