Program cgs4854pgm3c_5 Worth 6 points CGS 4854 - Website Construction and Management Professor: Michael Robinson mySqlAccess Server: ocelot.aul.fiu.edu Username: fall17_username Note: username means YOUR user name DB name: fall17_username Note: username means YOUR user name Password: Your panther ID Read instructions to confirm your above mySql access at: https://users.cs.fiu.edu/~mrobi002/includes/OcelotCreatingWebsite - Make sure that ALL your pages are 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 PGM3. Make sure to leave previous buttons and its contents as they were turned in for program 2. - Most of the material for program 3 is new material, we are just extending the knowlegde from program 2. - This is the front end look for program 3 Your Company/Project Name (display area #1) ******************************* new main css menu ************************* Logged in: Sun Feb 26 2099 19:39:11 GMT-0500 (EST) Current Time: 19:39:20 Telephone # _____________ Last Name _____________ First Name _____________ Email _____________ Miles o Under 20 o 20-30 Preferences []CS []IT ____________________________________ Requests | Non-Smoking area | | Sugar-Free diet | | Large letter monitor | ------------------------------------- Samples _____________[^] ______Submit Comment Display area #2______ FIND SAVE MODIFY DELETE ClearScreen *********************** new main css menu ********************** - MAKE SURE THAT YOUR FRONT END IS TOTALLY ALIGNED AS SHOWN ABOVE. Notice that the top 4th line contains this code: Logged in: Sun Feb 26 2099 19:39:11 GMT-0500 (EST) Current Time: 19:39:20 This code is written in javascript and it has to be in one line as shown above, see code: https://users.cs.fiu.edu/~mrobi002/teaching/cgs4854/javascript/timeJS.html and modify it so that the results fit in ONE LINE as shown here: Logged in: Sun Feb 26 2099 19:39:11 GMT-0500 (EST) Current Time: 19:39:20 Purpose of program 3: Implement the buttons ( FIND SAVE MODIFY DELETE CLEAR ) as follows: !!!*** NOTE: Your first field on the front-end MUST BE YOUR PRIMARY KEY ***!!! Create the following programs, inside the includes folder: - find.php - save.php - modify.php - delete.php - clear.php The above programs will implement the following functions: FIND ---- To find a record in your cuatomer mysql table, enter the primary key on pgm3.php and press the FIND button, pgm3.php will pass the primary key value, using POST, to find.php, using your controller3.php program. If the record is found in the customers table, display all the corresponding fields found on the front-end of your pgm3.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 pgm3.php and all the necessary information for that new record, and then press the SAVE button, Using controller3.php, pass all the data entered on pgm3.php front-end, using POST, to save.php, using your controller3.php program. If the record is not FOUND in the table, save.php will add into the customer table all the data entered in pgm3.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 field(s) you need to modify and press the MODIFY button, using the Controller3.php, call modify.php to update your customer table with all the data in pgm3.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 pgm3.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 pgm3.php front-end, controller3.php, will call delete.php. If the record is found in your customer table, delete it from your customer table and on the $message display area #2, using red color, display "RECORD $PRIMARY_KEY DELETED". LEAVE ON THE front-end of pgm3.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 pgm3.php front-end, controller3.php will call clear.php which will set all memory values to "" and then controller3.php will call pgm3.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 Upload to moodle AND if Online class to blackboard,, a zipped copy of your public_html folder RENAMING it by adding your name and class number (WEB 1, 2, 3 or 4)