Flylib.com
Web Database Applications with PHP & MySQL, 2nd Edition
Web Database Applications with PHP & MySQL, 2nd Edition
ISBN: 0596005431
EAN: 2147483647
Year: 2002
Pages: 134
Authors:
Hugh E. Williams
,
David Lane
BUY ON AMAZON
Starting Page
Starting Page
Front Matter
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
How to Contact Us
Web Site and Code Examples
Acknowledgments
Chapter 1. Database Applications and the Web
1.1 Three-Tier Architectures
1.2 The Client Tier
1.3 The Middle Tier
1.4 The Database Tier
1.5 Our Case Study
Chapter 2. PHP
2.1 Introducing PHP
2.2 Conditions and Branches
2.3 Loops
2.4 A Working Example
2.5 Arrays
2.6 Strings
2.7 Regular Expressions
2.8 Date and Time Functions
2.9 Integer and Float Functions
2.10 User-Defined Functions
2.11 Objects
2.12 Common Mistakes
Chapter 3. MySQL and SQL
3.1 Database Basics
3.2 Quick Start Guide
3.3 MySQL Command Interpreter
3.4 Managing Databases, Tables, and Indexes
3.5 Inserting, Updating, and Deleting Data
3.6 Querying with SQL SELECT
3.7 Join Queries
3.8 Modifying the Database
3.9 Functions
3.10 More on SQL and MySQL
Chapter 4. Querying Web Databases
4.1 Connecting to a MySQL Database
4.2 Formatting Results
4.3 Case Study: The Front-Page Panel
4.4 Interacting with Other DBMSs Using PHP
Chapter 5. User-Driven Querying
5.1 User Input
5.2 Querying with User Input
5.3 Case Study: Previous and Next Browsing
5.4 Case Study: Producing a select List
Chapter 6. Writing to Web Databases
6.1 Database Inserts, Updates, and Deletes
6.2 Issues in Writing Data to Databases
Chapter 7. Validation on the Server and Client
7.1 Validation and Error Reporting for Web Database Applications
7.2 Server-Side Validation
7.3 Client-Side Validation with JavaScript
Chapter 8. Sessions
8.1 Building Applications That Keep State
8.2 Session Management Over the Web
8.3 PHP Session Management
8.4 Case Study: Adding Sessions to the Winestore
8.5 When to Use Sessions
Chapter 9. Authentication and Security
9.1 HTTP Authentication
9.2 HTTP Authentication with PHP
9.3 Authentication Using a Database
9.4 Web Database Applications and Authentication
9.5 Protecting Data on the Web
Chapter 10. Winestore Customer Management
10.1 Overview of the Winestore Application
10.2 Customer Management
10.3 Authenticating Users
10.4 The Winestore Include Files
Chapter 11. The Winestore Shopping Cart
11.1 The Winestore Home Page
11.2 The Shopping Cart Architecture
11.3 Managing Redirection
Chapter 12. Ordering and Shipping at the Winestore
12.1 Finalizing Orders
12.2 HTML and Email Receipts
Chapter 13. Related Topics
13.1 Automated Housekeeping
13.2 Templates
13.3 Searching and Browsing
Appendix A. Installation Guide
A.1 Installing MySQL, Apache, and PHP
A.2 Installing the Winestore Examples
A.3 Installing Apache to Use SSL
A.4 Installation Resources
Appendix B. Internet and Web Protocols
B.1 The Internet
B.2 Hypertext Transfer Protocol
Appendix C. Modeling and Designing Relational Databases
C.1 The Relational Model
C.2 Entity-Relationship Modeling
Appendix D. Managing Sessions in the Database Tier
D.1 Using a Database to Keep State
D.2 PHP Session Management
D.3 MySQL Session Store
Appendix E. Resources
E.1 Client Tier Resources
E.2 Middle Tier Resources
E.3 Database Tier Resources
E.4 Security and Cryptography Resources
Colophon
Index
Index ASYMBOL
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
Web Database Applications with PHP & MySQL, 2nd Edition
ISBN: 0596005431
EAN: 2147483647
Year: 2002
Pages: 134
Authors:
Hugh E. Williams
,
David Lane
BUY ON AMAZON
Beginners Guide to DarkBASIC Game Programming (Premier Press Game Development)
Welcome to DarkBASIC
Adding Sound Effects to Your Game
Playing Some Tunes CD Audio, MIDI and MP3 Music
Epilogue
Appendix A Answers to the Chapter Quizzes
Professional Java Native Interfaces with SWT/JFace (Programmer to Programmer)
Scales, Sliders, and Progress Bars
Drag and Drop and the Clipboard
Printing
Creating a Text Editor with JFace Text
Drawing Diagrams with Draw2D
Documenting Software Architectures: Views and Beyond
Overview
Elements, Relations, and Properties of the Module Viewtype
What to Document
Discussion Questions
Module Uses View
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 314 Outlet, Device, Pull, and Junction Boxes; Conduit Bodies; Fittings; and Handhole Enclosures
Article 336 Power and Control Tray Cable Type TC
Article 348 Flexible Metal Conduit Type FMC
Example No. D5(a) Multifamily Dwelling Served at 208Y/120 Volts, Three Phase
Example No. D10 Feeder Ampacity Determination for Adjustable-Speed Drive Control [See 215.2, 430.24, 620.13, 620.14, 620.61, Tables 430.22(E), and 620.14]
Comparing, Designing, and Deploying VPNs
What Is a Virtual Private Network?
Review Questions
A Detailed Examination of MPLS Layer 3 VPNs
Summary
Microsoft Visual Basic .NET Programmers Cookbook (Pro-Developer)
Files and Directories
Multithreading
Reflection
Remoting and Enterprise Services
Useful COM Interop
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