Program cgs4854pgm4hx_5k (2020Fall) CGS 4854 - Website Construction and Management Professor: Michael Robinson e-mail : michael.robinson@cs.fiu.edu ****************************************************************************** * !!!!*** USE THE TOOLS THAT WE HAVE LEARNED IN OUR CLASS ONLY ***!!!! * ****************************************************************************** -------------------------------------------------------------------------------- Worth 15 Points - Make sure your program is properly documented and aligned uniformally, looking professionally, I will take points off if it is not. - Include the following documentation in EVERY web page: Purpose of this program: ------------------------ - Create this assignment using an editor only, NO TEMPLATES OR IDES ALLOWED. - Extend your current website creating the new pages, described below, using css3, php and mySql - Using tools shown ***** IN CLASS ONLY *****. New Programs to be created: --------------------------- 1) Program4.php 2) Controller4.php 3) Save.php 4) Find.php 5) Modify.php 6) Delete.php 7) Clear.php 1) Program4.php --------------- a) *** DO NOT MODIFY YOUR PROGRAM2.PHP or CONTROLLER2.PHP *** b) Copy your program2.php into program4.php, in your includes folder. c) In program 4, FIX the errors, if any, that you had in program 2 to avoid losing points again. d) Copy your Controller2.php into Controller4.php, in your includes folder. e) Add a NEW link called program 4 to your mainMenu.php, to display the following: home program 1 program 2 program 4 In this program extend your mainMenu.php dropdown menu, See examples at: http://users.cis.fiu.edu/~mrobi002/teaching/cgs4854/CSS/cssDropdownMenu.html Choose whatever colors, fonts and sizes you want, When you press the "program 4" link load a new page named program4.php, located in your includes folder, displaying the following front end, in the following order: **** MAKE SURE YOUR first field (on your program4 front end) is your mySql Primary Key field, regarless of what you call it, examples: Customer Number, Order Number, Panther ID, Email, Telephone, etc AGAIN, in the following order: - Display your header page named YourLastName_header.html, found in your includes folder, - The First line can be any color, any font, any size - Your Full name can be any color, any font, any size - The horizontal line MUST BE green - Any background color is allowed, if you want to use one, displaying the following Front End (centered): ====This is a Teaching Website==== Your Full Name _______________________________________________________________________________ Home Program 1 Program 2 Program 4 Telephone ________________ Email _______________________ Last Name _______________________ First Name _______________________ Address _____________________________ City _____________ State _____________ Country _____________ Zip _________ Dropdowns ___________________^ Coffee o Light o Cuban o Sweet o Decaf Major [] IT [] CS [] Robotics [] Cyber Comments ---------------- | | | | ---------------- $message Save Find Modify Delete Clear your full name - MAKE SURE THAT YOUR FRONT END IS TOTALLY ALIGNED AS SHOWN ABOVE. - MAKE SURE TO HAVE THE SHOWN LINE SPACES ABOVE - MAKE SURE THAT YOUR radio buttons are aligned with your checkboxes - On the title section display your last name, first name, Program 4 - When you press any of the following five(5) buttons Save Find Modify Delete Clear call a new page named Controller4.php, implementing each of the buttons as follows: 2) Controller4.php ------------------ Create the following programs, inside the includes folder, which will be called by your Controller4.php: 1) Save.php 2) Find.php 3) Modify.php 4) Delete.php 5) Clear.php The above programs will implement the following functions as follow: 3) Save.php ----------- To save a record in your mysql table, enter the primary key on program4.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 program4.php front-end, using POST, to save.php, using your controller4.php program. If the record is not FOUND in the customer table, save.php will add the new record into the customer table, containing all the data entered in program4.php, displaying on the $message "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 "RECORD yourPrimaryKey ALREADY EXISTS" using RED color, LEAVING all the data on the screen. 4) Find.php ----------- To find a record in your customer mysql table, enter the primary key on program4.php and press the FIND button, program4.php will pass the primary key value, using POST, to your controller4.php program, which then will call your find.php If the record is found in the customers table, display all the corresponding fields found in your database, on the front-end of your program4.php, and on the $message, using blue color, display "RECORD yourPrimaryKey FOUND". LEAVING all the data on the screen else on your $message using red color, display "RECORD yourPrimaryKey NOT FOUND". LEAVING all the current data on the front-end of program4. 5) Modify.php ------------- 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, then using the Controller4.php, call modify.php to update your customer table with all the data in program4.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 LEAVING all corresponding field(s) on the program4.php front-end. else If the record can NOT be modified in the table, at $message using red color, display "RECORD $PRIMARY_KEY CAN NOT BE MODIFIED, FIND IT FIRST". 6) Delete.php ------------- Before you can delete a record, you need to find it. When the DELETE button is pressed on the program4.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 using red color, display "RECORD $PRIMARY_KEY DELETED". LEAVE ON THE front-end of program4.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 (in case other user deleted this record while you where trying to delete it), on the $message using red color, display "RECORD $PRIMARY_KEY CAN NOT BE DELETED, IT DOES NOT EXISTS". DO NOT ERASE THE DATA ON PROGRAM 4 FRONT-END 7) Clear.php ------------ When the clear button is pressed on the program4.php front-end, controller4.php will call clear.php which will set all memory values to "" and then controller4.php will call program4.php front-end, which will display all current memory values, AGAIN: ====== New Programs to be created: 1) Program4.php 2) Controller4.php: 3) Save.php 4) Find.php 5) Modify.php 6) Delete.php 7) Clear.php 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 https://users.cs.fiu.edu/~mrobi002/includes/Web_Videos/Web_2020_Videos/2020_Summer/Web_2020Summer.php - In program 4, FIX the errors, if any, that you had in program two to avoid losing points again. Submission of program 4: ------------------------ 1 - Zip your public_html folder and rename it as follows: your last name, first initial of your first name, pgm4, zip and upload it to CANVAS, when this program is due, or before. If you have any questions, please 1 - email me at michael.robinson@cs.fiu.edu 2 - Contact our FREE Online Tutoring, open 6 (six) day a week. https://users.cs.fiu.edu/~mrobi002/tutoring/includes/tutoringOnline2020Fall.php *** PLEASE REMEMBER, WE ARE HERE TO HELP YOU ***