Flylib.com
Web Database Applications with PHP & MySQL, 2nd Edition
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
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
CISSP Exam Cram 2
Honeypots
Network Access Controls
Failure States
Answers to Exam Prep Questions
Hack Attacks
Snort Cookbook
Logging Packets That Snort Captures
Running Snort as a Linux Daemon
Killing a Specific Session
Detecting IDS Evasion
Newbies Playing with Snort Using EagleX
MySQL Clustering
Startup Phases
Restarting a Cluster
The Structure of config.ini
Running MySQL in a Chrooted Environment
What to Look for When Something Goes Wrong
Mapping Hacks: Tips & Tools for Electronic Cartography
Hack 24. Explore a 3-D Model of the Entire World
Hack 46. Map Global Weather Conditions
Hack 67. Seamless Data Download from the USGS
Hack 91. Build Interactive Web-Based Map Applications
Hack 100. Map Imaginary Places
Comparing, Designing, and Deploying VPNs
Configuring and Verifying L2TPv3 Pseudowires
Supporting IPv6 Traffic Transport in MPLS Layer 3 VPNs Using 6VPE
Comparing SSL VPNs to Other Types of Remote Access VPNs
Understanding VPLS
Python Programming for the Absolute Beginner, 3rd Edition
Searching Directory Trees
Message and Entry
The Root Page
Implementing Stacks
Appendix B Pragmatics
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies