Đã Hủy

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

Kỹ năng: Thiết kế đồ họa, HTML, PHP, Thiết kế trang web

Xem thêm: 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

Về Bên Thuê:
( 18 nhận xét ) Madison Heights, United States

Mã Dự Án: #1076165

12 freelancer đang chào giá trung bình $363 cho công việc này

agilesols

lets do it.

$275 USD trong 7 ngày
(213 Đánh Giá)
7.5
ccpplinux

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

$250 USD trong 10 ngày
(121 Đánh Giá)
6.9
brandmantra

Please check the pmb

$250 USD trong 10 ngày
(14 Đánh Giá)
6.6
k1ng440

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

$800 USD trong 12 ngày
(97 Đánh Giá)
6.5
asthainc

Please check your PMB. Thanks

$250 USD trong 7 ngày
(6 Đánh Giá)
5.0
subratparida

Please see my PM

$200 USD trong 5 ngày
(9 Đánh Giá)
4.7
salam786

please check PMB

$750 USD trong 10 ngày
(6 Đánh Giá)
3.0
simipn

Ready to do

$200 USD trong 5 ngày
(0 Đánh Giá)
0.0
sshafiq

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

$400 USD trong 15 ngày
(0 Đánh Giá)
0.0
VenkatPramod

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.

$250 USD trong 20 ngày
(0 Đánh Giá)
0.0
hanumanwebtech

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

$350 USD trong 30 ngày
(0 Đánh Giá)
0.0
RogerFredrick

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

$380 USD trong 7 ngày
(0 Đánh Giá)
0.0