Class activities will be recorded here.

This page has the entire plan for the semester. For weeks in the future, consider it a plan subject to change. For weeks in the past consider it a record of what we have done. As for the current week, keep a watch for updates and changes.

Week 1 : January 20 - January 26
Week 2 : January 27 - February 2
Week 3 : February 3 - February 9
Week 4 : February 10 - February 16
  • Mon
    PHP Client Server Interaction - forms
    Using forms in the context of PHP to move information and change page behavior. No video today due to equipment failure.
    Examples used in lecture
    Text Chapter 11 and 12
    Wed
    PHP Arrays and Objects (pdf) (video)
    Key-value pairs, array packing and unpacking, using arrays of objects.
    Examples used in lecture
    Text Chapter 6
    Fri
    Recapping HTML, PHP and CSS (video)
    Through several examples review common idioms associated with page layout, commen elements, etc.
    Text Chapter 7
Week 5 : February 17 - February 23
Week 6 : February 24 - March 2
Week 7 : March 3 - March 9
  • Mon
    Databases & MySQL (pdf) (video)
    Introduction to databases and MySQL
    Examples used in lecture
    Wed
    Flat Tables in MySQL (video)
    Hands on exploration of SQL through direct interaction with the MySQL server.
    Fri
    Relations in MySQL (video)
    Introduce relations and review the basis: create, insert, drop, select and join
    Text Chapter 8
Week 8 : March 10 - March 16
  • Mon
    PHP and SQLite - Music Part 1 (pdf) (video)
    Introduce PHP interaction with SQLite through a series of coordinated examples.
    Examples used in lecture
    Text Chapter 9
    Wed
    PHP and SQLite - Music Part 2
    Querying from within PHP.
    Video capture failed on this day.
    Text Chapter 10
    Fri
    PHP and SQLite - Music Part 3 (video)
    Sorting, inserting, removing and injection.
Week 9 : March 17 - March 23
  • Mon
    Spring Break
    Wed
    Spring Break
    Fri
    Spring Break
Week 10 : March 24 - March 30
Week 11 : March 31 - April 6
Week 12 : April 7 - April 13
Week 13 : April 14 - April 20
Week 14 : April 21 - April 27
  • Wed
    HTML 5 Video, Detailed Project 3 Discussion (video)
    Detailed Q & A on Project 3, wrapup of HTML 5 Video
    Fri
    AJAX POST, Project 3 Cross Site Authentication (video)
    POST vs. GET in AJAX. Problem solving exercise and discussion vis-_-vis one Project 3 site authenticating requests relative to another.
Week 15 : April 28 - May 4
Week 16 : May 5 - May 11