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.




Creating Database Web Applications with PHP and ASP
Creating Database Web Applications with PHP and ASP (Charles River Media Internet & Web Design)
ISBN: 1584502649
EAN: 2147483647
Year: 2005
Pages: 125
Authors: Jeanine Meyer

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net