List of Figures

Chapter 1: Introduction

Figure 1.1: Request from client to server

Figure 1.2: Entity relationship diagram.

Figure 1.3: Entity relationship diagram for quiz show database.

Figure 1.4: Process diagram for quiz show application.

Figure 1.5: Storyboard for quiz show application.

Chapter 2: Basic HTML

Figure 2.1: Browser File pull-down menu.

Figure 2.2: Display of simple HTML file.

Figure 2.3: HTML example.

Figure 2.4: Narrowed window for HTML example.

Figure 2.5: HTML example with images.

Figure 2.6: HTML example with mistakes.

Figure 2.7: Table of numbers.

Figure 2.8: Names and images formatted using a table.

Chapter 3: HTML Forms and Client-Side JavaScript

Figure 3.1: Sample form.

Figure 3.2: Entity relationship diagram.

Figure 3.3: Form to be filled out.

Figure 3.4: Filled-out form.

Figure 3.5: Error message in JavaScript console. Web browser 2003 Netscape.

Figure 3.6: Display of HTML with Alert box.

Figure 3.7: Initial display showing first image.

Figure 3.8: Display of second image.

Figure 3.9: Starting display of HTML slide show.

Figure 3.10: Display of slide show with a different image.

Chapter 4: Server-Side Basics

Figure 4.1: Initial screen for state capital quiz.

Figure 4.2: Asking for the capital.

Figure 4.3: Player enters an incorrect answer.

Figure 4.4: System responds to incorrect answer.

Figure 4.5: System responds to correct answer.

Figure 4.6: Address window showing call to miniquizask.php and form input.

Figure 4.7: Address window showing call to miniquizcheck.php and form input.

Chapter 5: Database Basics

Figure 5.1: Entity-relationship diagram for simple orders.

Figure 5.2: Entity relationship diagram for multiproduct orders.

Figure 5.3: Entity-relationship diagram for courses.

Figure 5.4: Entity-relationship diagram for courses with prerequisites.

Chapter 6: Analysis and Design of Applications

Figure 6.1: Process diagram for ordering system.

Figure 6.2: Storyboard for state capital quiz.

Figure 6.3: Process diagram for state capitals quiz.

Figure 6.4: First draft of process diagram for state capital quiz.

Figure 6.5: Process diagram for state capital quiz.

Figure 6.6: Storyboard for state capitals quiz, showing included file.

Chapter 8: Database Management Systems: MySQL and Access

Figure 8.1: Windows Run prompt.

Figure 8.2: Command prompt screen.

Figure 8.3: Sequence of commands to get to the MySql folder.

Figure 8.4: Command to reach the bin subfolder.

Figure 8.5: Commands to invoke MySQL.

Figure 8.6: The result of the show databases command.

Figure 8.7: The drop database command.

Figure 8.8: The create database test command.

Figure 8.9: A MySQL command with an error.

Figure 8.10: The use test command.

Figure 8.11: Multiline create command.

Figure 8.12: The show tables command, with the result

Figure 8.13: The describe catalog command, with the result.

Figure 8.14: An insert command.

Figure 8.15: More insert commands, including an error.

Figure 8.16: Starting MySQL, issuing a use command, and obtaining commands from a source file.

Figure 8.17: Select command with result.

Figure 8.18: Contents of catalog table shown before and after deletion of a record.

Figure 8.19: Microsoft Access window for creating a new database.

Figure 8.20: Access window for creating a table.

Figure 8.21: Access window for specifying fields in a table.

Figure 8.22: Options for data type for field.

Figure 8.23: Window for defining field information, when datatype is AutoNumber.

Figure 8.24: Specifying a field as a primary key; arrow indicates icon.

Figure 8.25: Window for defining field when data type is Text.

Figure 8.26: Window defining field with description entered.

Figure 8.27: Window for defining fields: three fields defined.

Figure 8.28: Partial screen shot of window defining field, showing currency option.

Figure 8.29: Screen show showing four fields defined.

Figure 8.30: Window to save and name table.

Figure 8.31: Icon to return to database.

Figure 8.32: Window showing option to create another table or work with catalog table.

Figure 8.33: Window to enter records into the catalog table.

Figure 8.34: The catalog table with sample data.

Figure 8.35: Window with options for specifying queries.

Figure 8.36: Window for specifying queries.

Figure 8.37: Screen showing start of process of defining a query graphically.

Figure 8.38: Screen shot showing process of defining query.

Figure 8.39: Arrow shows symbol to execute query.

Figure 8.40: Results of query against sample data.

Figure 8.41: Option to obtain SQL representation of query.

Figure 8.42: SQL statement representing query generated graphically.

Chapter 9: Connecting to the Database

Figure 9.1: Control Panel.

Figure 9.2: ODBC panel.

Figure 9.3: System Data Sources already set up.

Figure 9.4: Panel to create a new data source.

Figure 9.5: Panel to enter data for DSN.

Figure 9.6: Form for DSN with entries

Figure 9.7: Window to select file.

Figure 9.8: Form after selecting actual file.

Figure 9.9: Screen capture showing misplaced table.

Chapter 10: Connecting to a Database: Advanced

Figure 10.1: Display of titles.

Figure 10.2: Storyboard for dropping title application.

Figure 10.3: Storyboard for update application.

Figure 10.4: Access window.

Figure 10.5: Options under Tools.

Figure 10.6: Relationships window: see arrow pointing to view.

Figure 10.7: Show Table window.

Figure 10.8: Tables showed to use to define relationship.

Figure 10.9: Edit Relationships window.

Figure 10.10: Window to define relationships by specifying tables and fields.

Figure 10.11: Completed entry to specify new relationship.

Figure 10.12: Window to edit information on relationship.

Figure 10.13: Relationship shown as partially hidden line.

Figure 10.14: Relationship shown after moving table symbols.

Figure 10.15: Diagram showing two relationships.

Chapter 11: Regular Expressions

Figure 11.1: Travel form filled in.

Figure 11.2: Display of Screen Capture of Response to Validated Data

Figure 11.3: Form with incorrect data.

Figure 11.4: Response in case of errors.

Figure 11.5: Screen capture requesting problem term.

Figure 11.6: Problem entered into form.

Figure 11.7: Screen capture for response for warnings containing the problem term.

Chapter 12: Files

Figure 12.1: Display of scores plus form.

Figure 12.2: Form for specifying file to upload.

Figure 12.3: Window to browse and specify file for uploading.

Figure 12.4: Screen showing message plus form for new upload.

Chapter 13: Cookies and Session Variables

Figure 13.1: Search window.

Figure 13.2: Results of search.

Figure 13.3: Internet Explorer Cookies folder. Web browser 2003 Microsoft Corp.

Figure 13.4: Netscape Tools drop-down menu showing Cookie Manager. Web browser 2003 Netscape.

Figure 13.5: Cookie Manager in Netscape.

Figure 13.6: Form to enter information to be stored as cookie. Web browser 2003 Netscape

Figure 13.7: Form filled in.

Figure 13.8: Response to form.

Figure 13.9: Screen shot showing warning messages.

Figure 13.10: Form for obtaining information.

Figure 13.11: Filled-in form.

Figure 13.12: Screen showing response.

Figure 13.13: Shot of follow-up screen.

Chapter 14: Shopping Cart

Figure 14.1: Initial screen for origami store.

Figure 14.2: Screen to specify quantity.

Figure 14.3: Contents of the shopping cart.

Figure 14.4: Form to enter customer information.

Figure 14.5: Entity-relationship diagram for orders application.

Figure 14.6: Process diagram for the shopping cart.

Figure 14.7: Storyboard for the shopping cart.

Chapter 15: Quiz Show

Figure 15.1: Initial screen for quiz show.

Figure 15.2: Question from trivia category.

Figure 15.3: Response to correct answer.

Figure 15.4: Entity-relationship diagram for quiz show.

Figure 15.5: Process diagram for quiz show.

Figure 15.6: Storyboard for quiz show.

Chapter 16: Scaling Up Your Application

Figure 16.1: Form for creating user ID and password.

Figure 16.2: Form for signing in.

Figure 16.3: Screen showing successful sign in.

Figure 16.4: Screen showing goodbye message.

Figure 16.5: Display of IDs and encrypted passwords.