Mon Jan 12 -- Go over the syllabus. HTML. Can you do forms and multimedia and CSS? An easy example.
Wed Jan 14 -- Review SQL. Easy questions here. Hard questions here.
Mon Jan 19 -- In class assignment.
Wed Jan 21 -- More SQL. Subqueries. Group by. Database decomposition.Query optimization.
Thr Jan 22 -- Quiz on SQL.
Mon Jan 26 -- PHP.
Wed Jan 28 -- Students program in PHP.
Thr Jan 29 -- Demo writing code in PHP. Cookies.
Mon Feb 1 -- A web form. Mysql and PHP. A Mysql and php tutorial.
Wed Feb 4 -- Teacher writes an application in PHP with MySQL. Graphics in PHP.
Mon Feb 9 -- xkcd and htmlspecialchars and addslashes and mysqlrealescapestring and magic_quote_gpc and mysql_result and downloading binary files and binaries in sql.
Wed Feb 11 -- Form assignment due. More binary file work.
Mon Feb 16 -- CIA World factbook. PHP regukar expressions. A list of PHP preg functions. A regex tester. An example
Mon Feb 23 -- How to get the points of a nation. How to project onto a plain. How to do imagemaps. Arrays. Data scraping assignment due.
Wed Feb 25 -- More imagemap and drawing stuff targetted to the makemap assignment.
Mon Mar 9 -- The Makemap assignment due. CSS with examples.
Wed Mar 11 -- Javascript.
Thr Mar 12 -- Javascript practice.
Mon Mar 16 -- Form validation and Date Validation.
Wed Mar 18 -- Work on javascript. Superhero assignment due.
Mon Mar 23 -- Catch up day (lab day).
Wed Mar 25 -- Catch up day (lab day).
Thr Mar 26-- Easy AJAX tutorial.
Mon Mar 30 -- Weight and balance assigment. The great airport database. Computing distance between two points. embedding maps.
Thr Apr 2 -- Keeping form data on the form and More javascript.
Mon Apr 13 -- Login scripts.
Wed Apr 15 -- Last, easy assignment.fun with javascript.Menus and
Thr apr 16 -- SQL for fun and profit.
Mon Apr 20 -- Outcomes assessment test in the lab.
Wed Apr 22 -- Catch up lab day.
Thr Apr 23 -- Review for the final.