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.