Having looked at some real clothes sites its now your turn to create one for "Athlete's Foot" an online seller of sports shoes. The aim of the coursework is the search functionality side of the site. We are not looking at issues of ordering and payment.
A home page
The ability to show all shoes.
A range of ways of searching so you can select by colour, size, sex and price.
All pages should contain a link to the full size conversion chart or a form that lets you convert a given size.
All pages should display the logo and the company name "Athlete's Foot".
Suitable navigational links on all pages.
Note a "good" solution will deal with the issues of not all US or UK sizes mapping to a European size that is in the database.
Details of the database containing the information are given below.
The database is the same one used for the examples in weeks 9 and 10, dwt, but you will be using two tables:
shoes contains code, colour, name, sex, min_size, max_size, price and image_url columns.
code is an allocated id for each style of shoe with colour, it forms the primary key of the table.
name is a text field for the name style of the shoe.
sex is a single character indicating whether the shoes are mens (m), womens (w) or unisex (u).
min_size and max_size are the minimum and maximum sizes available in European sizes, you can assume no half sizes.
price is an integer
image_url is the location of an image of the shoe.
Note there may not be images for all shoes. For some styles there may be no image in the given colour but an image of the style in another colour may exist (This will have the same code but a different colour.).You can expect the contents of shoes to change.
sizes is a table of European (euro), UK (uk)and United States (us) shoe sizes, allowing conversion between the different scales.
Here are links to simple PHP programs that show the contents of sizes and shoes .
The user 'wwwuser' with password 'wwwuser' has the necessary permissions on the the 'dwt' db. Since this isn't an exercise in SQL you can ask 'Whats the SQL to do..' and I'll tell you, it is of course up to you to incorporate this correctly into your submission.