Program pgm3g_5Web 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 6 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 html, css3, php and mySql - Using tools shown ***** IN CLASS ONLY *****. Program 3: ---------- a) Copy your program2.php into program3.php b) In program 3, FIX the errors, if any, that you had in program 2 to avoid losing points again. c) Copy your Controller2.php into Controller3.php d) Add a NEW link called program 3 to your CSS mainMenu.php, to display the following: home program 1 program 2 program 3 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 3" link load a new page named program3.php, located in the includes folder, displaying the following front end, in the following order: **** MAKE SURE YOUR Primary Key field is a Primary field regarless of what you call it, examples: Customer Number, Order Number, Panther ID, Email, Telephone, etc In the following order: *** MAKE SURE TO display the heading "Program 3" in bold and red color *** ====This is a Teaching Website==== Joe Smith _____________________________________________________________________ Program 3 Home Program 1 Program 2 Program 3 Telephone ________________ Email Address ________________ Last Name _______________________ First Name _______________________ Address _____________________________ City _____________ State _____________ Country _____________ Zip _________ Major [] IT [] CS [] Robotics [] Cyber Coffee o Light o Cuban o Sweet o Decaf Dropdowns ___________________^ Comments ---------------- | | | | ---------------- $message Save Find Modify Delete Clear Contact_Me Home Program 1 Program 2 Program 3 - MAKE SURE THAT YOUR FRONT END IS TOTALLY ALIGNED AS SHOWN ABOVE. - MAKE SURE TO HAVE THE SHOWN LINE SPACES ABOVE - On the title section display your last name, first name, Program 3 - When you press any of the folling six(6) buttons Save Find Modify Delete Clear Contact_Me call a new page named Controller3.php, implementing each of the buttons as follows: e) Create the following programs, inside the includes folder, which will be called by your Controller3.php: 1) Save.php 2) Find.php 3) Modify.php 4) Delete.php 5) Clear.php 6) Contact_me.php The above programs will implement the following functions as follow: SAVE ---- To save a record in your mysql table, enter the primary key on program3.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 program3.php front-end, using POST, to save.php, using your controller3.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 program3.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. FIND ---- To find a record in your customer mysql table, enter the primary key on program3.php and press the FIND button, program3.php will pass the primary key value, using POST, to your controller3.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 program3.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 program3. 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, then using the Controller3.php, call modify.php to update your customer table with all the data in program3.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 program3.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". DELETE ------ Before you can delete a record, you need to find it. When the DELETE button is pressed on the program3.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 using red color, display "RECORD $PRIMARY_KEY DELETED". LEAVE ON THE front-end of program3.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 3 FRONT-END CLEAR ----- When the clear button is pressed on the program3.php front-end, controller3.php will call clear.php which will set all memory values to "" and then controller3.php will call program3.php front-end, which will display all current memory values, CONTACT_ME ---------- When you press the Contact_me button, call the Contact_me.php program, which will look like this: *** MAKE SURE TO display the heading "CONTACT ME" in bold and red color *** ====This is a Teaching Website==== Joe Smith _____________________________________________________________________ CONTACT ME Home Program 1 Program 2 Program 3 Your Email ___________________ Last Name ___________________ First Name ___________________ Dropdowns ___________________^ Coffee o Light o Dark o Sweet Major [] IT [] CS [] Physics Comments ------------------- | | | | ------------------- Submit Clear Home Program 1 Program 2 Program 3 Fill in all the information requested on the Contact_me.php front end and then press the SUBMIT This program will call it's own Contact_me_Controller.php, located in the includes folder, which will send all the data inputed in the Contact_me front end, to my email = michael.robinson@cs.fiu.edu the data send MUST BE ALIGNED in two columns: the field label and the corresponding data, example I recommend that you first sent this email to your email, until it displays as shown below, and then change your email address with my email address Your Email abc@abc.com Last Name Smith First Name Joe Dropdowns value chosen Coffee Light or Dark or Sweet Major IT CS Robotics Physics Comments This is the comments data After you send your "Contact_me" data, display the following: ====This is a Teaching Website==== Joe Smith _____________________________________________________________________ CONTACT ME Home Program 1 Program 2 Program 3 Your message has been submitted, thank you 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/contactsus/contactUs.php - In program 3, FIX the errors, if any, that you had in program one and two to avoid losing points again. Submission of program 3: ------------------------ 1 - Zip your public_html folder and rename it as follows: your last name, first initial of your first name, pgm3, zip and upload it to CANVAS, when this program is due, or before. If you have any questions, please 1 - email me 2 - Ask our FREE professional tutors at PG6 Room 102