Product view and order scripts - initial coding

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

Compétences : Conception graphique , HTML, PHP, Design de site internet

en voir plus : scripts products view, product view script, website creation order, website coding help, view my design, view cart design, the grand design, table data structure, simple scripts, sets in data structure, schema form, schema design, product table design, product list design, product design description, product database design, mysql city state database, lists data structure, list in data structure, list data structure, link list in data structure, index data structure, grand design, description of products product, data structure list

Concernant l'employeur :
( 18 commentaires ) Madison Heights, United States

Nº du projet : #1076165

12 freelance font une offre moyenne de $363 pour ce travail


lets do it.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(213 Commentaires)

Hi. Thanks for such clear cut description of the project. Please see PMB for more details. Best Regards ... ccpplinux

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(121 Commentaires)

Please check the pmb

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(14 Commentaires)

Professional Web Developer is Ready get started right now and will finish in no time. Please check your PMB

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(97 Commentaires)

Please check your PMB. Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(6 Commentaires)

Please see my PM

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(9 Commentaires)

please check PMB

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(6 Commentaires)

Ready to do

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)

I would like to do this job, make sure time mentioned is working day, no weak ends included.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(0 Commentaires)

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(0 Commentaires)

I am ready to develope it according to your project descriptions for more please check [url removed, login to view] you

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(0 Commentaires)

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: [url removed, login to view] Regards, Fredrick

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)