Web Database Applications with PHP, and MySQL

Customer Management

In this section, we outline the customer management scripts customer.1, customer.2, and customer.3. The customer.2 script is for data entry of customer details and reporting errors and is based on the customer <form> case study from Chapter 6 and Chapter 8. The customer.1 script performs data validation and writes the customer details to the winestore database. It is also based on the case study examples from Chapter 6 and Chapter 8. The customer.3 receipt is designed to avoid the reload problem after writing to the database.

Customer Validation

Example 10-1 lists the customer.1 script. It is based on Example 8-4 and has the same structure with two exceptions:

• It validates a superset of customer fields, that is, all the fields listed in Chapter 1.

• It manages the encryption of passwords and user account allocation.

The validation techniques used for the additional fields—such as the telephone and fax numbers, email address, zip code, and so on—are discussed in Chapter 7.

Example 10-1. The complete winestore customer validation script, customer.2

<?php // This script validates customer data entered into // example.customer.2.php. // If validation succeeds, it INSERTs or UPDATEs // a customer and redirect to a receipt page; if it // fails, it creates error messages and these are later // displayed by example.customer.2.php. include 'include.inc'; set_error_handler("errorHandler"); // Initialize a session session_start( ); // Register an error array - just in ...