Closed

Build a Shopping Cart

Please use your Shopping Cart Database for this project.

TASK 1 - PREPARATION (5 POINTS)

Application events are specific occurrences during the life cycle of an application. Each time one of these events occurs, ColdFusion runs the corresponding method in your [url removed, login to view] file (also referred to as the application CFC). The [url removed, login to view] file defines application settings and implements methods to handle the application events.

Create a new folder called ShoppingCart.

Read the material from the adobe website here - [url removed, login to view] and create a minimal [url removed, login to view] file for your project and save it inside the ShoppingCart folder.

At minimum you should turn on session proecssing and set your data source to the value you set up earlier.

TASK 2 - PRODUCT LISTING PAGE (10 POINTS)

Create a Product Listing page to show a list of all the products available for sale from your PRODUCTS table. Use a new CF file called [url removed, login to view]

Execute a query called “getlist” to get productID, productName, productQty, productPrice and productDescription from the PRODUCTS table.

<cfquery name = "getlist" datasource="#dsn#">

SELECT [url removed, login to view], [url removed, login to view],

[url removed, login to view], [url removed, login to view],

[url removed, login to view]

FROM Products;

</cfquery>

Display this information in a neatly formatted grid. For full points you should use bootstrap or some responsive framework.

You should add an image for each product into your grid and upload that to the server and show that on your page beside or above your product name. You should add the column ProductPhoto into the above query once you’ve added your field into the database table as well as your urls for each image.

For each product display an Add to cart button so that users can buy your products. For the add to cart button create a link to add the product to a shopping cart. Here is a sample buy link. Note that I have hard coded quantity 1 when it comes from the product list page. (you will do the same thing). Also note that productID, productname and productprice come from the query result set.

<a href = "[url removed, login to view]">Add to Cart</a>

If quantity available is 0, then don’t show the buy link. Instead display “out of stock!” without any link.

TASK 3 - SHOPPING CART PAGE (15 POINTS)

Here you will build the Shopping cart page. In this simple shopping cart we are going to enable only a single item to be ordered. If each additional item overwrites the first one, that is fine for this task. This is so that we can get through the shopping cart without adding any complexity to the code. The following are the steps that you need to follow:

Create a new cfm file called [url removed, login to view]

Create <cfparam> variables for the productID and qty url variables that come into the shopping cart from the buy link you created in the previous task. This is so that if you can avoid errors if these values are null.

Create a form with a submit button - “Proceed to Checkout”

Set the action of the form to submit to the customer Info page you created earlier.

Based on the url variable productID you can get the other product info from another query to the database so that you can populated it into your shopping cart. Note the url parameters that are sent to this page through the url (buy link).

Display in a neat grid/table the shopping cart.

Now do the following calculations and set the results at the bottom of your shopping cart on this page.

Itemtotal = price * qty

OrderTotal = itemTotal (for now we will do only one item in the shopping cart).

Tax = orderTotal *0 .007

TotalOrderAmount = orderTotal + tax

On clicking the Proceed to checkout button the application would need to take them to the assignment you did earlier (customer info page). Rename that assignment to customerInfo.cfm.

Skills: Graphic Design, HTML, PHP, Website Design

See more: turn website into application, time complexity of code, the design cycle, steps to take to do a website, steps to follow to design a website, steps to developing a website, steps on developing website, steps on developing a website, steps in developing a website, shopping cart for html website, product page bootstrap, price of adobe in design, out source your life, out source tax, implements set, graphic design without adobe, graphic design price list 2016, full sale graphic design, design website shopping cart, create shopping cart html

About the Employer:
( 1 review ) Pensacola, United States

Project ID: #9888710

3 freelancers are bidding on average $55 for this job

retheeshwork

Hi, We have more than 7 yrs of exp so we can make it, and expert in Php, mysql and Wordpress as well as website design and development platforms... Portfolio:: [login to view URL] / Our lat More

$33 USD in 2 days
(69 Reviews)
5.8
Srijan97

Hello. I'm a computer sciecne student and I am well versed with html, css, javascript, bootstrap, etc. I can do this job easily and in least amount possible. Thanks

$20 USD in 1 day
(0 Reviews)
0.0
jkarthick21

5 +experience in ColdFusion, Jquery, Oracle PL/SQl Experience in design and development. Well acquainted with Software Development Life Cycle. Strong knowledge in SQL queries. Knowledge in Jquery, Java script, More

$111 USD in 5 days
(0 Reviews)
0.0