CSc 4998. Web Programming
Spring 2006, Assignment 5 (MySQL and PhP)
Due: April 30, 2006 (Sunday)

Consider the following relational table for maintaining contact information: 

create table contacts (
  lname  varchar(30),
  fname  varchar(30),
  email  varchar(30),
  homePhone varchar(20),
  cellPhone varchar(20),
  officePhone varchar(20),
  address varchar(100),
  comment varchar(100),
  primary key (lname,fname)
);
Design and implement a set of HTML/PhP pages that allow the user to
  1. ADD a contact
  2. DELETE one or more contacts: You need to show all the contacts in a tabular form with check boxes next to each contact; The user will choose contacts to delete by checking the checkboxes and Submitting the form.
  3. UPDATE one or more contacts: You need to show all contacts in a tabular form with check boxes next to each contact; The non-key columns should be displayed as text boxes so that the user may change values; The user chooses contacts to be updated and provides new values in the text boxes and submits.
  4. SEARCH by keyword: Search only fname or lname.
  5. LIST all contacts (one page with just fname and lname - hyperlinked); Hyperlinks lead to a detailed page.