Ships from: San Mateo, CA
Usually ships in 1-2 business days
Ships from: Phoenix, AZ
Usually ships in 1-2 business days
Ships from: fallbrook, CA
Usually ships in 1-2 business days
Ships from: Springfield, VA
Usually ships in 1-2 business days
Ships from: acton, MA
Usually ships in 1-2 business days
What do eBay, Amazon.com and CNN.com have in common? They're all applications that integrate large databases with the Web. The popularity (and power) of these applications stems from their accessibility and usability: thousands of users can access the same data at the same time without theneed to install any additional software on their computers.Web Database Applications with PHP and MySQL offersweb developers a mixture of theoretical and practical information on creating web database applications. Using PHP, and MySQL, two open source technologies that are often combined to develop web applications, the book offers detailed information on designing relational databases and on web application architecture, both of which will be useful to readers who have never dealt with these issues before. The book also introduces Hugh and Dave's OnlineWines, a complete (but fictional) online retail site that allows users to browse, search a database, add items to a shopping cart, manage their membership, and purchase wines. Using this site as an example, the book shows you how to implement searching and browsing, store user data, validate user input, manage transactions, and maintain security.If you want to build small to medium-scale web database applications that can run on modest hardware and process more than a million hits a day from users, this book will show you how.
Preface;
What This Book Is About;
What You Need to Know;
How This Book Is Organized;
How to Use This Book;
Conventions Used in This Book;
How to Contact Us;
Web Site and Code Examples;
Acknowledgments;
Chapter 1: Database Applications and the Web;
1.1 Three-Tier Architectures;
1.2 The Client Tier;
1.3 The Middle Tier;
1.4 The Database Tier;
1.5 Our Case Study;
Chapter 2: PHP;
2.1 Introducing PHP;
2.2 Conditions and Branches;
2.3 Loops;
2.4 A Working Example;
2.5 Arrays;
2.6 Strings;
2.7 Regular Expressions;
2.8 Date and Time Functions;
2.9 Integer and Float Functions;
2.10 User-Defined Functions;
2.11 Objects;
2.12 Common Mistakes;
Chapter 3: MySQL and SQL;
3.1 Database Basics;
3.2 Quick Start Guide;
3.3 MySQL Command Interpreter;
3.4 Managing Databases, Tables, and Indexes;
3.5 Inserting, Updating, and Deleting Data;
3.6 Querying with SQL SELECT;
3.7 Join Queries;
3.8 Modifying the Database;
3.9 Functions;
3.10 More on SQL and MySQL;
Chapter 4: Querying Web Databases;
4.1 Connecting to a MySQL Database;
4.2 Formatting Results;
4.3 Case Study: The Front-Page Panel;
4.4 Interacting with Other DBMSs Using PHP;
Chapter 5: User-Driven Querying;
5.1 User Input;
5.2 Querying with User Input;
5.3 Case Study: Previous and Next Browsing;
5.4 Case Study: Producing a select List;
Chapter 6: Writing to Web Databases;
6.1 Database Inserts, Updates, and Deletes;
6.2 Issues in Writing Data to Databases;
Chapter 7: Validation on the Server and Client;
7.1 Validation and Error Reporting for Web Database Applications;
7.2 Server-Side Validation;
7.3 Client-Side Validation with JavaScript;
Chapter 8: Sessions;
8.1 Building Applications That Keep State;
8.2 Session Management Over the Web;
8.3 PHP Session Management;
8.4 Case Study: Adding Sessions to the Winestore;
8.5 When to Use Sessions;
Chapter 9: Authentication and Security;
9.1 HTTP Authentication;
9.2 HTTP Authentication with PHP;
9.3 Authentication Using a Database;
9.4 Web Database Applications and Authentication;
9.5 Protecting Data on the Web;
Chapter 10: Winestore Customer Management;
10.1 Overview of the Winestore Application;
10.2 Customer Management;
10.3 Authenticating Users;
10.4 The Winestore Include Files;
Chapter 11: The Winestore Shopping Cart;
11.1 The Winestore Home Page;
11.2 The Shopping Cart Architecture;
11.3 Managing Redirection;
Chapter 12: Ordering and Shipping at the Winestore;
12.1 Finalizing Orders;
12.2 HTML and Email Receipts;
Chapter 13: Related Topics;
13.1 Automated Housekeeping;
13.2 Templates;
13.3 Searching and Browsing;
Installation Guide;
Installing MySQL, Apache, and PHP;
Installing the Winestore Examples;
Installing Apache to Use SSL;
Installation Resources;
Internet and Web Protocols;
The Internet;
Hypertext Transfer Protocol;
Modeling and Designing Relational Databases;
The Relational Model;
Entity-Relationship Modeling;
Managing Sessions in the Database Tier;
Using a Database to Keep State;
PHP Session Management;
MySQL Session Store;
Resources;
Client Tier Resources;
Middle Tier Resources;
Database Tier Resources;
Security and Cryptography Resources;
Colophon;
Overview
What do eBay, Amazon.com and CNN.com have in common? They're all applications that integrate large databases with the Web. The popularity (and power) of these applications stems from their accessibility and usability: thousands of users can access the same data at the same time without theneed to install any additional software on their computers.Web Database Applications with PHP and MySQL offersweb developers a mixture of theoretical and practical information on creating web database applications. Using PHP, ...