Programming Web Databases

From IAM MediaWiki Create Change
Jump to: navigation, search

Programming Web Databases Syllabus

Jan. 28th

PWD - Strings Assn


Monday, February 4th

  • Look over last homework assignment.
  • Talk about datatypes (and their uses) in mySQL
  • Talk about mySQL and your mySQL access.
  • Talk about arrays.
  • Talk about mySQL php functions.

Monday, February 11th

  • Look over db table homework assignment.
  • Talk more about DBs and create listing page.
  • Talk about mySQL and your mySQL access.
  • Talk about arrays.
  • Talk about mySQL php functions.
  • Read PHP Ch. 4&5, MySQL 11.2
  • Create listing page from one of your tables. ( example of mysql php list )

Monday, February 18th

Monday, February 25th

  • Talk about me making everyone nervous.
  • Stuff we've currently covered. Questions.
  • Joins
  • Drop downs
  • Relations

Monday, March 10th

Monday, March 17th

  • Talk about datetime conversion function (have Ryan show alternate method)
  • Look at everyone's CRUD applications
  • Define groups and hand out modules

March 31st

Review all code produced over break. Review project status. Work on Objects.

April 7th

Work on final project objects. Answer questions.


April 14th

All Final Project objects on feature-lock. Talk about all final project pieces.


April 21st

  • Mysql queries.
  • Some problem points in the final project.
  • Images group shows us what's up.
  • SVN questions?
  • Homework (due on the 28th): Create file uploader script (Form with file selector, check to make sure it's in Joint Photographic Experts Group format, save to a specific directory)