The important stuff you need to know:
- Get a running start. Write PHP scripts and create a web form right away.
- Learn the language. Get up to speed on PHP and SQL syntax quickly.
- Build a database. Use MySQL to store user information and other data.
- Make it dynamic. Create pages that change with each new viewing.
- Be ready for mistakes. Plan error messages to help direct users.
- Manage your content. Use the file system to access user data, including images and other binary files.
- Control operations. Create an administrative interface to oversee your site.
Table of Contents
- A Note Regarding Supplemental Files
- The Missing Credits
1. PHP and MySQL Basics
- 1. PHP: What, Why, and Where?
2. PHP Syntax: Weird and Wonderful
- Get Information from a Web Form
- Working with Text in PHP
- The $_REQUEST Variable
- What Do You Do with User Information?
3. MySQL and SQL: Database and Language
- What Is a Database?
- Installing MySQL
- SQL Is a Language for Talking to Databases
2. Dynamic Web Pages
4. Connecting PHP to MySQL
- Writing a Simple PHP Connection Script
- Cleaning Up Your Code with Multiple Files
- Building a Basic SQL Query Runner
- 5. Better Searching with Regular Expressions
6. Generating Dynamic Web Pages
- Revisiting a User’s Information
- Planning Your Database Tables
- Saving a User’s Information
- Show Me the User
- Redirection and Revisitation of Creating Users
- 4. Connecting PHP to MySQL
3. From Web Pages to Web Applications
7. 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
8. Handling Images and Complexity
Images Are Just Files
- HTML Forms Can Set the Stage
- Uploading a User’s Image to Your Server
- Storing the Image Location in the Database
- Images Are For Viewing
- And Now for Something Completely Different
- Images Are Just Files
9. 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?
10. Listing, Iterating, and Administrating
- Some Things Never Change
- Listing All Your Users
- Deleting a User
- Talking Back To Your Users
- Standardizing on Messaging
Integrating Utilities, Views, and Messages
- Calling Repeated Code from a View Script
- Flexible Functions are Better Functions
- Standardize and Consolidate Messaging in the View
- Build a Function to Call Two Functions
- Just Pass that Information Along
- 7. When Things Go Wrong (and They Will)
4. Security and the Real World
11. Authentication and Authorization
- Start with Basic Authentication
- Abstracting What’s the Same
- Passwords Don’t Belong in PHP Scripts
- Passwords Create Security, But Should Be Secure
12. Cookies, Sign-ins, and Ditching Crummy Pop-ups
- Going Beyond Basic Authentication
- Logging In with Cookies
- Adding Context-Specific Menus
13. Authorization and Sessions
- Modeling Groups in Your Database
- Checking for Group Membership
- Group-Specific Menus
- Entering Browser Sessions
- Memory Lane: Remember that Phishing Problem?
- 11. Authentication and Authorization
- About the Author
- Title: PHP & MySQL: The Missing Manual
- Release date: November 2011
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781449318857