Williams, Hugh E.
Web database applications with PHP and MySQL / Hugh E. Williams and David Lane. - 2nd ed. - Sebastopol : O'Reilly, c2004. - xviii, 796 p. : ill. ; 24 cm.
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 -- 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 -- The Improved MySQL Library.
Demonstrates techniques of dynamic content through a complex sample application. Presents principles of good design, such as dividing logic from presentation. Introduces PHP 5 and MySQL 4.1 features, while providing techniques that can be used on older versions of the software that are still in widespread use.
0596005431 9780596005436
2004559158
MySQL (Electronic resource)
PHP (Computer program language)
Web sites--Design.
QA76.73.P224 / W55 2004
005.13/3
Web database applications with PHP and MySQL / Hugh E. Williams and David Lane. - 2nd ed. - Sebastopol : O'Reilly, c2004. - xviii, 796 p. : ill. ; 24 cm.
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 -- 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 -- The Improved MySQL Library.
Demonstrates techniques of dynamic content through a complex sample application. Presents principles of good design, such as dividing logic from presentation. Introduces PHP 5 and MySQL 4.1 features, while providing techniques that can be used on older versions of the software that are still in widespread use.
0596005431 9780596005436
2004559158
MySQL (Electronic resource)
PHP (Computer program language)
Web sites--Design.
QA76.73.P224 / W55 2004
005.13/3