---

Web Database Applications with PHP & MySQL, 2nd Edition

ISBN: 0596005431
EAN: 2147483647

Year: 2003
Pages: 176

Authors: Hugh E. Williams, David Lane

BUY ON AMAZON

• Web Database Application with PHP and MySQL, 2nd Edition
• Table of Contents
• 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
• 1.1 The Web
• 1.2 Three-Tier Architectures
• Chapter 2. The PHP Scripting Language
• 2.1 Introducing PHP
• 2.2 Conditions and Branches
• 2.3 Loops
• 2.4 Functions
• 2.5 Working with Types
• 2.6 User-Defined Functions
• 2.7 A Working Example
• Chapter 3. Arrays, Strings, and Advanced Data Manipulation in PHP
• 3.1 Arrays
• 3.2 Strings
• 3.3 Regular Expressions
• 3.4 Dates and Times
• 3.5 Integers and Floats
• Chapter 4. Introduction to Object-Oriented Programming with PHP 5
• 4.1 Classes and Objects
• 4.2 Inheritance
• 4.3 Throwing and Catching Exceptions
• Chapter 5. SQL and MySQL
• 5.1 Database Basics
• 5.2 MySQL Command Interpreter
• 5.3 Managing Databases and Tables
• 5.4 Inserting, Updating, and Deleting Data
• 5.5 Querying with SQL SELECT
• 5.6 Join Queries
• 5.7 Case Study: Adding a New Wine
• Chapter 6. Querying Web Databases
• 6.1 Querying a MySQL Database Using PHP
• 6.2 Processing User Input
• 6.3 MySQL Function Reference
• Chapter 7. PEAR
• 7.1 Overview
• 7.2 Core Components
• 7.3 Packages
• Chapter 8. Writing to Web Databases
• 8.1 Database Inserts, Updates, and Deletes
• 8.2 Issues in Writing Data to Databases
• Chapter 9. Validation with PHP and JavaScript
• 9.1 Validation and Error Reporting Principles
• 9.2 Server-Side Validation with PHP
• 9.3 JavaScript and Client-Side Validation
• Chapter 10. Sessions
• 10.1 Introducing Session Management
• 10.2 PHP Session Management
• 10.3 Case Study: Using Sessions in Validation
• 10.4 When to Use Sessions
• 10.5 PHP Session API and Configuration
• Chapter 11. Authentication and Security
• 11.1 HTTP Authentication
• 11.2 HTTP Authentication with PHP
• 11.3 Form-Based Authentication
• 11.4 Protecting Data on the Web
• Chapter 12. Errors, Debugging, and Deployment
• 12.1 Errors
• 12.2 Common Programming Errors
• 12.3 Custom Error Handlers
• Chapter 13. Reporting
• 13.1 Creating a Report
• 13.2 Producing PDF
• 13.3 PDF-PHP Reference
• Chapter 14. Advanced Features of Object-Oriented Programming in PHP 5
• 14.1 Working with Class Hierarchies
• 14.2 Class Type Hints
• 14.3 Abstract Classes and Interfaces
• 14.4 Freight Calculator Example
• Chapter 15. Advanced SQL
• 15.1 Exploring with SHOW
• 15.2 Advanced Querying
• 15.3 Manipulating Data and Databases
• 15.4 Functions
• 15.5 Automating Querying
• 15.6 Table Types
• 15.7 Backup and Recovery
• 15.8 Managing Users and Privileges
• 15.9 Tuning MySQL
• Chapter 16. Hugh and Dave s Online Wines:A Case Study
• 16.1 Functional and System Requirements
• 16.2 Application Overview
• 16.3 Common Components
• Chapter 17. Managing Customers
• 17.1 Code Overview
• 17.2 Customer Validation
• 17.3 The Customer Form
• Chapter 18. The Shopping Cart
• 18.1 Code Overview
• 18.2 The Winestore Home Page
• 18.3 The Shopping Cart Implementation
• Chapter 19. Ordering and Shipping at the Online Winestore
• 19.1 Code Overview
• 19.2 Credit Card and Shipping Instructions
• 19.3 Finalizing Orders
• 19.4 HTML and Email Receipts
• Chapter 20. Searching and Authentication in the Online Winestore
• 20.1 Code Overview
• 20.2 Searching and Browsing
• 20.3 Authentication
• Appendix A. Linux Installation Guide
• A.1 Finding Out What s Installed
• A.2 Installation Overview
• A.3 Installing MySQL
• A.4 Installing Apache
• A.5 Installing PHP
• A.6 What s Needed for This Book
• Appendix B. Microsoft Windows Installation Guide
• B.1 Installation Overview
• B.2 Installing with EasyPHP
• B.3 What s Needed for This Book
• Appendix C. Mac OS X Installation Guide
• C.1 Getting Started
• C.2 Installing MySQL
• C.3 Setting Up Apache and PHP
• C.4 What s Needed for This Book
• Appendix D. Web Protocols
• D.1 Network Basics
• D.2 Hypertext Transfer Protocol
• Appendix E. Modeling and Designing Relational Databases
• E.1 The Relational Model
• E.2 Entity-Relationship Modeling
• Appendix F. Managing Sessions in theDatabase Tier
• F.1 Using a Database to Keep State
• F.2 PHP Session Management
• F.3 MySQL Session Store
• Appendix G. Resources
• G.1 Client Tier Resources
• G.2 Middle-Tier Resources
• G.3 Database Tier Resources
• G.4 Security and Cryptography Resources
• Appendix H. The Improved MySQL Library
• H.1 New Features
• H.2 Getting Started
• H.3 Using the New Features
• Colophon
• Index
• index_SYMBOL
• index_A
• index_B
• index_C
• index_D
• index_E
• index_F
• index_G
• index_H
• index_I
• index_J
• index_K
• index_L
• index_M
• index_N
• index_O
• index_P
• index_Q
• index_R
• index_S
• index_T
• index_U
• index_V
• index_W
• index_X