Program pgm3h_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 html5, css3, php and mySql - Using tools shown ***** IN CLASS ONLY *****. New Programs to be created: --------------------------- 1) Program3.php 2) Controller3.php 3) Save.php 4) Find.php 5) Modify.php 6) Delete.php 7) Clear.php 8) Contact_me.php 9) Contact_me_Controller.php 10) Styles.php 11) style.css 1) Program3.php --------------- a) DO NOT MODIFY YOUR PROGRAM2.PHP or CONTROLLER2.PHP b) Copy your program2.php into program3.php, in your includes folder. c) In program 3, FIX the errors, if any, that you had in program 2 to avoid losing points again. d) Copy your Controller2.php into Controller3.php, in your includes folder. e) Add a NEW link called program 3 to your HTML5-CSS3 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 your includes folder, displaying the following front end, in the following order: **** MAKE SURE YOUR first field (on your program3 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 3 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 Contact_Me your full name CGS 4854-RVCC (53199) Websiteconmgmt Syllabus 2020 Summer for classes held Online f) Display one empty row after the following submit buttons: Save Find Modify Delete Clear Contact_Me - 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 3 - When you press any of the following six(6) buttons Save Find Modify Delete Clear Contact_Me call a new page named Controller3.php, implementing each of the buttons as follows: 2) Controller3.php ------------------ 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: 3) Save.php ----------- 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. 4) Find.php ----------- 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. 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 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". 6) Delete.php ------------- 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 7) Clear.php ------------ 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, 8) Contact_me.php ----------------- When you press the Contact_me button, call the Contact_me.php program, which will look like this: 1 - Display your header page named YourLastName_header.html, found in your includes folder. then display one empty row. 2 - Display the heading "CONTACT ME" in bold and red color then display one empty row. 3 - Display your mainMenu.php then display one empty row. 4 - After this display all the following labels and input fields (aligned) as shown below. 5 - The submit button will call your new Contact_me_Controller.php program 6 - The clear submit will clear all your php global variables for your contact_me database/table, before refreshing your Contact_me front end. ====This is a Teaching Website==== Joe Smith _____________________________________________________________________ CONTACT ME Home Program 1 Program 2 Program 3 Your Email ___________________ Last Name ___________________ First Name ___________________ Coffee o Light o Dark o Sweet Major [] IT [] CS [] Physics Dropdowns ___________________^ Comments ------------------- | | | | ------------------- Submit Clear Home Program 1 Program 2 Program 3 9) Contact_me_Controller.php ---------------------------- 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 Coffee Light or Dark or Sweet Major IT CS Robotics Dropdowns value chosen 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 to name@fiu.edu thank you 10) Styles.php -------------- Create a new program named Styles.php inside your includes folder, which will be using the following 11) style.css program. 11) style.css ------------- Create a new program named style.css inside your css folder, to apply css display the following LEAVING TWO LINES/ROW IN BETWEEN: your full name CGS 4854-RVCC (53199) Websiteconmgmt Syllabus 2020 Summer for classes held Online Leave one line/row after. New Programs to be created: 1) Program3.php 2) Controller3.php: 3) Save.php 4) Find.php 5) Modify.php 6) Delete.php 7) Clear.php 8) Contact_me.php 9) Contact_me_Controller.php 10) Styles.php 11) style.css 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 https://users.cs.fiu.edu/~mrobi002/css/cssInlineSample.html https://users.cs.fiu.edu/~mrobi002/css/cssInternalSample.html https://users.cs.fiu.edu/~mrobi002/css/cssExternalwithClassAndID.html https://users.cs.fiu.edu/~mrobi002/includes/Web_Videos/Web_2020_Videos/2020_Summer/Web_2020Summer.php - In program 3, FIX the errors, if any, that you had in program 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 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/tutoringOnline2.php *** PLEASE REMEMBER, WE ARE HERE TO HELP YOU ***