PHP & MySQL: The Missing Manual

The Missing Credits; About the Author; About the Creative Team; Acknowledgments; The Missing Manual Series; Introduction; What PHP and MySQL Can Do; 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 PHP Comes in Two Flavors: Local and Remote; 1.2 PHP: Going Local; 1.3 Write Your First Program; 1.4 Run Your First Program; 1.5 But Where's That Web Server?; Chapter 2: PHP Meets HTML; 2.1 Script or HTML?; 2.2 PHP Talks Back; 2.3 Run PHP Scripts Remotely; Chapter 3: PHP Syntax: Weird and Wonderful; 3.1 Get Information from a Web Form; 3.2 Working with Text in PHP; 3.3 The $_REQUEST Variable Is an Array; 3.4 What Do You Do with User Information?; Chapter 4: MySQL and SQL: Database and Language; 4.1 What Is a Database?; 4.2 Installing MySQL; 4.3 SQL Is a Language for Talking to Databases; Part 2: Dynamic Web Pages; Chapter 5: Connecting PHP to MySQL; 5.1 Writing a Simple PHP Connection Script; 5.2 Cleaning Up Your Code with Multiple Files; 5.3 Building a Basic SQL Query Runner; Chapter 6: Regular Expressions; 6.1 String Matching, Double-Time; Chapter 7: Generating Dynamic Web Pages; 7.1 Revisiting a User's Information; 7.2 Planning Your Database Tables; 7.3 Saving a User's Information; 7.4 Show Me the User; 7.5 Revisiting (and Redirecting) the Create User Script; Part 3: From Web Pages to Web Applications; Chapter 8: When Things Go Wrong (and They Will); 8.1 Planning Your Error Pages; 8.2 Finding a Middle Ground for Error Pages with PHP; 8.3 Add Debugging to Your Application; 8.4 Redirecting On Error; Chapter 9: Handling Images and Complexity; 9.1 Images Are Just Files; 9.2 Images Are for Viewing; 9.3 And Now for Something Completely Different; Chapter 10: Binary Objects and Image Loading; 10.1 Storing Different Objects in Different Tables; 10.2 Inserting a Raw Image into a Table; 10.3 Your Binary Data Isn't Safe to Insert...Yet; 10.4 Connecting Users and Images; 10.5 Show Me the Image!; 10.6 Embedding an Image Is Just Viewing an Image; 10.7 So, Which Approach Is Best?; Chapter 11: Listing, Iterating, and Administrating; 11.1 Thinking about What You Need as an Admin; 11.2 Listing All Your Users; 11.3 Deleting a User; 11.4 Talking Back to Your Users; 11.5 Standardizing on Messaging; 11.6 Integrating Utilities, Views, and Messages; Part 4: Security and the Real World; Chapter 12: Authentication and Authorization; 12.1 Basic Authentication; 12.2 Abstracting What's the Same; 12.3 Passwords Don't Belong in PHP Scripts; 12.4 Passwords Create Security, But Should Be Secure; Chapter 13: Cookies, Sign-Ins, and Ditching Crummy Pop-Ups; 13.1 Moving Beyond Basic Authentication; 13.2 Logging In with Cookies; 13.3 Adding Context-Specific Menus; Chapter 14: Authorization and Sessions; 14.1 Modeling Groups in Your Database; 14.2 Checking for Group Membership; 14.3 Group-Specific Menus; 14.4 Entering Browser Sessions; 14.5 Memory Lane: Remember That Phishing Problem?; 14.6 Why Would You Ever Use Cookies?; Part 5: Appendixes; Installing PHP on Windows Without WAMP; Installing PHP from www.php.net; Installing MySQL Without MAMP or WAMP; Installing MySQL;