Close Notification

Your cart does not contain any items

Web Database Applications with PHP and MySQL

Hugh E. Williams David Lane

$98.95   $89.45


Not in-store but you can order this
How long will it take?


O'Reilly Media, Inc, USA
27 May 2004
Introductions to PHP, SQL, and MySQL administration
By:   Hugh E. Williams, David Lane
Imprint:   O'Reilly Media, Inc, USA
Country of Publication:   United States
Edition:   2nd Revised edition
Dimensions:   Height: 232mm,  Width: 178mm,  Spine: 43mm
Weight:   1.270kg
ISBN:   9780596005436
ISBN 10:   0596005431
Pages:   795
Publication Date:   27 May 2004
Audience:   College/higher education ,  Professional and scholarly ,  Primary ,  Undergraduate
Format:   Paperback
Publisher's Status:   Active
Preface 1. Database Applications and the Web The Web Three-Tier Architectures 2. The PHP Scripting Language Introducing PHP Conditions and Branches Loops Functions Working with Types User-Defined Functions A Working Example 3. Arrays, Strings, and Advanced Data Manipulation in PHP Arrays Strings Regular Expressions Dates and Times Integers and Floats 4. Introduction to Object-Oriented Programming with PHP 5 Classes and Objects Inheritance Throwing and Catching Exceptions 5. SQL and MySQL Database Basics MySQL Command Interpreter Managing Databases and Tables Inserting, Updating, and Deleting Data Querying with SQL SELECT Join Queries Case Study: Adding a New Wine 6. Querying Web Databases Querying a MySQL Database Using PHP Processing User Input MySQL Function Reference 7. PEAR Overview Core Components Packages 8. Writing to Web Databases Database Inserts, Updates, and Deletes Issues in Writing Data to Databases 9. Validation with PHP and JavaScript Validation and Error Reporting Principles Server-Side Validation with PHP JavaScript and Client-Side Validation 10. Sessions Introducing Session Management PHP Session Management Case Study: Using Sessions in Validation When to Use Sessions PHP Session API and Configuration 11. Authentication and Security HTTP Authentication HTTP Authentication with PHP Form-Based Authentication Protecting Data on the Web 12. Errors, Debugging, and Deployment Errors Common Programming Errors Custom Error Handlers 13. Reporting Creating a Report Producing PDF PDF-PHP Reference 14. Advanced Features of Object-Oriented Programming in PHP 5 Working with Class Hierarchies Class Type Hints Abstract Classes and Interfaces Freight Calculator Example 15. Advanced SQL Exploring with SHOW Advanced Querying Manipulating Data and Databases Functions Automating Querying Table Types Backup and Recovery Managing Users and Privileges Tuning MySQL 16. Hugh and Dave's Online Wines: A Case Study Functional and System Requirements Application Overview Common Components 17. Managing Customers Code Overview Customer Validation The Customer Form 18. The Shopping Cart Code Overview The Winestore Home Page The Shopping Cart Implementation 19. Ordering and Shipping at the Online Winestore Code Overview Credit Card and Shipping Instructions Finalizing Orders HTML and Email Receipts 20. Searching and Authentication in the Online Winestore Code Overview Searching and Browsing Authentication A. Linux Installation Guide B. Microsoft Windows Installation Guide C. Mac OS X Installation Guide D. Web Protocols E. Modeling and Designing Relational Databases F. Managing Sessions in the Database Tier G. Resources H. The Improved MySQL Library Index

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.

See Also