Figure 12.2 The common interface cycle.

Day 13: How to Use MyODBC

Figure 13.1 The MyODBC installation program.

Figure 13.2 The MySQL driver installation dialog box.

Figure 13.3 Data Sources dialog box.

Figure 13.4 The Control Panel.

Figure 13.5 The Data Sources Administrator.

Figure 13.6 The System DSN pane.

Figure 13.7 Creating a new Data Source.

Figure 13.8 The configuration screen.

Figure 13.9 The Guest Book Form.

Figure 13.10 The output of GuestBook.asp.

Figure 13.11 A Web page generated using VBScript with Active Server Pages.

Day 14: The Perl Database Interface

Figure 14.1 Handling data using a Web form.

Figure 14.2 Sending confirmation back to the browser.

Day 15: MySQL and PHP

Figure 15.1 Exiting a loop using break and continue.

Day 17: MySQL Database Security

Figure 17.1 The connection verification stage.

Figure 17.2 The request verification process.

Day 20: Optimizing MySQL

Figure 20.1 A variable-length column before and after an UPDATE.

Day 21: Putting It All Together

Figure 21.1 The Meet-A-Geek Web site flowchart.

Figure 21.2 The Meet_A_Geek database model.

Figure 21.3 The Meet-A-Geek New Customer Application form.

Figure 21.4 The login form.

Figure 21.5 The Post an Ad Web page from the Login.pl script.

Figure 21.6 The search form.

Figure 21.7 Search ad results.

List of Tables

Day 3: Designing Your First Database

Table 3.1 The Products Object

Table 3.2 The Completed Business Objects

Day 5: Making Your Data Normal

Table 5.1 Schema for Customers Database

Table 5.2 Eliminating Data Repetition in a Database

Table 5.3 First Normal Form

Table 5.4 Eliminating Partial Dependencies—Second Normal Form

Table 5.5 Eliminating Non-Key Data for Third Normal Form

Day 7: MySQL Data Types

Table 7.1 Numeric Storage

Table 7.2 Numeric Types

Table 7.3 String Types

Table 7.4 Column Modifiers

Day 8: Populating the Database

Table 8.1 mysqlimport Options

Table 8.2 mysqldump Options

Table 8.3 mysqlimport Options

Day 9: Querying the Database

Table 9.1 Reserved Words

Table 9.2 Results of Concatenation

Table 9.3 Aggregate Functions with GROUP BY

Day 11: MySQL Table Locks and Assorted Keys

Table 11.1 Composite Partial Keys