Toggle navigation
Home
Programming
PHP & MySQL. Building web database applications
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
Remember the name: eTutorials.org
Copyright eTutorials.org 2008-2023. All rights reserved.
