Product view and order scripts - initial coding

  • Status Closed
  • Budget N/A
  • Total Bids 12

Project Description

Creation of a PHP/MySQL site structure - We would like support in creating the initial PHP pages and MySQL database based on these specs (which helps us get 80% of a way done) and then our team can finish off features and its look and feel.

Site to include the following data structure (open to other fields if helpful and simple)

Table: "Users"; Fields: userid, username, password (MD5 encrypted), dateSignedUp, city, state

Table: "Products": Fields: productID, productTitle, description, unitCost

Table: "Orders": Fields: orderID, userid, orderDate

Table: "OrderDetails": Fields: orderID, productID, Qty, unitCost

The PHP pages would be:

** [url removed, login to view] - just a page that provides a link to [url removed, login to view] and offers a username and password form for login that posts to [url removed, login to view]

** [url removed, login to view] - validates the username and password with Users table if being sent from the [url removed, login to view] page and sets a cookie showing the user is logged in... or validates the user is logged in from an existing cooking if this is not the first access of this page. This page provides a link to "Show Products" which is [url removed, login to view] and a link to "My Orders" which is [url removed, login to view]

** [url removed, login to view] - lists all products in rows from the products table. Have an input field for Qty and a computed column called "subtotal" which computes Qty times unitCost. There is a grand total on the last row. Javascript is used to compute all subtotals and grandtotals. A submit button at the bottom will post to a php script which adds 1 record into the Orders table and multiple records in the OrderDetails table. This does not need to be a shopping cart functionality. Just a big list of products in a large form and a single submit to create an order.

** [url removed, login to view] - lists all orders for that user and shows all fields in the Orders table. The orderID is a link to [url removed, login to view] and passes the orderID to that script

** [url removed, login to view] - receives the orderID via get or post and then displays the detail of the order on a page.

Again... these are rough scripts with no concern to formatting. Just looking to get a head start and help on creation of the scripts.

Actual deliverables would be all the .php files and a .sql file for the creation of the database schema

Get free quotes for a project like this

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online