Teaching
Current
No teaching assignment for Summer 2008.
Links to tutorial materials
Lecture Notes
I did guest lectures for COMP 2405: Internet Application Programming on Feb 5 and 7th, 2007 , then again in 2008. Topics covered were basic PHP programming, basic databases (using postgresql) and how to use them in PHP, cross site scripting, data validation, and SQL injection.
2405 Slides and Demo Code from 2008
- Intro to PHP & Cross Site Scripting
- Demo code for Feb 5, 2008 -- Note that there are intentional security flaws in much of this code. Be careful if using it for anything.
- Intro to Databases and how to use them in PHP + More random tidbits about PHP
- Demo code for Feb 7, 2008 -- As above, there are intentional security flaws in this code. Don't use it as a template for good programming.
- Blog Demo -- This is the code written in class as a demonstration. The table which goes with this looks more or less like this:
mysql> describe blog; +---------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+--------------+------+-----+---------+-------+ | name | varchar(20) | YES | | NULL | | | post | text | YES | | NULL | | | subject | varchar(255) | YES | | NULL | | | date | datetime | YES | | NULL | | | tags | varchar(255) | YES | | NULL | | +---------+--------------+------+-----+---------+-------+ 5 rows in set (0.06 sec)
As before, don't take this to be good table design or good code. It was meant as a demonstration on how quickly a small application can be created.
2405 Slides and Demo Code from 2007
My slides are available on Pat Morin's website or here:
- Intro to PHP & Cross Site Scripting (powerpoint) (PDF)
- Intro to Databases and how to use them in PHP (powerpoint) (PDF)
- PHP Demos used in class (covering basic PHP and database use, cross site scripting, data validation, and SQL injection) (zip)
- Please note: many of these examples contain intentional common security flaws. Use caution if cutting and pasting!
Previous Semesters
- Summer 2008: Mini-course
Mini course schedule, materials, and finished games are all available online. - Fall 2007: Tutorials
COMP 1501 - Introduction to Computer Game Design
Tutorial material I wrote is available here along with links to the other tutorials. - Winter 2006, Winter 2007, Winter 2008: Tutorials
COMP 1006/1406 - Design and Implementation of Computer Applications Tips from tutorial materials I wrote are available.
- Fall 2005, Fall 2006: Tutorials
COMP 1005/1405 - Introduction to Object-Oriented Programming
- Winter 2005, Winter 2004: Marking
COMP 2005/2405 - Internet Application Programming
- Fall 2004, Fall 2003: Marking
COMP 3008 - User Interface Architecture