Web Database Applications with PHP and 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.