Application Overview
The winestore application was developed to meet the requirements outlined in the previous section. It is a complete PHP and MySQL web database application, and uses PEAR ITX templates and PEAR DB to abstract HTML presentation and the database layer. It was developed on a Linux platform using the MySQL 4.1 DBMS and PHP 4.3, but works in the Microsoft Windows and Mac OS X environments.
It has been tested with PHP 5.0.0 beta (b2). At the time of writing, PEAR DB does not work with PHP5 and MySQL 4.1. This will likely be fixed when PHP5 is released, and we'll provide updated code on our book's web site http://www.webdatabasebook.com.
The winestore has many components of a typical web database application, including:
Maintainable web pages generated with templates, and populated with data from a database.
User-driven querying and browsing, in which the user provides the parameters that limit the searching or browsing of the database. This includes one-component querying.
Data entry and validation.
User tracking with session management techniques.
User authentication and management.
SQL querying that requires table locking.
Receipt pages that avoid the reload problem.
Robust error handling with a custom error module.
Email- and browser-based receipts.
The application has five separate modules that we discuss in the next four chapters:
- Customer management
Becoming a member and amending membership details. The scripts that implement this functionality are in Chapter 17.
- Shopping cart ...
Get Web Database Applications with PHP and MySQL, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
