|
" Web database applications with PHP & MySQL / "
Hugh E. Williams and David Lane.
Document Type
|
:
|
BL
|
Record Number
|
:
|
705247
|
Doc. No
|
:
|
b527436
|
Main Entry
|
:
|
Williams, Hugh E.
|
Title & Author
|
:
|
Web database applications with PHP MySQL /\ Hugh E. Williams and David Lane.
|
Edition Statement
|
:
|
Second edition.
|
Publication Statement
|
:
|
Sebastopol, Calif. :: O'Reilly,, [2004]
|
|
:
|
, c2004
|
Page. NO
|
:
|
xviii, 796 pages :: illustrations ;; 24 cm
|
ISBN
|
:
|
0596005431
|
|
:
|
: 9780596005436
|
Bibliographies/Indexes
|
:
|
Includes index.
|
Contents
|
:
|
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.
|
Abstract
|
:
|
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.
|
Subject
|
:
|
PHP (Computer program language)
|
Subject
|
:
|
SQL (Computer program language)
|
Subject
|
:
|
Web sites-- Design.
|
Added Entry
|
:
|
Lane, David,1964-
|
| |