Session Details

Week 9, Session 25 — Mon May 6

Preparation

  1. § 13.3 - 13.4

Due

Topics

  1. HW4 solution using AJAX and small number of ifs.
  2. SQL intro
  3. Using a database on your cpomputer
  4. tables and SELECT
  5. DISTINCT, WHERE, LIKE, ORDER BY, LIMIT
  6. Accessing a mySQL database form PHP
  7. Cautions

Outline

Resources

  1. Today's Slides
  2. small databases from textbook (simpsons, world, imdb_small)
  3. local SQL setup instructions
  4. Use mySQL from Windows CMD