Program 4d cgs4854pgm4d

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 2

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


 Create a web application using an editor 

 Worth 10 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 purchasing.
 - In the purchasing page create input fields to accept the following data:

   
                                  Providers
  
                      Account Number  _____________    
                      Company Name    _____________     
                      Contact Name    _____________     
                      Phone Number    _____________     

                         Find   Save   Modify   Delete
                         
                      __________comment line_____________


- Find, Save, Modify, Delete must be buttons

- Create a display section called comment line to display the processes done, such as
  Record Found, Record Saved, Record Modified, Record Deleted.

- Find. To find a record enter the customer's 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, else display "Record NOT found" 
  on the comment line. 
  
- 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 .
      
 
Print the pages to be turn in at the beggining of class.