Program #4, cgs4854pgm4f

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


 Worth 10 points


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


  <%-- ***********************************************************************************
  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:
- Create the following pages using an editor NO TEMPLATES OR IDES ALLOWED
- Extend website with multiple pages using html, php, mySql, css to previous assignment


How:
 - On your index page, using a new link, call a page named Data.
 - In the Data page, create fields for the information corresponding to your website's
   topic as follows:

   Input areas must have at least:
   - 4 Regular Input
   - 1 Radio button
   - 1 Dropdown box
   - 1 Check Box   
   - 1 Textarea input
   - 4 Submit buttons
   - 1 Clear/Reset button
   - 3 Display areas
   
   

Example:

                         Your Company Name (this is a title on the screen)
  
                  Employee #      _____________ 
                  First Name      _____________  
                  Last Name       _____________    
                  Email           _____________
                  Age             o Under 20  o 20-30  o 31-40
                                  o 41-50     o 51-60  o Above 60     
                  Gender          _____________[^]   
                  Preferences     []CS []IT []Robotics []Medical [] Engineering
                                  And others __________________________________ 
                                  ___________________________________   
                  Special Needs  | Non-Smoking area                  |
                                 | Sugar-Free diet                   |
                                 | Large letter monitor              |
                                 -------------------------------------


                             __________Submit Comment Line_____________
  

                            FIND   SAVE   MODIFY   DELETE   CLEAR   HELP   
                         
      
                   ***********************************************************
                   *    make sure your name appears HERE of every page       *
                   *         in New Times Roman, size 20, color Red          *
                   ***********************************************************



Details:
- In the Submit Comment Line display the process being done.
- FIND, SAVE, MODIFY, DELETE, and CLEAR must be buttons.

Buttons Purpose:
- FIND. To find a record enter the primary key and press the FIND button,
  then pass the primary key, using POST, to the table. If the record is found 
  display it in their corresponding fields, else on the Submit Comment Line,
  using red color, display "RECORD NOT FOUND"
  
- SAVE. If the record is not FOUND in the table, enter all the information on the
  page and press SAVE. The SAVE button will call another page that will add into
  the table all the data entered, using POST, and will display "Record Added"
  on the Submit Comment Line. Display all data in their corresponding fields on
  the screen.
  If the record already exist in the table, DO NOT ACCEPT THE DATA, and display
  "RECORD ALREADY EXISTS" on the comment line, using RED color, LEAVING all the
  data on the screen. 
  
- MODIFY. If a record exits in the table, and you want to modify any field, 
  re-enter the new field(s) and press the MODIFY button.
  The MODIFY button will then call another page which will UPDATE the record in
  the table, passing the data using POST. Then display "Record Modified" on the
  Submit Comment Line. On the screen LEAVE all data in their corresponding fields.
  
- DELETE. When the DELETE button is pressed, find in the table the record that
  corresponds to the primary key entered on the screen. If the record is found,
  delete it from the table and on the Submit Comment Line, using red color,
  display "RECORD DELETED". Leave on the screen all the data corresponding to 
  the deleted record so that the user can re-save it in case the record was
  deleted by mistake.
  
- CLEAR. This button will clear all the data on the monitor.

- HELP. Using JavaScript display the above descriptions starting at:
        Buttons Purpose:


Special Instructions:
In your code:
- Connect to ocelot.aul.fiu mysql.
- In your demo database create a table called data with the field types described above.
- Make sure you have a primary key.
- Additional code samples: 
  http://users.cis.fiu.edu/~mrobi002/databases/cgs4854/ 
  http://users.cis.fiu.edu/~mrobi002/includes/OcelotCreatingWebsite    
  http://users.cis.fiu.edu/~mrobi002/downloads/webSqlSamples/  

Please remember that the above code has errors, in purpose, so that you just 
DO NOT COPY AND PASTE the code. 

   
Print the corresponding pages, of this program, and turn them in at the begining of class.