CTEC1731 Enterprise Computing III

Announcements

• [Mon Aug 30 14:55:07 EDT 2010]
  Lab #3 has been posted.

• [Mon Aug 30 14:55:30 EDT 2010]
  First class is on Wednesday, September 8th at 9:30 am in L-5.  We will do Lab #3 — installing Apache, PHP and MySQL.

• [Fri Apr 9 10:27:33 EDT 2010]
  Labs #0, #1, and #2 are available.

• [Tue Dec 22 13:30:25 EST 2009]
  This course will be offered for the last time in the 2010 Fall term, starting in September 2010.  The prerequisite course is CTEC1641.

Notes and Code

Online books (requires password)

URLs
HTML
HTML Tutorial (from W3C)
Cascading Style Sheet (CSS) examples (start here)

Introduction to databases:  PPS [351,744 bytes]  PDF [193,321 bytes]  MOV [1,545,537 bytes] added Thu Oct 1 2009
SQL databases:  PDF [147,039 bytes] HTML

Web stacks added Thu Oct 1 2009

PHP

PHP examples using mysqli (the "MySQL Improved Extension"):

• README [TXT; 1,252 bytes]
• mysqli [ZIP; 3,765 bytes]
• mysqli [TAR.GZ; 2,288 bytes]

Music Database Example

1. Database files — versions 1 & 2:

   • zip [14,303 bytes]
   • tar [81,920 bytes]

   version 3:

   • zip [16,102 bytes]
   • tarball [7,228 bytes]

2. Perl programs (version 1 only, see the README file for details):

   • zip [92,456 bytes]
   • tarball [89,881 bytes]

3. A CGI application (and updated SQL) for the music database (version 2 only, see the README file for details):

   • zip [7,378 bytes]
   • tarball [4,896 bytes]

4. A PHP application (and updated SQL) for the music database (version 3 only, see the README file for details):

   • zip [15,131 bytes]
   • tar.bz2 [11,163 bytes]
   • tar.gz [11,834 bytes]
   • tar [71,680 bytes]

Labs

Lab #0
Lab #1
Lab #2
Lab #3

Downloads

InfoZip UNZIP for Windows (113K, EXE)
InfoZip ZIP for Windows (104K, EXE)
Apache/PHP/MySQL/Perl/Tidy
Secure Shell (SSH) Clients