Program 4e cgs4854pgm4e


CGS 4854 - Website Construction and Management
Professor: Michael Robinson 
e-mail   : michael.cs.robinson@fiu .edu 
Web Page : www.cs.fiu.edu/~mrobi002/teaching 


- Make sure the program is properly documented and aligned uniformally, looking professionally,
- Include the following header in every program:


<%-- ***********************************************************************************
Author     : Your Name 
Your URL   : ocelot-aul.fiu/~__________
Course     : CGS 4854 session, date, and time
Program #  : Assignment Purpose/Description 
             {A brief description of the program } 

Due Date   : MM/DD/YYYY 
Certification: 
I hereby certify that this work is my own and none of it is the work of any other person. 

 ..........{ your signature }..........

************************************************************************************** %>

Purpose of this program:
Extenting website with multiple pages using html and php, mySql, css. Version 3

How:
- Connect to ocelot.aul.fiu mysql
- Create a table in the students DB called "Employees"
  with the fields described in question 2
- Make the Account Number the primary key


 Create a web application using an editor 

Program worth 10 points total

A) - Worth 7 Points
   ***********************************************************
   *                                                         *
   * make sure your name appears at the bottom of every page *
   *         in New Times Roman  size 20  color Red          *
   *                                                         *
   ***********************************************************
   
   - From the index page using a new link call a page called Employees
   - In the Employee page create input fields to accept the following data as follows:
    
   
                                      Employee Vitals
   
   Account Number  First Name            Middle Name           Last Name      
   _____________   ___________________   ___________________   ___________________    
   
                         __________comment line_____________
    
                          Find   Save   Modify   Delete   
                         
   
   - Create a display section called comment line to display the processes done, such as
     Record Found, Record Saved, Record Modified, Record Deleted.
        
   - Find, Save, Modify, Delete must be buttons
      
   - Find. To find a record enter the Account Number and press the Find button.
     Using POST pass the Account Number to the Database. If the record is found in the 
     Database display "Record Found" in the comment line and display the record, 
     else display "Record NOT found" on the comment line and leave the Account Number
     you entered. 
      
   - Save. If record is not FOUND in the the Database, enter all the information on the
     page and press Save, passing all data to the Database using POST, and display
     "Record Added" on the comment line. LEAVE all data in their appropiate fields on the
     screen. If the record could not be saved display in red RECORD NOT SAVED
     
   - Modify. If record is in the Database, modify any field and save it by pressing the Modify 
     button, passing the data to the Database using POST and display "Record Modified" on
     the comment line.  LEAVE all data in their appropiate fields/boxes.  If the record could
     not be modified display in red RECORD NOT MODIFIED
    
   - Delete. Find a record on the Database and delete it by pressing the Delete button,
     LEAVE the data on the screen and display on the comments section on RED
     RECORD DELETED. LEAVE all data in their appropiate fields/boxes on.
     If record is NOT found in the database display on the comments section on RED
     RECORD NOT FOUND.
      
B) - Worth 3 Points 
     In your HOME page add a link called "Send Email"

     Follow my "Contact Me" link at:
     http://users.cis.fiu.edu/~mrobi002/contactsus/contactUs.php
     so that I can send you a message.



Print the pages to be turn in at the beggining of class.