Web Database Applications with PHP & MySQL, 2nd Edition
Web Database Applications with PHP & MySQL, 2nd Edition
ISBN: 0596005431
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 176
Pages: 176
Authors: Hugh E. Williams, David Lane
- 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
Web Database Applications with PHP & MySQL, 2nd Edition
ISBN: 0596005431
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 176
Pages: 176
Authors: Hugh E. Williams, David Lane