Web Database Applications - Examples
cover

Hugh Williams and David Lane's ``Web Database Applications with PHP and MySQL'' Website


Visit the webdatabasebook.com website. Or order a copy from Amazon!


This website is generously hosted by the School of Computer Science and IT at RMIT University.

Examples from the book

Chapter 2

Example 2-1 (PHP 4.0 source) (PHP 4.2 source)
Example 2-2 (PHP 4.0 source) (PHP 4.2 source)
Example 2-3 (PHP 4.0 source) (PHP 4.2 source)
Example 2-4 (PHP 4.0 source) (PHP 4.2 source)
Example 2-5 (PHP 4.0 source) (PHP 4.2 source)
Example 2-6 (PHP 4.0 source) (PHP 4.2 source)
Example 2-7 (PHP 4.0 source) (PHP 4.2 source)
Example 2-8 (PHP 4.0 source) (PHP 4.2 source)
Example 2-9 (PHP 4.0 source) (PHP 4.2 source)


Chapter 3

Example 3-1 (source)
Example 3-2 (source)
Example 3-3 is the same as winestore.data.gz


Chapter 4

Example 4-1 (PHP 4.0 source) (PHP 4.2 source)
Example 4-2
Example 4-3 (PHP 4.0 source) (PHP 4.2 source)
Example 4-4
Example 4-5 (PHP 4.0 source) (PHP 4.2 source)
Example 4-6 (PHP 4.0 source) (PHP 4.2 source)
Example 4-7
Example 4-8
Example 4-9 (PHP 4.0 source) (PHP 4.2 source)
Example 4-10 (PHP 4.0 source) (PHP 4.2 source)
Example 4-11 (PHP 4.0 source) (PHP 4.2 source)
Example 4-12 (PHP 4.0 source)
Example 4-13 (PHP 4.0 source)
Example 4-14 (PHP 4.0 source)
Example 4-15 (PHP 4.0 source)


Chapter 5

Example 5-1 (PHP 4.0 source) (PHP 4.2 source)
Example 5-2 (PHP 4.0 source) (PHP 4.2 source)
Example 5-3 (PHP 4.0 source) (PHP 4.2 source)
Example 5-4 (PHP 4.0 source) (PHP 4.2 source)
Example 5-5 (PHP 4.0 source) (This version of Example 5-2 runs this example) (PHP 4.2 source)
Example 5-6 (PHP 4.0 source) (PHP 4.2 source)
Example 5-7 (PHP 4.0 source) (PHP 4.2 source)
Example 5-8 (PHP 4.0 source) (PHP 4.2 source)
Example 5-9 (PHP 4.0 source) (PHP 4.2 source) (This is the same as Example 5-10)
Example 5-10 (PHP 4.0 source) (PHP 4.2 source) (This is the same as Example 5-9)
Example 5-11 (PHP 4.0 source) (PHP 4.2 source)
Example 5-12 (PHP 4.0 source) (PHP 4.2 source) (This is the same as Example 5-13)
Example 5-13 (PHP 4.0 source) (PHP 4.2 source) (This is the same as Example 5-12)


Chapter 6

Example 6-1 (PHP 4.0 source) (PHP 4.2 source)
Example 6-2 (PHP 4.0 source) (PHP 4.2 source)
Example 6-3 (PHP 4.0 source) (PHP 4.2 source)
Example 6-4 (PHP 4.0 source) (PHP 4.2 source)
Example 6-5 (PHP 4.0 source) (PHP 4.2 source)
Example 6-6 (PHP 4.0 source) (PHP 4.2 source)
Customer Receipt (PHP 4.0 source) (PHP 4.2 source)
Example 6-7 (PHP 4.0 source) (PHP 4.2 source) (insert)
Example 6-7 (PHP 4.0 source) (PHP 4.2 source) (edit customer #1)
Example 6-8 (PHP 4.0 source) PHP 4.2 source)
Example 6-9 (PHP 4.0 source) (PHP 4.2 source) (Gives customer #653 a discount of $4.95 on order #49 if the order total is >$10)
Example 6-10 (PHP 4.0 source) (PHP 4.2 source)


Chapter 7

Example 7-1 (PHP 4.0 source) (PHP 4.2 source)
Example 7-2 (PHP 4.0 source) (PHP 4.2 source)
Example 7-3 (PHP 4.0 source) (PHP 4.2 source)
Example 7-4 (PHP 4.0 source) (PHP 4.2 source)
Example 7-5 (PHP 4.0 source) (PHP 4.2 source)
Example 7-6 (PHP 4.0 source) (PHP 4.2 source)
Example 7-7 (PHP 4.0 source) (PHP 4.2 source)


Chapter 8

Example 8-1 (PHP 4.0 source) (PHP 4.2 source)
Example 8-2 (PHP 4.0 source) (PHP 4.2 source)
Example 8-3 (PHP 4.0 source) (PHP 4.2 source)
Example 8-4 (PHP 4.0 source) (PHP 4.2 source)
Example 8-5 (PHP 4.0 source) (PHP 4.2 source)


Chapter 9

Example 9-1
Example 9-2
Example 9-3 (PHP 4.0 source) (PHP 4.2 source)
Example 9-4 (PHP 4.0 source) (PHP 4.2 source)
Example 9-5 (PHP 4.0 source) (PHP 4.2 source)
Example 9-6 (PHP 4.0 source) (PHP 4.2 source)
Example 9-7 (PHP 4.0 source) (PHP 4.2 source)
Example 9-8 (PHP 4.0 source) (PHP 4.2 source)
Example 9-9 (PHP 4.0 source) (PHP 4.2 source)
Example 9-10 (PHP 4.0 source) (PHP 4.2 source)
Example 9-11 (PHP 4.0 source) (PHP 4.2 source)


Chapter 10

Use the PHP 4.0 winestore application
Example 10-1 (PHP 4.0 source) (PHP 4.2 source) (customer.1 - Validate customer details)
Example 10-2 (PHP 4.0 source) (PHP 4.2 source) (customer.2 - Edit customer details)
Example 10-3 (PHP 4.0 source) (PHP 4.2 source) (customer.3 - Customer insert or edit receipt)
Example 10-4 (PHP 4.0 source) (PHP 4.2 source) (order.1 - User login)
Example 10-5 (PHP 4.0 source) (PHP 4.2 source) (order.2 - User logout)
Example 10-6 (db.inc - database and DBMS credentials)
Example 10-7 (PHP 4.0 source) (PHP 4.2 source) (include.inc - common functions)
Example 10-8 (PHP 4.0 source) (PHP 4.2 source) (error.inc - custom error handler)


Chapter 11

Example 11-1 (PHP 4.0 source) (PHP 4.2 source) (cart.1 - winestore home page)
Example 11-2 (PHP 4.0 source) (PHP 4.2 source) (cart.2 - view cart)
Example 11-3 (PHP 4.0 source) (PHP 4.2 source) (cart.3 - add to cart)
Example 11-4 (PHP 4.0 source) (PHP 4.2 source) (cart.4 - delete cart)
Example 11-5 (PHP 4.0 source) (PHP 4.2 source) (cart.6 - update quantities)
Example 11-6 (PHP 4.0 source) (PHP 4.2 source) (cart.5 - manage redirection)


Chapter 12

Example 12-1 (PHP 4.0 source) (PHP 4.2 source) (order.3 - finalize order)
Example 12-2 (PHP 4.0 source) (PHP 4.2 source) (shipping.1 - email confirmation)
Example 12-3 (PHP 4.0 source) (PHP 4.2 source) (shipping.2 - HTML confirmation)


Chapter 13

Example 13-1 (PHP 4.0 source) (PHP 4.2 source) (shipping.3 - templated receipt)
Example 13-2 (PHP 4.0 source) (PHP 4.2 source) (shipping.3 - templated receipt)
Example 13-3 (PHP 4.0 source) (PHP 4.2 source) (search.1 - search and browse)


Appendix D

Example D-1 (PHP 4.0 source) (PHP 4.2 source)
Examples D-2 to D-9 are part of mysql_session.inc (PHP 4.0 source) (PHP 4.2 source)
Example D-10 (PHP 4.0 source) (PHP 4.2 source)


Other bits and pieces

source.php (Source code viewer used on this website) (PHP 4.0 source)

Source code examples for Web Database Applications are covered by the following agreement.
Unless otherwise stated, the source code distributed with the book can be redistributed in source or binary form so long as an acknowledgment appears in derived source files. The citation should list that the code comes from Hugh E. Williams and David Lane, "Web Database Application with PHP and MySQL" published by O'Reilly & Associates. This code is under copyright and cannot be included in any other book, publication, or educational product without permission from O'Reilly & Associates. No warranty is attached; we cannot take responsibility for errors or fitness for use.


Valid HTML 4.01! Hugh Williams
Last modified: Date: 2002/06/30 14:10:00