- Shopping Bag ( 0 items )
Through a sophisticated sample application--Hugh and Dave's Wine Store--all the important techniques of dynamic content are introduced. Good design is emphasized, such as dividing logic from presentation. The book introduces PHP5 and MySQL4.1 features, while providing techniques that can be used on older versions of the software that are still in widespread use.
This new edition has been redesigned around the rich offerings of PEAR. Several of these, including the Template package and the database-independent query API, are fully integrated into examples and thoroughly described in the text. Topics include:
Installation and configuration of Apache, MySQL, and PHP on Unix® , Windows® , and Mac OS® X systems
Introductions to PHP, SQL, and MySQL administration
Session management, including the use of a custom database for improved efficiency
User input validation, security, and authentication
The PEAR repository, plus details on the use of PEAR DB and Template classes
Production of PDF reports
1. Database Applications and the Web.
2. The PHP Scripting Language.
Conditions and Branches
Working with Types
A Working Example
3. Arrays, Strings, and Advanced Data Manipulation in PHP.
Dates and Times
Integers and Floats
4. Introduction to Object-Oriented Programming with PHP 5.
Classes and Objects
Throwing and Catching Exceptions
5. SQL and MySQL.
MySQL Command Interpreter
Managing Databases and Tables
Inserting, Updating, and Deleting Data
Querying with SQL SELECT
Case Study: Adding a New Wine
6. Querying Web Databases.
Querying a MySQL Database Using PHP
Processing User Input
MySQL Function Reference
8. Writing to Web Databases.
Database Inserts, Updates, and Deletes
Issues in Writing Data to Databases
Validation and Error Reporting Principles
Server-Side Validation with PHP
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 with PHP
Protecting Data on the Web
12. Errors, Debugging, and Deployment.
Common Programming Errors
Custom Error Handlers
Creating a Report
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
Manipulating Data and Databases
Backup and Recovery
Managing Users and Privileges
16. Hugh and Dave's Online Wines: A Case Study.
Functional and System Requirements
17. Managing Customers.
The Customer Form
18. The Shopping Cart.
The Winestore Home Page
The Shopping Cart Implementation
19. Ordering and Shipping at the Online Winestore.
Credit Card and Shipping Instructions
HTML and Email Receipts
20. Searching and Authentication in the Online Winestore.
Searching and Browsing
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
H. The Improved MySQL Library