Product view and order scripts - initial coding
- Status Closed
- Budget N/A
- Total Bids 12
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 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 schemaGet 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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online