Mon Jan 13 -- syllabus stuff. definition of cheating. Two layer architecture. Three layer architecture. SQL Types.
Wed Jan 15 -- SQL practice.
Fri Jan 17 -- ACID. Three ways to store data.. Database design. Practice SQL.
Wed Jan 22 -- PHP.
Mon Jan 27 -- SQL quiz and answers
Wed Jan 29 -- Lab day
Mon Feb 3 -- Cookies. Example Cookies!. Problems and limitations with cookies. Session variables. Example Session variables. Comparing cookies, session variables, and databases.
Wed Feb 4 -- Login assignment. Making a require file. phpmyadmin. VSCode SSH. Three ways to check for form validity: (1) HTML regex number email(2) JS (3) PHP.
Fri Feb 7 -- Adding JS and HTML (regex, lengths) to the login page.
Mon Feb 10 -- A todo app with separate html and php files, and form validation.
Wed Feb 12 -- Add into to that (1) keeping data in gthe form and (2) error messages. File uploads and Files in php and sql.
Fri Feb 14 -- Go over how to do Picture assignment
Mon Feb 17 -- Work on Picture assignment. Much grading
Wed Feb 19 -- PHP Objects.
Mon Feb 24 -- QUIZ.
Wed Feb 26 -- Midterm Review.
Mon Mar 10 -- Go over the midterm. Flask and Python!.
Wed Mar 12 -- Routing in Flask. PictureDB. Lists.
Fri Mar 14 -- Python lists. Make the picture program do multiple pix.
Mon Mar 17 -- Mysql and Python.
Wed Mar 19 -- Templates. Templates and mysql.
Fri Mar 21 -- Updown with cookies, session variables, and files.
Mon Mar 24 -- Go over code. Templatize. Turn in stuff.
Wed Mar 26 -- Easy files in python. More file stuff. Static files in python. Directory traversal atacks.
Fri Mar 28 -- Map Quiz.
Fri Apr 4 -- Dropbox and os.walk.
Mon Apr 7 -- Python regex and and the assignment and Ajax in python. Bonus: How to download from the web.
Wed Apr 9 -- Web scraping. Math/CS staff page.
Mon Apr 14 -- Web checker assignment.
Apache/2.4.41 (Ubuntu) Server at euclid.nmu.edu Port 80