Your Task

You job is to take the partial solutions and make them into a fully functioning online store website.

Most of the PHP code is done for you, the real challenge is making the website look professional and attractive to potential customers.

Please make sure you have read the PHP and Database lectures (lectures 5 and 7).

Making an online system like this can be overwhelming it is important to break the system down into smaller tasks. Here are the tasks you need to complete BEFORE starting the assignment.

Ensure you have completed Lab07 (at least up to Task 11)

Copy all the provided assignment code into the Lab07 directory.

View the provided files in a web browser and see how they function (if at all, some may have errors)

Open all the files in the lab07 directory in Notepad++ and read the code and comments provided.

Carefully read this document and any attached documentation on LMS. Here are the main tasks you need to do for this assignment.

Get a navigation bar working.

Get the website functional.

Make the website look professional.

Complete any additional requirements.

If you get stuck on task 2, put it aside and work on task 3 until you can get help.

Web assignments like this sound easy enough but please dont underestimate the time required to complete this

assignment. Start it as soon as possible.

Another thing to note about this assignment is how much code is reusable. Some files are very similar. For this assignment most of the marks will be on the style and layout of the website.

That is, how it looks and feels. And of course, the quality of the code.

I highly recommend looking at what other successful online shops look like such as Amazon and eBay. What things do they display on the page? What colours do they use? How big is the text?

When working with real clients they often do not know exactly want they want.

It's your job as a web developer to interpret their requirements and deliver a final product.

Please ensure your code is valid HTML5. Remember that just because 'it works' does not mean it is correct. Use the HTML5 validator to check your HTML code (see lab07).

Task 1 - The Navigation bar

The first thing you should do is get a basic navigation bar working so that you can at least browse the website.

The navigation bar is just like what we did in lab 05.

The navigation bar MUST contain links to the following pages:

Homepage.php (you may also name this file index.php if you like)

ProductList.php

ViewCart.php

CustomerList.php

OrderList.php

SignUp.php

Please note that all the files on this website use the shopstyle.css file. So, any styles you put in shopstyle.css will apply to all the pages.

It's OK of the page is ugly at this point we will style it later.

Once you have the navigation bar finished, copy its code to all the PHP pages

except: ProcessOrder, AddToCart, EmptyCart and AddNewCustomer because they will not be visible to the user. You navigation bar links should change colour when the user hovers the mouse over them.

Task 2 - Getting the website functional.

I have provided you most of the PHP code, you just need to fill in the blanks.

Dont forget to check over the Lecture notes they contain many handy examples.

I have provided you with a document called "Web_development_assessment_file_details", which explains what each PHP file will do, and what SQL statements are required in each file.

Some of the PHP files are already fully functioning.

You should look though the PHP files and complete any of the TODO statements.

Open all the PHP files in Notepad++ and press Ctrl + F and search for the word "TODO".

If you get stuck work on Task 3 until you can get help.

Task 3 - Making the site look professional.

If you havent already please visit https://css-tricks.com/snippets/css and http://learnlayout.com/ these website contain excellent examples of the things you can do with CSS and layouts.

What you should do is pick a file to focus on to start with (such as ProductList.php).

Then decide on a layout structure, where should the navigation bar go? Where should the heading go?

Some people like to draw a layout plan on paper of how they want the page to look before starting any code.

Look around at other people's websites and blogs for ideas.

As I said at the start of this course web design requires a large amount of self-directed learning. There are plenty of online resources on working with HTML and CSS.

Once you have decided how you want your page to be structured think about what kinds of divs you will need. Most website will have four major divs: container, header, navigation, and main.

HTML5 provides new semantic tags for these functions like

and

you can use these if you like. But

and tags like we did in the labs are also acceptable.

I find that it makes things easier if you assign a random background colour to all the divs using CSS. This makes it easier to see where the divs are.

Once you have the main site layout figured out you need to think about how the products should be displayed Do you want them listed one per line or a side by side layout? (Examples below)

The layout and style is up to you - after all, you are the web developer.

Once you have all the layout looking the way you want it's time to assign colours and fonts.

I would advise against using bright colours, except maybe on the prices. Having a bright yellow background is not very aesthetically pleasing.

Remember that you are building a website for a business, you need to keep the page looking as professional as possible.

You can apply CSS to any item in the page, including buttons and form fields.

Finally, once you are happy with the layout copy the relevant HTML code to the other PHP files.

Task 4 - Additional Requirement

On the search page (ProductList.php) provide the user a drop-down list that allows the user to change how the results are sorted (with PHP and HTML, you may need to add a confirmation button for the drop-down list).

Results should be sorted by popularity by default.

NOTE: you're not allowed to use variables in your SQL, you can however have multiple prepare() statements and select the appropriate one based on a URL parameter using if() and elseif() statements.

Task 5.

Add an extra PHP page that shows the business owners a table (without any pictures) of all the products and shows:

ProductID (which also functions as hyperlink to ViewProduct.php)

Description.

Price.

Brand Name.

Popularity

Total Quantity (similar to popularity but also factors in the quantity ordered)

Total Revenue that this product has generated.

The products should then be sorted by the Total Revenue (Descending).

(Optional) Any other statistic you feel might be useful to the business.

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeffrey A. Hoffer Fred R. McFadden

4th Edition

0805360476, 978-0805360479

More Books