List of Tables

Chapter 2: Basic HTML

Table 2.1: BASIC HTML TAGS

Table 2.2: ATTRIBUTES FOR LINK IN BODY TAG

Chapter 3: HTML Forms and Client-Side JavaScript

Table 3.1: Basic Tags and Attributes for HTML Forms

Table 3.2: HTML/JavaScript Calculation Example

Table 3.3: HTML/JavaScript for Mouse Rollover Image Swap

Table 3.5: HTML/JavaScript for Slide Show

Chapter 4: Server-Side Basics

Table 4.1: Steps in Expression Calculating Choice

Chapter 5: Database Basics

Table 5.1: Catalog (Product) Records

Table 5.2: Customer Records

Table 5.3: Order Records

Table 5.4: Normalization Conditions

Table 5.5: The Courses Table

Table 5.6: The Sections Table

Table 5.7: Prerequisite Table

Chapter 7: Structured Query Language

Table 7.1: Catalog Records

Table 7.2: Customer Records

Table 7.3: ORDERS

Table 7.4: Join of Customer and Orders

Table 7.5: A New Customer Record

Table 7.6: Left Join of Customer and Orders

Chapter 9: Connecting to the Database

Table 9.1: PHP Script to Enter Specific Record into Favorites Table

Table 9.2: PHP Script to Handle and Display Form to Make Insertion of Favorite

Table 9.3: ASP Script for Showing Favorites

Table 9.4: ASP Script for Inputting a New Favorite

Table 9.5: ASP/JavaScript Using escape and unescape

Chapter 10: Connecting to a Database: Advanced

Table 10.1: PHP Script to Alter Field Size

Table 10.2: ASP/JavaScript to Alter Field Size

Table 10.3: ASP/JavaScript Script to Display Titles

Table 10.4: ASP/JavaScript Script to Delete Specified Title

Table 10.5: PHP Script to Display Titles

Table 10.6: PHP Script to Drop the Specified Title

Table 10.7: ASP/JavaScript Displaying Titles for Updating

Table 10.8: ASP/JavaScript for Performing Update of Specified Title

Table 10.9: ASP/JavaScript to Perform the Update of the Favorite

Table 10.10: PHP Script to Display Titles for Updating

Table 10.11: PHP Script to Enter Update Information

Table 10.12: PHP Script to Perform Update of Title

Table 10.13: PHP Script for Defining New Tables

Table 10.14: PHP Script for Populating the Categories Table

Table 10.15: PHP Script for Adding a Warning

Table 10.16: PHP Script for Adding Warning to Specified Favorite Title

Table 10.17: PHP Script to Insert Warning for Favorite

Table 10.18: PHP Script to Display All Warnings

Table 10.19: PHP Script to Display All Favorites with Counts of the Warnings

Table 10.20: PHP Script Presenting Chance to Select Category

Table 10.21: PHP Script to Show Favorites with Warnings in Selected Category

Table 10.22: ASP/JavaScript for Showing Favorites for Adding a Warning

Table 10.23: ASP/JavaScript for Adding a Warning for a Specified Favorite Title

Table 10.24: ASP/JavaScript to Perform Actual Insertion of Warning

Table 10.25: ASP/JavaScript for Displaying All Titles with Warnings

Table 10.26: ASP/JavaScript for Displaying All Favorites with Counts of the Warnings

Table 10.27: ASP/JavaScript for Displaying Categories

Table 10.28: ASP/JavaScript to Display Favorites with Warnings in Specified Category

Chapter 11: Regular Expressions

Table 11.1: PHP Script to Display Form

Table 11.2: PHP Script for Server-Side Validation of Form Data

Table 11.3: ASP/JavaScript Script to Validate Form Data

Table 11.4: PHP Script to Find Warnings with Specified Term

Table 11.5: ASP/JavaScript to Find Warnings with Specified Term

Chapter 12: Files

Table 12.1: ASP Methods and Properties for File Handling

Table 12.2: PHP Functions for Files

Table 12.3: PHP Code for Displaying and Then Adding to File

Table 12.4: ASP/JavaScript for Displaying and Then Adding to a File

Chapter 13: Cookies and Session Variables

Table 13.1: ASP/JavaScript for Displaying Form and Handling Form

Table 13.2: PHP Script for Displaying Form and Handling Form

Table 13.3: PHP Script for Setting Session Variables

Table 13.4: PHP Script Following Script Setting Session Variables

Table 13.5: ASP Script Setting Session Variables

Table 13.6: ASP Script Following Script that Sets Session Variables

Chapter 14: Shopping Cart

Table 14.1: PHP Script to Establish Connection to Database

Table 14.2: PHP Script for Creating the Tables for the Shopping Cart

Table 14.3: PHP Script to Add a New Product to the Catalog Table

Table 14.4: PHP Script for Uploading Image File to Illustrate a Product

Table 14.5: Initial PHP Script to Display Products to Customer

Table 14.6: Present Individual Product for Customer to Enter Quantity

Table 14.7: PHP Script to Display Current Shopping Cart

Table 14.8: Script to Display the Contents of the Shopping Cart

Table 14.9: PHP Script to Display and Handle Form for Customer Data

Table 14.10: The ASP/JavaScript Script to Connect to the Database

Table 14.11: The ASP/JavaScript Script for Inputting a New Product

Table 14.12: The ASP/JavaScript Script for Ordering Products

Table 14.13: The ASP/JavaScript Script for Specifying the Quantity

Table 14.14: The ASP/JavaScript Script Holding the Function for Formatting Money

Table 14.15: The ASP/JavaScript Script Displaying the Shopping Cart

Table 14.16: The ASP/JavaScript Script Holding the displaycart Function

Table 14.17 : The ASP/JavaScript Script to Collect and Handle Customer Information

Chapter 15: Quiz Show

Table 15.1: PHP Script to Establish Connection with Database

Table 15.2: PHP Script to Create the Tables for the Quiz Show Application

Table 15.3: PHP Script to Add Questions

Table 15.4: PHP Script for Signing In and Selecting a Category

Table 15.5: PHP Script that Finds Appropriate Question to Ask

Table 15.6: PHP Script for Checking Answer

Table 15.7: The PHP Script to Display the Scores of All the Players

Table 15.8: PHP Script to Clear Tables

Table 15.9: ASP/JavaScript Script to Establish Connection to Database

Table 15.10: ASP/JavaScript Script to Add a New Question

Table 15.11: Initial ASP/JavaScript for Signing In and Selecting a Category

Table 15.12: ASP/JavaScript for Choosing an Appropriate Question

Table 15.13: ASP/JavaScript Script to Check Answer

Table 15.14: ASP/JavaScript File Defining the rand Function

Table 15.15: The ASP/JavaScript Script for Displaying Scores

Chapter 16: Scaling Up Your Application

Table 16.1: PHP Code to Create Tables for Passwords

Table 16.2: PHP Code for Registration

Table 16.3: PHP Code for Signing In

Table 16.4: Code to Check for Valid User

Table 16.5: PHP Code for Signing User Out

Table 16.6: PHP Script to Show Contents of Password Table

Chapter 17: Emerging Trends

Table 17.1: PHP Code Handling XML Data