Web Database Applications with PHP and MySQL Building Effective Database-Driven Web Sites

Name: Web Database Applications with PHP and MySQL Building Effective Database-Driven Web Sites
Price: 5.7 USD
Availability: InStock
ISBN: 9780596005436

ISBN-10: 0596005431

ISBN-13: 9780596005436

Edition: 2nd 2004

Authors: Hugh E. Williams, David Lane

List price: $49.99

30 day, 100% satisfaction guarantee!

Marketplace

3 new & used from $5.70

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

There are many reasons for serving up dynamic content from a web site: to offer an online shopping site, create customized information pages for users, or just manage a large volume of content through a database. Anyone with a modest knowledge of HTML and web site management can learn to create dynamic content through the PHP programming language and the MySQL database. This book gives you the background and tools to do the job safely and reliably. "Web Database Applications with PHP and MySQL, Second Edition thoroughly reflects the needs of real-world applications. It goes into detail on such practical issues as validating input (do you know what a proper credit card number looks like?),…

Book details

List price: $49.99
Edition: 2nd
Copyright year: 2004
Publisher: O'Reilly Media, Incorporated
Publication date: 6/8/2004
Binding: Paperback
Pages: 820
Size: 7.00" wide x 9.19" long x 1.70" tall
Weight: 2.530
Language: English

Hugh E. Williams is a software design engineer at Microsoft's WindowsLive Search in Redmond, WA. Previously, he was the AssociateProfessor in Information Retrieval at RMIT University in Melbourne,Australia. He's published over 70 research papers and holds around 10patents, mostly in the search engine area. When not at work Hughlikes to hang out with his family, exercise, watch Richmond playfooty, and learn about baseball. Hugh has a PhD from RMIT University.His home page is http://hughwilliams.com .



Preface



Database Applications and the Web


The Web


Three-Tier Architectures



The PHP Scripting Language


Introducing PHP


Conditions and Branches


Loops


Functions


Working with Types


User-Defined Functions


A Working Example



Arrays, Strings, and Advanced Data Manipulation in PHP


Arrays


Strings


Regular Expressions


Dates and Times


Integers and Floats



Introduction to Object-Oriented Programming with PHP 5


Classes and Objects


Inheritance


Throwing and Catching Exceptions



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



Querying Web Databases


Querying a MySQL Database Using PHP


Processing User Input


MySQL Function Reference



Pear


Overview


Core Components


Packages



Writing to Web Databases


Database Inserts, Updates, and Deletes


Issues in Writing Data to Databases



Validation with PHP and JavaScript


Validation and Error Reporting Principles


Server-Side Validation with PHP


JavaScript and Client-Side Validation



Sessions


Introducing Session Management


PHP Session Management


Case Study: Using Sessions in Validation


When to Use Sessions


PHP Session API and Configuration



Authentication and Security


HTTP Authentication


HTTP Authentication with PHP


Form-Based Authentication


Protecting Data on the Web



Errors, Debugging, and Deployment


Errors


Common Programming Errors


Custom Error Handlers



Reporting


Creating a Report


Producing PDF


PDF-PHP Reference



Advanced Features of Object-Oriented Programming in PHP 5


Working with Class Hierarchies


Class Type Hints


Abstract Classes and Interfaces


Freight Calculator Example



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



Hugh and Dave's Online Wines: A Case Study


Functional and System Requirements


Application Overview


Common Components



Managing Customers


Code Overview


Customer Validation


The Customer Form



The Shopping Cart


Code Overview


The Winestore Home Page


The Shopping Cart Implementation



Ordering and Shipping at the Online Winestore


Code Overview


Credit Card and Shipping Instructions


Finalizing Orders


HTML and Email Receipts



Searching and Authentication in the Online Winestore


Code Overview


Searching and Browsing


Authentication



Linux Installation Guide



Microsoft Windows Installation Guide



Mac OS X Installation Guide



Web Protocols



Modeling and Designing Relational Databases



Managing Sessions in the Database Tier



Resources



The Improved MySQL Library


Index