Program cgs4854pgm3j Worth 10 points CGS 4854 - Website Construction and Management Professor: Michael Robinson server = as provided and tested in class usernames = as provided and tested in class password = as provided and tested in class - 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 : WEB1, 2, 3 OR 4 Program Name : Asignment 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: - To your main CSS menu add a new link called PGM3. Make sure to leave the functionally of program 1 and program 2 as it was turned in. - All the material for program 3 is new material, we are just extending the knowlegde from previous programs - This is the front end look for program 3 Your Company Name (display area #1) *********************** new main css menu ********************** Telephone # _____________ First Name _____________ Last Name _____________ Email _____________ Gender _____________[^] Age o Under 20 o 20-30 o 31-40 o 41-50 o 51-60 o Above 60 Preferences []CS []IT []Robotics []Engineering ___________________________________ Special Needs | Non-Smoking area | | Sugar-Free diet | | Large letter monitor | ------------------------------------- ______Submit message Display area #2______ FIND SAVE MODIFY DELETE CLEAR *********************** new main css menu ********************** Details: Implement all the buttons ( FIND SAVE MODIFY DELETE CLEAR ) as follows: - FIND. To find a record in your mysql table, enter the primary key on pgm3.php and press the FIND button, then pass the primary key value, using POST, to find.php using the Controller3.php. If the record is found in the table, display all the corresponding fields on the screen (pgm3.php) and on the message display area #2 diaplay RECORD $PRIMARY_KEY FOUND, else on the message display area #2, using red color, display "RECORD $PRIMARY_KEY NOT FOUND" - SAVE. If the record is not FOUND in the table, enter all the customer information on the pgm3.php page and press SAVE. The SAVE button, using the Controller3.php, will call save.php to add into the table all the data entered in pgm3.php, using POST. If the record does not exist in the table, on the message display area #2, display "RECORD $PRIMARY_KEY ADDED". If the record already exist in the table, DO NOT ACCEPT THE DATA, and display "RECORD $PRIMARY_KEY ALREADY EXISTS" on the message display area #2, using RED color, LEAVING all the data on the screen. - MODIFY. Before you can delete a record, you need to find it. If a record exits in the table, and you want to modify any field(s), re-enter the new field(s) and press the MODIFY button. The MODIFY button, using the Controller3.php, will call modify.php to add into the table all the data entered in pgm3.php, passing the data using POST. Then display "RECORD $PRIMARY_KEY MODIFIED" on the message display area #2. On the screen LEAVE all data in their corresponding fields. - DELETE. Before you can delete a record, you need to find it. When the DELETE button is pressed on the pgm3.php page, using the Controller3.php, call delete.php. If the record exists in the table, delete it from the table and on the message display area #2, using red color, display "RECORD $PRIMARY_KEY 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 set all memory values to "" and then when they get re-displayed on the pgm3.php page, the screen will be cleared as well. Special Instructions: - 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/includes/Web.php Print the corresponding php pages to this program ***** ONLY ***** and turn them in *** STAPLED **** at the begining of class. UPLOAD a zipped copy of your public_html folder RENAMED as follows: yourLastNameFirstInitialpublicHtmlPgm3