Web Database Applications With Php And Mysql (2nd Edition) [Electronic resources] نسخه متنی

• Table of Contents

• Index

• Reviews

• Reader Reviews

• Errata

• Academic

Web Database Application with PHP and MySQL, 2nd Edition

By
David Lane, Hugh E. Williams

Publisher: O''Reilly

Pub Date: May 2004

ISBN: 0-596-00543-1

Pages: 816

Copyright

Preface

What This Book Is About

What You Need to Know

How This Book Is Organized

How to Use This Book

Conventions Used in This Book

Using Code Examples

How to Contact Us

Web Site and Code Examples

Acknowledgments

Chapter 1.
Database Applications and the Web

Section 1.1.
The Web

Section 1.2.
Three-Tier Architectures

Chapter 2.
The PHP Scripting Language

Section 2.1.
Introducing PHP

Section 2.2.
Conditions and Branches

Section 2.3.
Loops

Section 2.4.
Functions

Section 2.5.
Working with Types

Section 2.6.
User-Defined Functions

Section 2.7.
A Working Example

Chapter 3.
Arrays, Strings, and Advanced Data Manipulation in PHP

Section 3.1.
Arrays

Section 3.2.
Strings

Section 3.3.
Regular Expressions

Section 3.4.
Dates and Times

Section 3.5.
Integers and Floats

Chapter 4.
Introduction to Object-Oriented Programming with PHP 5

Section 4.1.
Classes and Objects

Section 4.2.
Inheritance

Section 4.3.
Throwing and Catching Exceptions

Chapter 5.
SQL and MySQL

Section 5.1.
Database Basics

Section 5.2.
MySQL Command Interpreter

Section 5.3.
Managing Databases and Tables

Section 5.4.
Inserting, Updating, and Deleting Data

Section 5.5.
Querying with SQL SELECT

Section 5.6.
Join Queries

Section 5.7.
Case Study: Adding a New Wine

Chapter 6.
Querying Web Databases

Section 6.1.
Querying a MySQL Database Using PHP

Section 6.2.
Processing User Input

Section 6.3.
MySQL Function Reference

Chapter 7.
PEAR

Section 7.1.
Overview

Section 7.2.
Core Components

Section 7.3.
Packages

Chapter 8.
Writing to Web Databases

Section 8.1.
Database Inserts, Updates, and Deletes

Section 8.2.
Issues in Writing Data to Databases

Chapter 9.
Validation with PHP and JavaScript

Section 9.1.
Validation and Error Reporting Principles

Section 9.2.
Server-Side Validation with PHP

Section 9.3.
JavaScript and Client-Side Validation

Chapter 10.
Sessions

Section 10.1.
Introducing Session Management

Section 10.2.
PHP Session Management

Section 10.3.
Case Study: Using Sessions in Validation

Section 10.4.
When to Use Sessions

Section 10.5.
PHP Session API and Configuration

Chapter 11.
Authentication and Security

Section 11.1.
HTTP Authentication

Section 11.2.
HTTP Authentication with PHP

Section 11.3.
Form-Based Authentication

Section 11.4.
Protecting Data on the Web

Chapter 12.
Errors, Debugging, and Deployment

Section 12.1.
Errors

Section 12.2.
Common Programming Errors

Section 12.3.
Custom Error Handlers

Chapter 13.
Reporting

Section 13.1.
Creating a Report

Section 13.2.
Producing PDF

Section 13.3.
PDF-PHP Reference

Chapter 14.
Advanced Features of Object-Oriented Programming in PHP 5

Section 14.1.
Working with Class Hierarchies

Section 14.2.
Class Type Hints

Section 14.3.
Abstract Classes and Interfaces

Section 14.4.
Freight Calculator Example

Chapter 15.
Advanced SQL

Section 15.1.
Exploring with SHOW

Section 15.2.
Advanced Querying

Section 15.3.
Manipulating Data and Databases

Section 15.4.
Functions

Section 15.5.
Automating Querying

Section 15.6.
Table Types

Section 15.7.
Backup and Recovery

Section 15.8.
Managing Users and Privileges

Section 15.9.
Tuning MySQL

Chapter 16.
Hugh and Dave''s Online Wines:A Case Study

Section 16.1.
Functional and System Requirements

Section 16.2.
Application Overview

Section 16.3.
Common Components

Chapter 17.
Managing Customers

Section 17.1.
Code Overview

Section 17.2.
Customer Validation

Section 17.3.
The Customer Form

Chapter 18.
The Shopping Cart

Section 18.1.
Code Overview

Section 18.2.
The Winestore Home Page

Section 18.3.
The Shopping Cart Implementation

Chapter 19.
Ordering and Shipping at the Online Winestore

Section 19.1.
Code Overview

Section 19.2.
Credit Card and Shipping Instructions

Section 19.3.
Finalizing Orders

Section 19.4.
HTML and Email Receipts

Chapter 20.
Searching and Authentication in the Online Winestore

Section 20.1.
Code Overview

Section 20.2.
Searching and Browsing

Section 20.3.
Authentication

Appendix A.
Linux Installation Guide

Section A.1.
Finding Out What''s Installed

Section A.2.
Installation Overview

Section A.3.
Installing MySQL

Section A.4.
Installing Apache

Section A.5.
Installing PHP

Section A.6.
What''s Needed for This Book

Appendix B.
Microsoft Windows Installation Guide

Section B.1.
Installation Overview

Section B.2.
Installing with EasyPHP

Section B.3.
What''s Needed for This Book

Appendix C.
Mac OS X Installation Guide

Section C.1.
Getting Started

Section C.2.
Installing MySQL

Section C.3.
Setting Up Apache and PHP

Section C.4.
What''s Needed for This Book

Appendix D.
Web Protocols

Section D.1.
Network Basics

Section D.2.
Hypertext Transfer Protocol

Appendix E.
Modeling and Designing Relational Databases

Section E.1.
The Relational Model

Section E.2.
Entity-Relationship Modeling

Appendix F.
Managing Sessions in theDatabase Tier

Section F.1.
Using a Database to Keep State

Section F.2.
PHP Session Management

Section F.3.
MySQL Session Store

Appendix G.
Resources

Section G.1.
Client Tier Resources

Section G.2.
Middle-Tier Resources

Section G.3.
Database Tier Resources

Section G.4.
Security and Cryptography Resources

Appendix H.
The Improved MySQL Library

Section H.1.
New Features

Section H.2.
Getting Started

Section H.3.
Using the New Features

Colophon

Index