php mySql database

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

Freelance

WAGE / SALARY

$100

HOURS PER WEEK

TBD

DATE UPDATED

Sep 14, 2016

JOB OVERVIEW

upload a spreadsheet to a mysql database (we will do this weekly) that will replace the old database

the columns are Shape, Weight, Color, Clarity, Cut, Price per Carat, Stone Price, and a link to Buy, the rest of the columns will be ignored.

Two columns (stone price and price per carat) will be multiplied by 1.33 or 1.5, selected in the cpanel for this function

when the website user selects multiple attributes (corresponding to column data values) by clicking check-boxes, and then clicks the submit button, a table of diamonds from the database will display matching user's criteria, which can then be sorted by any column. For example, they may check for the "size" 3.00-3.99 carats and check for "color" which can be a range such as D-F and so on.

before the check-boxes appear, they will click on the diamond shape such as "Princess" or "Round" so that their further choices (filters) only apply to that shape

each item will link to our 1shoppingcart.com account where they can purchase. when they successfully purchase, the item should be flagged for deletion.

we need a cpanel thing for manually adding, deleting, or editing and item (row in the database)

VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin