CS 460

Professor: Randy Appleton rappleto@nmu.edu
Times: Mon,Wed,Thr,Fri at 4am.

Mon Aug 27 -- Go over the syllabus. The Three Tiered Architecture. HTML. Can you do forms and multimedia and CSS?
Wed Aug 29 -- SQL, including how to create a table (with types), drop a table, and ask queries (with operators). Joins.
Fri Aug 31 -- Review insert and create table and select. Subqueries. limit statement.
Wed Sep 5 -- Work on This problem in pairs. transactions. Terminology and composition and database optimization.
Fri Sep 7 -- Quiz. You can practice quiz (with answers).
Mon Sep 10 -- PHP!.
Wed Sep 12 -- More php!!
Fri Sep 14 -- First PHP Assignment. Cookies and an example. Cookies in PHP.
Mon Sep 17 -- Fix my error in cookies.php. Show man page for cookies. Show setting. Explain problem they wanted to solve. Show off domain and path. Talk about virtual hosting. Global and static varaibles. Objects. __toString() and other magic methods.constants. inheritance and ::. constructors and destructors.
Wed Sep 19 -- blog assignment. Mysql and php. Example web site.
Fri Sep 21 -- Negotiate assignments with students. Work on assignment.
Mon Sep 24 -- Changes to the assignment. sql injection attack example. mysql_real_escape_string Cross Site Scripting. Wiki page on Cros Site Scripting. htmlentities and html_entities_decode
Wed Sep 26 -- Checklist.
Fri Sep 28 -- Files tutorial and Files and magic-quotes-gpc and magicquotes and header command.
Mon Oct 1 -- The next assignment.. Regular Expression Cheat Sheet. Patterns to write.
Wed Oct 3 -- Regular expression tutorial, a list of regular expressions,
Fri Oct 5 -- print_r, Example RegEx App.
Mon Oct 8 -- Test/Quiz on regular expressions and regex php functions.
Wed Oct 10 -- Make Map Assignment and map projections and the php obfuscator and how to make a map using our database.
Mon Oct 15 -- PHP Arrays. foreach. Map problem.
Mon Oct 22 -- mgh linking policy. Session variable demo and session variable instructions and changing images in php.
Wed Oct 24 -- Review for PHP test.
Fri Oct 26 -- PHP Test
Mon Oct 29 -- Javascript with list of Javascript events.
Wed Nov 14 -- New Map Assignment and How to do it.
Fri Nov 16 -- Image maps. JS Arrays. Associative arrarys in Javascript. Mon Nov 19 -- Work on the map project.
Mon Nov 26 -- JQuery with list of events and effects and jQuery tutorial. The Google copy of jQuery is at http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js.
Wed Nov 27 -- jQuery quiz. jQuery work day.
Fri Nov 30 -- Video and delays. jQuery setting css attr. Setting HTML attr. Callbacks after effects. Chaining effects. Difference between effects and events. jQuery-Ajax.
Fri Dec 7 -- Last year's final exam and Thr Dec 13 -- Final Exam 4pm