In Progress

price compare

require approx 5 mysql dbs ; 5 php functions to go with the mysql dbs.

dbs - products, categories, products_to_categories, shops, products_to_shops

100 products ; 4 shops ; 15 categories ; 100 products to categories ; 400 shops to products (including a price column)

functions - to find 5 prices given 1 product

to find the cheapest of the above items

to find the dearest of the above items

to add the total of more than 1 item for the 5 shops. e.g. 20 items

to find the cheapest basket over all and to give the products of that basket and their shop

Edit

Attached Files:

compare [url removed, login to view] ([url removed, login to view] KB)

Job Type:

* Programming

* PHP

* MySQL

* E-Commerce

* osCommerce

--

on the website we need

1) a list of the products

2) when you click on a product, it shows the product and 4 rows (1 for each shop) with a 4 prices

it gives the total, the cheapest and the dearest product

3) if you click another product it gets listed below the last 4 products for each shop

it gives the total, the cheapest and the dearest product

4) it gives the cheapest products below this also...

let me know what you think.

--

the functions are get_products();

get_prices(product); need to have multiple products listed with multiple prices

total of each product from each shop

cheapest product highlighted in green

dearest product highlighted in red

also the cheapest basket. i.e. product a from shop m, product d from shop o and product e from shop q

the php script will have about 5 - 8 functions

the db will have 5 - 8 functions

the php page will cal the php functions which will manipulate the database

Skills: eCommerce, PHP, Shopping Carts

See more: will price, q find, php programming price, dbs programming, price compare multiple item, job price, shopping compare, price compare, compare website, find product script, php product compare script, oscommerce product price, total product price, edit mysql rows php, product item price list, commerce product price, commerce xls, script php item shop, add item shop, php compare products script, oscommerce edit product page, job list xls, php compare product, compare products php, compare products script php

About the Employer:
( 40 reviews ) dublin, Ireland

Project ID: #549922

Awarded to:

developer99

Lets start

$99 USD in 3 days
(13 Reviews)
4.7