Books & Videos

Table of Contents

  1. Chapter 1 Database Applications and the Web

    1. Three-Tier Architectures

    2. The Client Tier

    3. The Middle Tier

    4. The Database Tier

    5. Our Case Study

  2. Chapter 2 PHP

    1. Introducing PHP

    2. Conditions and Branches

    3. Loops

    4. A Working Example

    5. Arrays

    6. Strings

    7. Regular Expressions

    8. Date and Time Functions

    9. Integer and Float Functions

    10. User-Defined Functions

    11. Objects

    12. Common Mistakes

  3. Chapter 3 MySQL and SQL

    1. Database Basics

    2. Quick Start Guide

    3. MySQL Command Interpreter

    4. Managing Databases, Tables, and Indexes

    5. Inserting, Updating, and Deleting Data

    6. Querying with SQL SELECT

    7. Join Queries

    8. Modifying the Database

    9. Functions

    10. More on SQL and MySQL

  4. Chapter 4 Querying Web Databases

    1. Connecting to a MySQL Database

    2. Formatting Results

    3. Case Study: The Front-Page Panel

    4. Interacting with Other DBMSs Using PHP

  5. Chapter 5 User-Driven Querying

    1. User Input

    2. Querying with User Input

    3. Case Study: Previous and Next Browsing

    4. Case Study: Producing a select List

  6. Chapter 6 Writing to Web Databases

    1. Database Inserts, Updates, and Deletes

    2. Issues in Writing Data to Databases

  7. Chapter 7 Validation on the Server and Client

    1. Validation and Error Reporting for Web Database Applications

    2. Server-Side Validation

    3. Client-Side Validation with JavaScript

  8. Chapter 8 Sessions

    1. Building Applications That Keep State

    2. Session Management Over the Web

    3. PHP Session Management

    4. Case Study: Adding Sessions to the Winestore

    5. When to Use Sessions

  9. Chapter 9 Authentication and Security

    1. HTTP Authentication

    2. HTTP Authentication with PHP

    3. Authentication Using a Database

    4. Web Database Applications and Authentication

    5. Protecting Data on the Web

  10. Chapter 10 Winestore Customer Management

    1. Overview of the Winestore Application

    2. Customer Management

    3. Authenticating Users

    4. The Winestore Include Files

  11. Chapter 11 The Winestore Shopping Cart

    1. The Winestore Home Page

    2. The Shopping Cart Architecture

    3. Managing Redirection

  12. Chapter 12 Ordering and Shipping at the Winestore

    1. Finalizing Orders

    2. HTML and Email Receipts

  13. Chapter 13 Related Topics

    1. Automated Housekeeping

    2. Templates

    3. Searching and Browsing

  1. Appendix Installation Guide

    1. Installing MySQL, Apache, and PHP

    2. Installing the Winestore Examples

    3. Installing Apache to Use SSL

    4. Installation Resources

  2. Appendix Internet and Web Protocols

    1. The Internet

    2. Hypertext Transfer Protocol

  3. Appendix Modeling and Designing Relational Databases

    1. The Relational Model

    2. Entity-Relationship Modeling

  4. Appendix Managing Sessions in the Database Tier

    1. Using a Database to Keep State

    2. PHP Session Management

    3. MySQL Session Store

  5. Appendix Resources

    1. Client Tier Resources

    2. Middle Tier Resources

    3. Database Tier Resources

    4. Security and Cryptography Resources

  6. Colophon