PHP & MySQL:The Missing Manual

The Missing Credits
Introduction

Part 1: PHP and MySQL Basics
1. PHP: What, Why, and Where?
-PHP Comes in Two Flavors: Local and Remote
-PHP: Going Local
-Write Your First Program
-Run Your First Program
-But Where's That Web Server?

2. PHP Meets HTML
-Script or HTML?
-PHP Talks Back
-Run PHP Scripts Remotely

3. PHP Syntax: Weird and Wonderful
-Get Information from a Web Form
-Working with Text in PHP
-The $_REQUEST Variable Is an Array
-What Do You Do with User Information?

4. MySQL and SQL: Database and Language
-What Is a Database?
-Installing MySQL
-SQL Is a Language for Talking to Databases

Part 2: Dynamic Web Pages
5. Connecting PHP to MySQL
-Writing a Simple PHP Connection Script
-Cleaning Up Your Code with Multiple Files
-Building a Basic SQL Query Runner

6. Regular Expressions
-String Matching, Double-Time

7. Generating Dynamic Web Pages
-Revisiting a User's Information
-Planning Your Database Tables
-Saving a User's Information
-Show Me the User
-Revisiting (and Redirecting) the Create User Script

Part 3: From Web Pages to Web Applications
8. When Things Go Wrong (and They Will)
-Planning Your Error Pages
-Finding a Middle Ground for Error Pages with PHP
-Add Debugging to Your Application
-Redirecting On Error

9. Handling Images and Complexity
-Images Are Just Files
-Images Are for Viewing
-And Now for Something Completely Different

10. Binary Objects and Image Loading
-Storing Different Objects in Different Tables
-Inserting a Raw Image into a Table
-Your Binary Data Isn't Safe to Insert…Yet
-Connecting Users and Images
-Show Me the Image!
-Embedding an Image Is Just Viewing an Image
-So, Which Approach Is Best?

11. Listing, Iterating, and Administrating
-Thinking about What You Need as an Admin
-Listing All Your Users
-Deleting a User
-Talking Back to Your Users
-Standardizing on Messaging
-Integrating Utilities, Views, and Messages

Part 4: Security and the Real World
12. Authentication and Authorization
-Basic Authentication
-Abstracting What's the Same
-Passwords Don't Belong in PHP Scripts
-Passwords Create Security, But Should Be Secure

13. Cookies, Sign-Ins, and Ditching Crummy Pop-Ups
-Moving Beyond Basic Authentication
-Logging In with Cookies
-Adding Context-Specific Menus

14. Authorization and Sessions
-Modeling Groups in Your Database
-Checking for Group Membership
-Group-Specific Menus
-Entering Browser Sessions
-Memory Lane: Remember That Phishing Problem?
-Why Would You Ever Use Cookies?

Part 5: Appendixes
Appendix A: Installing PHP on Windows Without WAMP
Appendix B: Installing MySQL Without MAMP or WAMP

Index