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 schema
12 freelancers are bidding on average $363 for this job
The Initial Development will be made in a week time. Later modifications as per the buyer will be made . The project may also be completed withing 2 weeks of time.
Hello, I would like to take this job. I am very confident for do it. I am reliable, responsible and creative. You can check my work on this website: http://valvi.in/ Regards, Fredrick