Mon Jan 10 -- Go over <a href=syllabus.html>the syllabus</a>.  The <a href=http://en.wikipedia.org/wiki/Multitier_architecture>Three Tiered Architecture</a>.  <a href=HTML>HTML</a>.  Can you do <a href=http://euclid.nmu.edu/~randy/Classes/CS460/HTML/complex-example.html>forms</a> and multimedia and CSS?<br>
Wed Jan 12 -- <a href=Databases/SQL>SQL</a>, including how to create a database, delete a database, create a table (weith <a href=Databases/SQL/sql-types.html>types</a>), drop a table, and ask queries.  Joins.<br>
Fri Jan 14 -- Review insert and create table and select.  Subqueries.  limit statement.<br>  
Mon Jan 17 -- <a href=Databases/SQL/Database-Design/transactions.html>transactions</a>.  <a href=Databases/database-basics.html>Terminology and composition</a> and <a href=Databases/database-opt.html>database optimization</a>.<br>
Wed Jan 19 -- Practice <a href=Databases/SQL/CS_460_SQL_Quiz.html>quiz</a> (with <a href=Databases/SQL/CS_460_SQL_Quiz_ANSWERS.html>answers)</a>.</b><br>
Fri Jan 20 -- <b>QUIZ</b>.<br>
Mon Jan 23 -- Go over quiz.  <a href=PHP/Intro/>PHP</a>.<br>
Wed Jan 25 -- <a href=PHP/forms.php>Forms</a> in php.  Make me a page that prints from 1 ... N.  Make me a page that shows N <a href=http://icons.iconarchive.com/icons/aha-soft/dating/48/broken-heart-icon.png>hearts</a>.  Make me a function that tells if something is prime.<br>
Fri Jan 28 -- <a href=PHP/Cookies/cookies.php.txt>Cookies</a>.  <a href=PHP/Arrays/arrays.html>Arrays</a>.  <a href=Assignments/php-party-planner.html>PHP Assignment</a>. <a href=PHP/Objects/>Objects</a>.<br>
Mon Jan 31 -- Psychic detetion via php.<br>
Fri Feb 4 -- <a href=http://php.net/manual/en/function.trim.php>Trim command</a>.  <a href=http://php.net/manual/en/function.preg-split.php>Preg_split</a>.  Moving data from one form to another (<a href=PHP/Arrays/array_as_input.php>src</a>).  <a href=http://php.net/manual/en/control-structures.foreach.php>Foreach</a> in php.  <a href=http://us2.php.net/manual/en/function.print-r.php>print_r</a>.<br>
Mon Feb 7 -- <a href=http://php.net/manual/en/function.preg-match.php>preg_match</a>.  <a href=http://www.php.net/manual/en/function.preg-replace.php>preg_replace</a>.  <a href=http://www.php.net/manual/en/function.preg-grep.php>preg_grep</a>.  <a href=http://www.php.net/manual/en/function.preg-split.php>preg_split</a>.  <a href=patterns.html>Regex Tester</a>. <a href=http://www.javascriptkit.com/javatutors/redev2.shtml>THE REGULAR EXPRESSION CHEAT SHEET</a><br>
Wed Feb 9 -- Regular expression homework.  Connecting to a database using PHP.  <a href=http://xkcd.com/327/>xkcd</a>.  <a href=http://php.net/manual/en/function.mysql-connect.php>mysql-connect</a> , <a href=http://www.php.net/manual/en/function.mysql-pconnect.php>mysql_pconnect</a>, <a href=http://php.net/manual/en/function.mysql-select-db.php>mysql_select_db</a>, <a href=http://www.php.net/manual/en/function.mysql-query.php>mysql_query</a>, <a href=http://www.php.net/manual/en/function.mysql-num-rows.php>mysql_num_rows</a>, <a href=http://www.php.net/manual/en/function.mysql-affected-rows.php>mysql_num_rows_affected</a>, <a href=http://www.php.net/manual/en/function.mysql-error.php>mysql_error</a>, <a href=http://us.php.net/manual/en/function.die.php>die</a>, <a href=http://www.php.net/manual/en/function.mysql-fetch-row.php>mysql_fetch_row</a>, <a href=http://www.php.net/manual/en/function.mysql-real-escape-string.php>mysql_real_escape_string</a>.<br>
Fri Feb 11 -- <a href=http://thedailywtf.com/Articles/Annual-Y2K.aspx>story1</a>, <a href=http://thedailywtf.com/Articles/SqueakyClean-HTML.aspx><a href=http://thedailywtf.com/Articles/SqueakyClean-HTML.aspx>story2</a>, <a href=http://thedailywtf.com/Articles/14-Layers-Deep.aspx>story3</a>.<a href=http://www.techonthenet.com/sql/like.php>like</a> and <a href=http://www.artfulsoftware.com/infotree/queries.php#552>levenshine distance</a> and <a href=http://www.madirish.net/?article=85>soundex</a>.<br>
Mon Feb 14 -- Valentines Day.  Google and PageRank.  <a href=http://www.thespec.com/news/world/article/484704--the-dirty-little-secrets-of-search>JC Pennys</a>.  <a href=http://www.articlesbase.com/internet-articles/seo-hints-on-how-to-optimize-a-website-advanced-seo-tips-593915.html>SEO Optimization</a>.  <a href=http://adwords.google.com>Adwords</a>.<br>
Wed Feb 16 -- <a href=Assignments/makemap-assignment.html>Make a map</a> with <a href=http://en.wikipedia.org/wiki/Mercator_projection>projections</a> and  and <a href=PHP/Images/>Images</a>.<br>
Fri Feb 18 -- Foreach and the url command line.  <a href=http://www.kasparius.com/tutorials/imagemap/index.htm>Image maps</a> and tool tips.<br>
Mon Feb 21 -- <a href=http://cs.nmu.edu/~rappleto/Classes/CS460/PHP/Images/graphPop.php>Bar chart</a> using python image stuff and mysql.<br>
Wed Feb 23 -- Lab day.<br>
Mon Mar 7 -- Lab day for map assignment.<br>
Wed Mar 9 -- Running php on the command line. <a href=Assignments/Picture_Database.html>Picture assignment</a>.  <a href=PHP/Files>Files in mysql</a>.  <a href=http://php.net/manual/en/function.get-magic-quotes-gpc.php>gpc_magic_quotes</a>.<br> 
Mon Mar 14 -- Work on picture project.<br>
Mon Mar 21 -- Mining the web.  Copyrights on data. Fake towns.<br>
Wed Mar 23 -- <a href=http://www.niemanlab.org/2011/03/that-was-quick-four-lines-of-code-is-all-it-takes-for-the-new-york-times-paywall-to-come-tumbling-down-2/>NYT Pay Wall</a> with <a href=http://toys.euri.ca/nyt.js>source code</a>.  <a href=http://arstechnica.com/web/news/2011/03/https-is-more-secure-so-why-isnt-the-web-using-it.ars>HTTPS</a>.  <a href=http://www.w3schools.com/js/js_intro.asp>Javascript intro</a>.<br>
Fri Mar 25 -- <a href=Javascript/date-validation.html>simple javascript page with data validation</a>.  <a href=Assignments/easy-javascript.html>Javascript assignment</a>.<br>
Wed Mar 30 -- <a href=http://threatpost.com/en_us/blogs/romanian-duo-hacks-mysqlcom-032811>Mysql haxor</a>.  <a href=http://www.v-nessa.net/2010/08/02/using-php-to-extract-image-exif-data>Exif</a> and <a href=http://us.php.net/manual/en/book.image.php>GD</a>.  Error console.  More javascript with div and innerHTML, onload and onunload, regular expressions, and drawing in javascript.<br>
Fri Apr 1 -- <a href=http://en.wikipedia.org/wiki/Ajax_(programming)>AJAX disadvantages</a>.  <a href=http://www.ajaxf1.com/tutorial/ajax-php.html>AJAX tutorial</a>.  <a href=AJAX/Simplest/>AJAX example</a>.<br>
Mon Apr 4 -- <a href=Assignments/nations-ajax.txt>Assignment</a>.  More <a href=AJAX>AJAX</a>.<br>
Fri Apr 8 -- <a href=http://www.w3schools.com/js/js_popup.asp>More Javascript</a>.<br>
Mon Apr 11 -- QUIZ over Fridays stuff.<br>
Fri Apr 15 -- <a href=http://cs.nmu.edu/~rappleto/Classes/Image-Format-Compare/>Comparing Image Formats</a>.  <a href=http://en.wikipedia.org/wiki/Scalable_Vector_Graphics>SVG</a>.  <a href=http://www.w3schools.com/svg/svg_examples.asp>SVG examples</a>.  <a href=http://httpd.apache.org/docs/current/howto/htaccess.html>.htaccess files</a>.  <a href=uaw1950.nmu.edu>UAW1950</a> with /home/uaw1950/pub/private/.htaccess, /home/uaw1950/pub/officers/.htaccess, and /home/uaw1950/pub/officers/make-passwords.sh.<br>
Mon Apr 18 -- Review for final exam</a>.<br>