376 - Web App Dev: PHP

These are the resources for the lessons in the PHP unit.

Home W3 Schools

For this unit we will learn how data can be persisted in and retrieved from a relational databases within a browser using PHP. The starter files for lessons 2-4 are used to create a simple web application that maintains a list of companies in a database. Creating the edit file will be left as a project for you.

Lessons

  1. Introduction
    1. Server-side programming
    2. The LAMP development stack
    3. Installing Apache & PHP
    4. Hello world!
    5. Syntax
    6. Variables
    7. Hello world! on steroids
    8. The PHP manual
  2. Retrieving data  
    1. Database connections
    2. SELECT statements
    3. Sanitizing user input with real_escape_string() (beware XKCD 327)
  3. Creating data
    1. Form handling
    2. INSERT statements
  4. Deleting data with DELETE statements
  5. Editing data with UPDATE statements