Programming Web Databases
esse quam videri
Programming Web Databases Syllabus
Jan. 28th
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
- Sebastian Frohm, Shaun Crittenden, John Marsh, and Andrew Hass demo their lists and walk us through their code.
- Catching MySQl connection & query errors ( some sample mysql connection code )
- Creating an HTML for processor (looking at security & query building).
- sample code from this class
Monday, February 25th
- Talk about me making everyone nervous.
- Stuff we've currently covered. Questions.
- Joins
- Drop downs
- Relations
Monday, March 10th
- CRUD application due
- Start designing DB in groups
- Pull it together as a whole class
- Decide what objects will be needed.
- Talk about $_SESSION & $_COOKIE
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)