Program pgm5cc_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. 1 - Include the following header in every web page, pgm5.php and Controller5.php: 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, mySql and javascript - Using tools shown ***** IN CLASS ONLY *****. - In this program we will 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, Program 5: ---------- - Copy your program4.php into program5.php - Copy your Controller4.php into Controller5.php - Add a NEW link called program 5 to your CSS mainMenu.php, to display the following: home program 1 program 2 program 3 program 4 program 5 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, **** 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 When you press link "program 5" this link will load a new page named program5.php displaying the following front end, in the following order: ====This is a Teaching Website==== Joe Smith ________________________________________________________________________________________________ Logged in: Sun Oct 26 2099 19:39:11 GMT-0500 (EST) Current Time: 19:39:20 home program 1 program 2 program 3 program 4 program 5 Telephone Number ________________ Email Address ________________ Last, First Name ______________________________________________ Full Address ______________________________________________ City _____________ Major [] IT [] CS [] Robotics [] Cyber State _____________ Coffee o Light o Cuban o Sweet o Decaf Country _____________ Dropdowns ___________________^ Zip _________ Comments ---------------- | | | | ---------------- $message Save Find Modify Delete Clear Contact_Me Help About Quotes Leads home program 1 program 2 program 3 program 4 program 5 - MAKE SURE THAT YOUR FRONT END IS TOTALLY ALIGNED AS SHOWN ABOVE. - MAKE SURE TO HAVE THE SHOWN LINE SPACES ABOVE BETWEEN ROWS - On the title section display your last name, first name, Program 5 ------------------ 2 - On the title section display your last name, first name, Program 5 3 - When you press the Quotes or Leads submit button, call the new expanded page named Controller5php, implementing each of the previous buttons and adding the following functions: - Create the following programs, inside the includes folder, called by Controller5 - Quotes.php - Leads.php These programs will implement the following detailed instructions: 4 - Create a new table called quotes with the fields described on question 5. 5 - Create the Quotes.php program that will allow us to save unique data into the quotes table (see question 4). On this page the SUBMIT button saves the data entered and the CLEAR button clears the memory contents of all data entered on the current front end. **** NOTE **** Telephone IS THE PRIMARY KEY Your page should look like this: ====This is a Teaching Website==== Joe Smith ________________________________________________________________________________________________ Logged in: Sun Feb 26 2099 19:39:11 GMT-0500 (EST) Current Time: 19:39:20 home program 1 program 2 program 3 program 4 program 5 Quotes Telephone ______________________ First Name ______________________ Last Name ______________________ Email ______________________ ______________________ Comments | | | | | | ---------------------- $message SUBMIT CLEAR 6 - Create the quotesController.php program which will accept data from the Quotes.php program writting that data to the quotes table 7 - LEADS. Create the leads.php program to access the quotes table, reading and displaying each record in the following mannner: FIRST NEXT PREVIOUS LAST. This page should look like this: ====This is a Teaching Website==== Joe Smith ________________________________________________________________________________________________ Logged in: Sun Feb 26 2099 19:39:11 GMT-0500 (EST) Current Time: 19:39:20 home program 1 program 2 program 3 program 4 program 5 Leads Telephone ______________________ First Name ______________________ Last Name ______________________ Email ______________________ ______________________ Comments | | | | | | ---------------------- $message FIRST NEXT PREVIOUS LAST **** NOTE **** Telephone IS THE PRIMARY KEY 8 - Create the leadsController.php program which will obtain records from the quotes table using the first.php, next.php, previous.php, last.php, as requested by the user. **** NOTE **** Telephone IS THE PRIMARY KEY All records must be extracted from the quotes file based on alphabetical order, example: aa, ab, ac, ad, ae, af, ....... zz New programs needed: Quotes.php quotesController.php Leads.php leadsController.php first.php next.php previous.php last.php FIRST. When the user presses the FIRST button, using leadsContructor.php call first.php which will retrieve the first record in the quotes file, then sends it back to leadsContructor.php to be displayed on leads.php (USING THE PRIMARY KEY) NEXT. When the user presses the NEXT button, using leadsContructor.php call next.php which will retrieve the next record in the quotes file, then sends it back to leadsContructor.php to be displayed on leads.php (USING THE PRIMARY KEY) If your next record is your last record display in the $message area: THIS RECORD PRIMARY KEY IS YOUR LAST RECORD PREVIOUS. When the user presses the PREVIOUS button, using leadsContructor.php call previous.php which will retrieve the previous record in the quotes file, then sends it back to leadsContructor.php to be displayed on leads.php (USING THE PRIMARY KEY) If your PREVIOUS record is your FIRST record display in the $message area: THIS RECORD PRIMARY KEY IS YOUR FIRST RECORD LAST. When the user presses the LAST button, using leadsContructor.php call last.php which will retrieve the last record in the quotes file, then sends it back to leadsContructor.php to be displayed on leads.php (USING THE PRIMARY KEY) - In program 5, FIX the errors, if any, that you had in programs 2, 3 and 4 to avoid losing points again. Submission of program 5: ------------------------ 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 2 - Ask our FREE professional tutors at PG6 Room 102