More SQL that could be used to set up your Homework Three database:

• creating the table of judges is described here
• creating the table of performers:

  create table performers (username char(8) primary key, lastName char(32), firstName char(32));

• putting data in the table of performers:

  insert into performers (firstName, lastName, username) values
    ("Jordan",   "Crawford",  "jcrawfor"),
    ("D.J.",     "White",     "djwhite"), 
    ("Deandre",  "Thomas",    "dthomas"),
    ("A.J.",     "Ratliff",   "ajratlif"),
    ("Eric",     "Gordon",    "egordon"), 
    ("Mike",     "White",     "mwhite"), 
    ("Armon",    "Bassett",   "abassett"),
    ("Jamarcus", "Ellis",     "jmellis"), 
    ("Lance",    "Stemler",   "lstemler");

• creating the ratings table

  create table ratings (player char(8) , judge char(8), rating int, primary key (player, judge)); 

• adding data to it:

  insert into ratings (judge, player, rating) values
  ('lbird'  , 'egordon' ,    9 ),
  ('lbird'  , 'djwhite' ,   10 ),
  ('lbird'  , 'dthomas' ,    7 ),
  ('lbird'  , 'ajratlif',    8 ),
  ('mjordan', 'egordon' ,   10 ),
  ('mjordan', 'mwhite'  ,    8 ),
  ('mjordan', 'abassett',    7 ),
  ('tkukoc' , 'jmellis' ,   10 ),
  ('tkukoc' , 'lstemler',    5 );

• now we can issue queries, for example:

  select all players and the number of votes they have received:

  mysql> select player, count(*) from ratings group by player;
  +----------+----------+
  | player   | count(*) |
  +----------+----------+
  | abassett |        1 | 
  | ajratlif |        1 | 
  | djwhite  |        1 | 
  | dthomas  |        1 | 
  | egordon  |        2 | 
  | jmellis  |        1 | 
  | lstemler |        1 | 
  | mwhite   |        1 | 
  +----------+----------+
  8 rows in set (0.00 sec)

  select all judges with how many votes they cast:

  mysql> select judge, count(*) from ratings group by judge;
  +---------+----------+
  | judge   | count(*) |
  +---------+----------+
  | lbird   |        4 | 
  | mjordan |        3 | 
  | tkukoc  |        2 | 
  +---------+----------+
  3 rows in set (0.00 sec)

  select the judges, and their average ratings:

  mysql> select judge, avg(rating) from ratings group by judge order by avg(rating) desc;
  +---------+-------------+
  | judge   | avg(rating) |
  +---------+-------------+
  | lbird   |      8.5000 | 
  | mjordan |      8.3333 | 
  | tkukoc  |      7.5000 | 
  +---------+-------------+
  3 rows in set (0.00 sec)
  
  

How your website should look (need to add more info below):

	Lab One (01/10-11)
Homework One (due 01/18)	Lab Two (01/17-18)
Homework Two (due 02/01)	Lab Three (01/31-02/01)
Homework Three (due 02/08)	Lab Four (02/07-08)
Homework Four (due 02/15)	Lab Five (02/14-15)
Homework Five (due 02/22)	Lab Six (02/21-22)
Midterm (in class 02/26)	Practical (in lab, 02/28-29)
Homework Six	Lab Eight
Homework Seven	Lab Nine
	Lab Ten
	Lab Eleven
	Lab Twelve

Also please be sure to put this in the passwd file:

-bash-3.1$ cat passwd
dgerman:UIaTPpE.ZpwHw
-bash-3.1$ 

Homework Three will be based on this older final exam in A114/I111.

• page 51
• page 52-53
• page 54-55
• page 56-57
• page 58-59
• page 60-61

Here's some code you could use directly:

./configure \
  --with-mysql=/nobackup/dgerman/mysql \
  --with-apxs2=/u/dgerman/apache/bin/apxs \
  --with-config-file-path=/u/dgerman/apache/conf \
  --with-xml --enable-track-vars \
  --prefix=/u/dgerman/apache

    AddType application/x-httpd-php .php .phtml
    AddType application/x-httpd-php-source .phps

The notes on the class notes page will not add much more to what's posted here.

Steps for installing MySQL: one, two, three, four.

Another set of notes with a shorter sequence of steps.

--log-error=/nobackup/dgerman/mysqld-error.log \

Steps for installing a protected folder: one, two.

clreinki: one

johmyers: two

mrengler: three

Lab on Thu did almost the exact same thing. So, just for our reference.

Here's Homework Two, as formal as we can make it.

• silly card game
• simple addition quiz
• paper, rock, scissors

• a simple flag quiz

Also,

• simple gauge script
• the Lindley portfolio
• basic calculator

Apache installation. Basic Unix commands. HTML

Basic elements of Perl and Python. Simple CGI scripts that keep state.

They've been written for A290/A590 but apply very well here as well.

Additional notes forthcoming and please don't forget about the textbook as well.

Here's a sketch of the steps you need to take (a summary appears on pp. 17-20 in your text).

I will be posting a new set of notes for this week and the next over the weekend.

Andrew's office hours are as follows:

• Wednesday between 12:30-1:30pm in LH415
• Thursday (before lab) between 2:30-3:30pm, also in LH415

Minute paper of yesterday had the following content.

List of port assignments on silo for this semester has been posted.