Instructions Classicvehicles

User Manual:

Open the PDF directly: View PDF PDF.
Page Count: 2

DownloadInstructions-classicvehicles
Open PDF In BrowserView PDF
IIW512 PHP

UC Davis Extension

Final Project - 70 points possible
You will create a small website that will connect to your sample database. The site is to be treated as a real site, in that it
should have a consistent appearance throughout the site with consistent:
•
•
•
•

Header
Navigation
Footer
Site colors and graphics

All documents output to the client are to be valid HTML and CSS. You can code in XHTML or HTML5. All CSS is to be in an
external file.
The premise of the site is employee access to the “Classic Car” site, using the class sample database. Modifications to
the database will be needed to accomplish some features needed for the project.
Pages Required
1. Public homepage with user login
o On successful login, redirect user to private welcome page. If login is unsuccessful, display appropriate
error with prompt to try again.
2. Public account creation page
o Allow user to create a login to the site with at least a username and password. Passwords are to be
encrypted via MD5 in the database. User account is to be in the ‘employees’ table.
3. Private welcome page
o Includes navigation options for logged in users
4. Private Product Inventory report
o User selectable report from ‘productLine’ field in ‘products’ table. Generate paging report of 10 items
per page of selected ‘productLine’ option. Pagination can be any workable format.
5. Private Customer entry page
o Enter full customer data record that will populate all fields in the ‘customers’ table.
6. Private Bar chart report
o Chart will display number of customers in defined ‘creditLimit’ ranges:
 creditLimit = 0
 creditLimit from 1 to 50,000
 creditLimit from 50,001 to 75,000
 creditLimit from 75,001 to 100,000
 creditLimit greater than 100,000
7. Public - RSS feed of vehicle types
o To be created as a generic page, so a GET variable can be passed in the URL to view the feed of each
different ‘productLine’. At least three RSS feed links are to appear on a public page.
8. Private logout page
o Upon successful logout, display to user logout success message and redirect to public home page after 8
seconds.
Page 1 of 2

IIW512 PHP
Grading Scale
•
•
•
•
•

UC Davis Extension

40 points for all pages completed (5 points per page)
o Partial credit will be given if intent of page is attempted
5 points for site template – repeated page elements must be includes
10 points for valid HTML output andCSS
10 points for clean/readable PHP, HTML, CSS code, and logical directory structure
5 points for clean/readable HTML code output

Site Testing and Scoring
To test and score your project, the account creation page will be used to create a login, then that login will be
used to authenticate into the private side of the site. All pages will be tested for correct content and
authentication security, including the logout page.
Project Submission
You will submit a zip file containing all related files in the appropriate directory structure, named ‘yournamefinalproject.zip’. You will also submit the URL of the site live on the Internet.

Page 2 of 2



Source Exif Data:
File Type                       : PDF
File Type Extension             : pdf
MIME Type                       : application/pdf
PDF Version                     : 1.5
Linearized                      : Yes
Author                          : WCC Podium User 845
Company                         : YCCD
Create Date                     : 2014:05:15 13:40:03-07:00
Modify Date                     : 2014:05:15 13:40:03-07:00
Source Modified                 : D:20140515203957
Language                        : EN-US
Tagged PDF                      : Yes
XMP Toolkit                     : Adobe XMP Core 5.4-c005 78.147326, 2012/08/23-13:03:03
Metadata Date                   : 2014:05:15 13:40:03-07:00
Creator Tool                    : Acrobat PDFMaker 11 for Word
Document ID                     : uuid:96cb945e-bde0-438a-aefd-8d2078b1e3b1
Instance ID                     : uuid:ce2e30dd-1af6-4161-bd55-4a1492616016
Subject                         : 5
Format                          : application/pdf
Creator                         : WCC Podium User 845
Producer                        : Adobe PDF Library 11.0
Page Layout                     : OneColumn
Page Count                      : 2
EXIF Metadata provided by EXIF.tools

Navigation menu