Web Database Applications With Php and Mysql

by Williams, Hugh E.; Lane, David

• ISBN13: 9780596000417
• ISBN10: 0596000413
• Format: Paperback
• Copyright: 2002-03-01
• Publisher: Oreilly & Associates Inc

Summary

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 offers web 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 Online Wines, 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.

Author Biography

Hugh E. Williams is a senior lecturer -- specializing in database and web technology -- in the School of Computer Science and IT at RMIT University in Melbourne, Australia David Lane is a software engineer and IT manager in the Multimedia Database Systems group, also at RMIT University in Melbourne, Australia

Table of Contents

Preface	ix
Database Applications and the Web	1	(26)
Three-Tier Architectures	2	(4)
The Client Tier	6	(1)
The Middle Tier	7	(4)
The Database Tier	11	(6)
Our Case Study	17	(10)
PHP	27	(82)
Introducing PHP	28	(12)
Conditions and Branches	40	(5)
Loops	45	(4)
A Worked Example	49	(3)
Arrays	52	(13)
Strings	65	(11)
Regular Expressions	76	(8)
Date and Time Functions	84	(4)
Integer and Float Functions	88	(3)
User-Defined Functions	91	(8)
Objects	99	(5)
Common Mistakes	104	(5)
MySQL and SQL	109	(51)
Database Basics	110	(3)
Quick Start Guide	113	(5)
MySQL Command Interpreter	118	(1)
Managing Databases, Tables, and Indexes	119	(4)
Inserting, Updating, and Deleting Data	123	(5)
Querying with SQL SELECT	128	(7)
Join Queries	135	(6)
Modifying the Database	141	(6)
Functions	147	(4)
More on SQL and MySQL	151	(9)
Querying Web Databases	160	(42)
Connecting to a MySQL Database	162	(15)
Formatting Results	177	(3)
Case Study: The Front-Page Panel	180	(15)
Interacting with Other DBMSs Using PHP	195	(7)
User-Driven Querying	202	(39)
User Input	204	(12)
Querying with User Input	216	(10)
Case Study: Previous and Next Browsing	226	(10)
Case Study: Producing a select List	236	(5)
Writing to Web Databases	241	(38)
Database Inserts, Updates, and Deletes	242	(24)
Issues in Writing Data to Databases	266	(13)
Validation on the Server and Client	279	(30)
Validation and Error Reporting for Web Database Applications	280	(2)
Server-Side Validation	282	(9)
Client-Side Validation with JavaScript	291	(18)
Sessions	309	(32)
Building Applications That Keep State	310	(3)
Session Management over the Web	313	(1)
PHP Session Management	314	(12)
Case Study: Adding Sessions to the Winestore	326	(10)
When to Use Sessions	336	(5)
Authentication and Security	341	(31)
HTTP Authentication	341	(4)
HTTP Authentication with PHP	345	(5)
Authentication Using a Database	350	(5)
Web Database Applications and Authentication	355	(13)
Protecting Data on the Web	368	(4)
Winestore Customer Management	372	(40)
Overview of the Winestore Application	373	(5)
Customer Management	378	(17)
Authenticating Users	395	(5)
The Winestore Include Files	400	(12)
The Winestore Shopping Cart	412	(23)
The Winestore Home Page	413	(3)
The Shopping Cart Architecture	416	(15)
Managing Redirection	431	(4)
Ordering and Shipping at the Winestore	435	(18)
Finalizing Orders	435	(7)
HTML and Email Receipts	442	(11)
Related Topics	453	(18)
Automated Housekeeping	453	(2)
Templates	455	(8)
Searching and Browsing	463	(8)
A. Installation Guide	471	(14)
B. Internet and Web Protocols	485	(19)
C. Modeling and Designing Relational Databases	504	(19)
D. Managing Sessions in the Database Tier	523	(14)
E. Resources	537	(14)
Index	551