Cart
Free Shipping in the UK
Proud to be B-Corp

Web Database Applications with PHP & MySQL Hugh E. Williams

Web Database Applications with PHP & MySQL By Hugh E. Williams

Web Database Applications with PHP & MySQL by Hugh E. Williams


£3.50
New RRP £31.95
Condition - Very Good
Only 2 left

Summary

This volume offers Web developers a mixture of theoretical and practical information on creating Web database applications. Using PHP, and MySQL, it offers detailed information on designing relational databases and Web application architecture.

Web Database Applications with PHP & MySQL Summary

Web Database Applications with PHP & MySQL by Hugh E. Williams

What do eBay, Amazon.com and CNN.com have in common? They're all applications that integrate large databases with the Web. The popularity of these applications stems from their accessibility and usability: thousands of users can access the same data at the same time without the need to install any additional software on their computers. This book 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. 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.

Web Database Applications with PHP & MySQL Reviews

"As symbolized by the duck-billed platypus on the cover it is a book that will help you to survive in a rapidly changing world. Submerge yourself in proven technology and emerge unscathed once the dots have fallen out by the wayside. Recommended for its excellent examples which will save you thousands in case you need to develop a similar application." Information Security Bulletin, July 2002 "The book manages to deliver on two levels at once - the concepts, planning and design process as well as implementation. It's also surprisingly well written, and manages not to be too smug or patronizing." - Nick Veitch, LinuxFormat, October 2002

About Hugh E. Williams

Hugh Williams is a senior lecturer in the School of Computer Science and IT at RMIT University in Melbourne, Australia, where he has taught for seven years. He currently teaches in two areas: database technology and web technology, and is the coordinator of a Masters program that focuses on the Internet and the Web. His research interests include building better search engines, bioinformatics, and designing faster data structures. When not at work Hugh likes to go running, watch Richmond play footy, and follow the cricket. Hugh has a PhD from RMIT University. Since the mid 1990s David Lane has worked as a software engineer and IT manager with the Multimedia Database Systems group at RMIT University in Melbourne, Australia. In that group he has helped to develop and commercialize the Structured Information Manager, a large-scale SGML/XML document repository and a high performance Web server. David has also worked with Australia's largest telecommunications company, Telstra, in areas as diverse as Satellite Communications, Human Factors Research, and Electronic Document Interchange (EDI). David has a Bachelor's degree in Applied Science (majoring in mathematics and computer science) from Swinburne University.

Table of Contents

Preface 1. Database Applications and the Web Three-Tier Architectures The Client Tier The Middle Tier The Database Tier Our Case Study 2. PHP Introducing PHP Conditions and Branches Loops A Worked Example Arrays Strings Regular Expressions Date and Time Functions Integer and Float Functions User-Defined Functions Objects Common Mistakes 3. MySQL and SQL Database Basics Quick Start Guide MySQL Command Interpreter Managing Databases, Tables, and Indexes Inserting, Updating, and Deleting Data Querying with SQL SELECT Join Queries Modifying the Database Functions More on SQL and MySQL 4. Querying Web Databases Connecting to a MySQL Database Formatting Results Case Study: The Front-Page Panel Interacting with Other DBMSs Using PHP 5. User-Driven Querying User Input Querying with User Input Case Study: Previous and Next Browsing Case Study: Producing a select List 6. Writing to Web Databases Database Inserts, Updates, and Deletes Issues in Writing Data to Databases 7. Validation on the Server and Client Validation and Error Reporting for Web Database Applications Server-Side Validation Client-Side Validation with JavaScript 8. Sessions Building Applications That Keep State Session Management Over the Web PHP Session Management Case Study: Adding Sessions to the Winestore When to Use Sessions 9. Authentication and Security HTTP Authentication HTTP Authentication with PHP Authentication Using a Database Web Database Applications and Authentication Protecting Data on the Web 10. Winestore Customer Management Overview of the Winestore Application Customer Management Authenticating Users The Winestore Include Files 11. The Winestore Shopping Cart The Winestore Home Page The Shopping Cart Architecture Managing Redirection 12. Ordering and Shipping at the Winestore Finalizing Orders HTML and Email Receipts 13. Related Topics Automated Housekeeping Templates Searching and Browsing A. Installation Guide B. Internet and Web Protocols C. Modeling and Designing Relational Databases D. Managing Sessions in the Database Tier E. Resources Index

Additional information

GOR001551239
9780596000417
0596000413
Web Database Applications with PHP & MySQL by Hugh E. Williams
Used - Very Good
Paperback
O'Reilly Media, Inc, USA
2002-04-04
560
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - Web Database Applications with PHP & MySQL