Books & Videos

Table of Contents

  1. PHP and MySQL Basics

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

      1. PHP Comes in Two Flavors: Local and Remote
      2. PHP: Going Local
      3. Write Your First Program
      4. Run Your First Program
      5. But Where’s That Web Server?
    2. Chapter 2 PHP Meets HTML

      1. Script or HTML?
      2. PHP Talks Back
      3. Run PHP Scripts Remotely
    3. Chapter 3 PHP Syntax: Weird and Wonderful

      1. Get Information from a Web Form
      2. Working with Text in PHP
      3. The $_REQUEST Variable Is an Array
      4. What Do You Do with User Information?
    4. Chapter 4 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 5 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 6 Regular Expressions

      1. String Matching, Double-Time
    3. Chapter 7 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. Revisiting (and Redirecting) the Create User Script
  3. From Web Pages to Web Applications

    1. Chapter 8 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 9 Handling Images and Complexity

      1. Images Are Just Files
      2. Images Are for Viewing
      3. And Now for Something Completely Different
    3. Chapter 10 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 11 Listing, Iterating, and Administrating

      1. Thinking about What You Need as an Admin
      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 12 Authentication and Authorization

      1. 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 13 Cookies, Sign-Ins, and Ditching Crummy Pop-Ups

      1. Moving Beyond Basic Authentication
      2. Logging In with Cookies
      3. Adding Context-Specific Menus
    3. Chapter 14 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. Why Would You Ever Use Cookies?
  5. Appendixes

    1. Appendix Installing PHP on Windows Without WAMP

      1. Installing PHP from www.php.net
    2. Appendix Installing MySQL Without MAMP or WAMP

      1. Installing MySQL