Adventures in Computing: CGI/PHP (1.5/2 cr.)

Thu Jun 26

Text of the minute paper e-mailed along with the code you should start from.

Tue Jun 24

Possibly useful Python tutorial (was used in A201/A598 a couple of years ago).

Fri Jun 20

Here's the actual portfolio you need to build for this class.

Leigh Wilson came up with the following set of useful links that might help with our study:

read this online Perl tutorial.
read this online Python/CGI tutorial.
look through Sam's Teach Yourself Python in 24 Hours from Books 24x7
look through Sam's Teach Yourself CGI in 24 Hours especially hour 10
look through Learn Perl in a Weekend: (Sunday Evening: Perl and the Internet, from the same Books 24x7)
look through this PHP tutorial, also Sams Teach Yourself PHP4 in 24 Hours (Hour 4: The Building Blocks)
look through this SQL tutorial Sams Teach Yourself PHP4 in 24 Hours (Hour 12: Database Integration)

By the end of the day on Monday we should all have PHP and MySQL installed and ready for use.

Fri Jun 13

Here are the (minimal) solutions for the semester portfolios:

Task 01: Apache
Task 02: Unix/HTML
Task 03: Perl/Python
Task 04: CGI with Perl and Python
Task 05: Keeping state (CGI/hidden fields)
Task 06: SQL and MySQL
Task 07: PHP
Task 08: PHP sessions
Task 09: Database access from PHP, Perl and Python
Task 10: Implementing CGI sessions with Perl DBI

Fri Jun 13

Nothing is due at this time but here's how this class will proceed. .

There are no midterm or final exams in this class.

There will be ten broad tasks we will be working on together:

Installation of Apache and basic Apache maintenance.
Basic Unix and HTML.
Introduction to Perl and Python.
CGI with Perl and Python.
Keeping state in CGI using hidden fields.
Installation of PHP; relationship of PHP with CGI.
Installation of MySQL; basic SQL commands for database setup.
PHP sessions. Using sessions to keep state.
More SQL commands; database access using PHP, Perl and Python.
Implementation of a session-based mechanism for CGI using Perl DBI.

We will work TOGETHER on these tasks. Hopefully everything will be finished in class.

You may have to finish some of this on your own, with instructor's guidance, office hours etc.

Each task is worth 10% of the grade. The grade scale is included below:

0-54 55-65 66-67 68-69 70-75 76-77 78-79 80-85 86-87 88-89 90-95 96-100

F D D+ C- C C+ B- B B+ A- A A+

If you come to every class and follow with attention you should be able to get an A easily.

Attendance is then very important. Office hours (11:00am-noon and 2-3pm daily in LH201D) are also very useful.

Task 01:	Apache
Task 02:	Unix/HTML
Task 03:	Perl/Python
Task 04:	CGI with Perl and Python
Task 05:	Keeping state (CGI/hidden fields)
Task 06:	SQL and MySQL
Task 07:	PHP
Task 08:	PHP sessions
Task 09:	Database access from PHP, Perl and Python
Task 10:	Implementing CGI sessions with Perl DBI

0-54	55-65	66-67	68-69	70-75	76-77	78-79	80-85	86-87	88-89	90-95	96-100
F	D	D+	C-	C	C+	B-	B	B+	A-	A	A+