Books & Videos

Table of Contents

  1. PHP and MySQL Basics

    1. Chapter 1 PHP: What, Why, and Where?

      1. Gathering Your Tools
      2. Writing Your First Program
      3. Running Your First Program
      4. Writing Your Second Program
      5. Upload Your HTML, CSS, and PHP
      6. Running Your Second Program
    2. Chapter 2 PHP Syntax: Weird and Wonderful

      1. Get Information from a Web Form
      2. Working with Text in PHP
      3. The $_REQUEST Variable
      4. What Do You Do with User Information?
    3. Chapter 3 MySQL and SQL: Database and Language

      1. What Is a Database?
      2. Installing MySQL
      3. SQL Is a Language for Talking to Databases
  2. Dynamic Web Pages

    1. Chapter 4 Connecting PHP to MySQL

      1. Writing a Simple PHP Connection Script
      2. Cleaning Up Your Code with Multiple Files
      3. Building a Basic SQL Query Runner
    2. Chapter 5 Better Searching with Regular Expressions

      1. String Matching, Double-Time
    3. Chapter 6 Generating Dynamic Web Pages

      1. Revisiting a User’s Information
      2. Planning Your Database Tables
      3. Saving a User’s Information
      4. Show Me the User
      5. Redirection and Revisitation of Creating Users
  3. From Web Pages to Web Applications

    1. Chapter 7 When Things Go Wrong (and They Will)

      1. Planning Your Error Pages
      2. Finding a Middle Ground for Error Pages with PHP
      3. Add Debugging to Your Application
      4. Redirecting on Error
    2. Chapter 8 Handling Images and Complexity

      1. Images Are Just Files
      2. Images Are For Viewing
      3. And Now for Something Completely Different
    3. Chapter 9 Binary Objects and Image Loading

      1. Storing Different Objects in Different Tables
      2. Inserting a Raw Image into a Table
      3. Your Binary Data Isn’t Safe to Insert…Yet
      4. Connecting Users and Images
      5. Show Me the Image
      6. Embedding an Image Is Just Viewing an Image
      7. So Which Approach is Best?
    4. Chapter 10 Listing, Iterating, and Administrating

      1. Some Things Never Change
      2. Listing All Your Users
      3. Deleting a User
      4. Talking Back To Your Users
      5. Standardizing on Messaging
      6. Integrating Utilities, Views, and Messages
  4. Security and the Real World

    1. Chapter 11 Authentication and Authorization

      1. Start with Basic Authentication
      2. Abstracting What’s the Same
      3. Passwords Don’t Belong in PHP Scripts
      4. Passwords Create Security, But Should Be Secure
    2. Chapter 12 Cookies, Sign-ins, and Ditching Crummy Pop-ups

      1. Going Beyond Basic Authentication
      2. Logging In with Cookies
      3. Adding Context-Specific Menus
    3. Chapter 13 Authorization and Sessions

      1. Modeling Groups in Your Database
      2. Checking for Group Membership
      3. Group-Specific Menus
      4. Entering Browser Sessions
      5. Memory Lane: Remember that Phishing Problem?
      6. So Why Ever Use Cookies?