The Missing Credits; About the Author; About the Creative Team; Acknowledgments; The Missing Manual Series;Introduction; What Is PHP?; What Is MySQL?; About This Book; About the Online Resources; Safari® Books Online;Part 1: PHP and MySQL Basics; Chapter 1: PHP: What, Why, and Where?; 1.1 Gathering Your Tools; 1.2 Writing Your First Program; 1.3 Running Your First Program; 1.4 Writing Your Second Program; 1.5 Upload Your HTML, CSS, and PHP; 1.6 Running Your Second Program; Chapter 2: PHP Syntax: Weird and Wonderful; 2.1 Get Information from a Web Form; 2.
2 Working with Text in PHP; 2.3 The $_REQUEST Variable; 2.4 What Do You Do with User Information?; Chapter 3: MySQL and SQL: Database and Language; 3.1 What Is a Database?; 3.2 Installing MySQL; 3.3 SQL Is a Language for Talking to Databases;Part 2: Dynamic Web Pages; Chapter 4: Connecting PHP to MySQL; 4.1 Writing a Simple PHP Connection Script; 4.2 Cleaning Up Your Code with Multiple Files; 4.
3 Building a Basic SQL Query Runner; Chapter 5: Better Searching with Regular Expressions; 5.1 String Matching, Double-Time; Chapter 6: Generating Dynamic Web Pages; 6.1 Revisiting a User's Information; 6.2 Planning Your Database Tables; 6.3 Saving a User's Information; 6.4 Show Me the User; 6.5 Redirection and Revisitation of Creating Users;Part 3: From Web Pages to Web Applications; Chapter 7: When Things Go Wrong (and They Will); 7.1 Planning Your Error Pages; 7.
2 Finding a Middle Ground for Error Pages with PHP; 7.3 Add Debugging to Your Application; 7.4 Redirecting on Error; Chapter 8: Handling Images and Complexity; 8.1 Images Are Just Files; 8.2 Images Are For Viewing; 8.3 And Now for Something Completely Different; Chapter 9: Binary Objects and Image Loading; 9.1 Storing Different Objects in Different Tables; 9.2 Inserting a Raw Image into a Table; 9.
3 Your Binary Data Isn't Safe to Insert.Yet; 9.4 Connecting Users and Images; 9.5 Show Me the Image; 9.6 Embedding an Image Is Just Viewing an Image; 9.7 So Which Approach is Best?; Chapter 10: Listing, Iterating, and Administrating; 10.1 Some Things Never Change; 10.2 Listing All Your Users; 10.
3 Deleting a User; 10.4 Talking Back To Your Users; 10.5 Standardizing on Messaging; 10.6 Integrating Utilities, Views, and Messages;Part 4: Security and the Real World; Chapter 11: Authentication and Authorization; 11.1 Start with Basic Authentication; 11.2 Abstracting What's the Same; 11.3 Passwords Don't Belong in PHP Scripts; 11.4 Passwords Create Security, But Should Be Secure; Chapter 12: Cookies, Sign-ins, and Ditching Crummy Pop-ups; 12.
1 Going Beyond Basic Authentication; 12.2 Logging In with Cookies; 12.3 Adding Context-Specific Menus; Chapter 13: Authorization and Sessions; 13.1 Modeling Groups in Your Database; 13.2 Checking for Group Membership; 13.3 Group-Specific Menus; 13.4 Entering Browser Sessions; 13.5 Memory Lane: Remember that Phishing Problem?; 13.
6 So Why Ever Use Cookies?;.