Program cgs4854pgm4b_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 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 PGM4. Make sure to leave previous buttons and its contents as they were turned in for program 3. - Most of the material for program 4 is new material, we are just extending the knowlegde from program 3. - This is the front end look for program 4 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 # Telephone #_______ First Name First Name________ Last Name Last Name_________ Email Email_____________ ___________________________________ Requests | Requests | | | | | ------------------------------------- Samples Samples________[^] Preferences []CS []IT Miles o Under 20 o 20-30 ______Submit Comment Display area #2______ FIND SAVE MODIFY DELETE CLEAR ******************************* new main css menu ************************* Purpose of program 4: 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 pgm4.php and press the FIND button, pgm4.php will pass the primary key value, using POST, to find.php, using your controller4.php program. If the record is found in the customers table, display all the corresponding fields found 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, Using controller4.php, pass all the data entered on pgm4.php front-end, using POST, to save.php, using your controller4.php program. If the record is not FOUND in the table, save.php will add into the customer 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 field(s) you need to modify and press the MODIFY button, using the Controller4.php, call modify.php to update your customer 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 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 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 Upload to moodle AND blackboard a zipped copy of your public_html folder RENAMING it by adding your name and class number (WEB 1, 2, 3 or 4)