Web Database Applications with PHP and MySQL 2e

Preface 1. Database Applications and the Web The Web Three-Tier Architectures 2. The PHP Scripting Language Introducing PHP Conditions and Branches Loops Functions Working with Types User-Defined Functions A Working Example 3. Arrays, Strings, and Advanced Data Manipulation in PHP Arrays Strings Regular Expressions Dates and Times Integers and Floats 4. Introduction to Object-Oriented Programming with PHP 5 Classes and Objects Inheritance Throwing and Catching Exceptions 5. 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 6. Querying Web Databases Querying a MySQL Database Using PHP Processing User Input MySQL Function Reference 7. PEAR Overview Core Components Packages 8. Writing to Web Databases Database Inserts, Updates, and Deletes Issues in Writing Data to Databases 9. Validation with PHP and JavaScript Validation and Error Reporting Principles Server-Side Validation with PHP JavaScript and Client-Side Validation 10. Sessions Introducing Session Management PHP Session Management Case Study: Using Sessions in Validation When to Use Sessions PHP Session API and Configuration 11. Authentication and Security HTTP Authentication HTTP Authentication with PHP Form-Based Authentication Protecting Data on the Web 12. Errors, Debugging, and Deployment Errors Common Programming Errors Custom Error Handlers 13. Reporting Creating a Report Producing PDF PDF-PHP Reference 14. Advanced Features of Object-Oriented Programming in PHP 5 Working with Class Hierarchies Class Type Hints Abstract Classes and Interfaces Freight Calculator Example 15. 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 16. Hugh and Dave's Online Wines: A Case Study Functional and System Requirements Application Overview Common Components 17. Managing Customers Code Overview Customer Validation The Customer Form 18. The Shopping Cart Code Overview The Winestore Home Page The Shopping Cart Implementation 19. Ordering and Shipping at the Online Winestore Code Overview Credit Card and Shipping Instructions Finalizing Orders HTML and Email Receipts 20. Searching and Authentication in the Online Winestore Code Overview Searching and Browsing Authentication A. Linux Installation Guide B. Microsoft Windows Installation Guide C. Mac OS X Installation Guide D. Web Protocols E. Modeling and Designing Relational Databases F. Managing Sessions in the Database Tier G. Resources H. The Improved MySQL Library Index