Program cgs4854pgm4a_5 Worth 6 points CGS 4854 - Website Construction and Management Professor: Michael Robinson Server: ocelot.aul.fiu.edu Usernames: spr17_username db: spr17_username password: Panther ID - 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: - To your main CSS3 menu add a new link called PGM4. Make sure to leave previous buttons and its contents as they were turned in for program 3. - All the material for program 4 is new material, we are just extending the knowlegde from program 3. Your Company/Project Name (display area #1) *********************** new main css menu ********************** Login at: _____________ Current Time: ________ Telephone # _____________ First Name _____________ Last Name _____________ Email _____________ Age o Under 20 o 20-30 o 31-40 Preferences []CS []IT []Robotics Samples _____________[^] ___________________________________ Special Needs | Non-Smoking area | | Sugar-Free diet | | Large letter monitor | ------------------------------------- ______Submit Comment Display area #2______ FIND SAVE MODIFY DELETE CLEAR *********************** new main css menu ********************** Details: Implement the buttons ( FIND SAVE MODIFY DELETE CLEAR ) as follows: !!!*** NOTE: Your first field on the front-end MUST BE YOUR PRIMARY KEY ***!!! - FIND. To find a record in your mysql table, enter the primary key on pgm4.php and press the FIND button, then pass the primary key value, using POST, to find.php using your controller4.php program. If the record is found in the table, display all the corresponding fields on the front-end of your pgm4.php, and on the $message Display area #2, using blue color, display "RECORD yourPrimaryKey FOUND". LEAVING all the data on the screen else on your $message Display area #2, using red color, display "RECORD yourPrimaryKey NOT FOUND". LEAVING all the data on the screen. - SAVE. To save a record in your mysql table, enter the primary key on pgm4.php and all the necessary information for that new record, and then press the SAVE button, After that, using controller4.php, pass all the data entered on pgm4.php front-end, using POST, to save.php. If the record is not FOUND in the table, save.php will add into the table all the data entered in pgm4.php, displaying on the $message Display area #2, "Record yourPrimaryKey Added" using blue color. LEAVING all the data on the front-end else if the record already exist in the table, DO NOT ACCEPT THE DATA, and on on the $message Display area #2, display "RECORD yourPrimaryKey ALREADY EXISTS" using RED color, LEAVING all the data on the screen. - MODIFY. Before you can modify a record, you need to find it first. If the record exits in the table, and you want to modify any field(s), DO NOT MODIFY THE PRIMARY FIELD just re-enter the new field(s) and press the MODIFY button. The MODIFY button, using the Controller4.php, will call modify.php to update your table with all the data in pgm4.php's front-end. Pass data using POST. If the process in modify.php is correctly done, using blue color, display "RECORD $PRIMARY_KEY MODIFIED" on the $message display area #2. LEAVING all corresponding field(s) on the pgm4.php front-end. else If the record can NOT be modified in the table, at $message display area #2, using red color, display "RECORD $PRIMARY_KEY CAN NOT BE MODIFIED, FIND IT FIRST". - DELETE. Before you can delete a record, you need to find it. When the DELETE button is pressed on the pgm4.php front-end, controller4.php, will call delete.php. If the record is found 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 front-end of pgm4.php all the DELETED data of the corresponding record so that the user can re-save the record in case it was deleted by mistake. else If the record is NOT found in the table, at $message display area #2, using red color, display "RECORD $PRIMARY_KEY CAN NOT BE DELETED, IT DOES NOT EXISTS". - CLEAR. When the clear button is pressed on the pgm4.php front-end, controller4.php will call clear.php which will set all memory values to "" and then controller4.php will call pgm4.php front-end, which will display all current memory values, 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 at the begining of class. If you print pages NOT CONTAINING PHP, POINTS WILL BE TAKEN OUT Upload to moodle a zipped copy of your public_html folder RENAMING it by adding your name and class number (WEB 1, 2, 3 or 4)