Write a codeing on page step by step in real time and also screen shorts There is a databa...

write a codeing on page step by step in real time and also screen shorts

 

There is a database with name of “mart” in which four tables exists category, product, customer, cart, order.

            Category:

cat_id, cat_name

            Product:

pro_id, cat_id, pro_code, pro_title, pro_description, price

            Customer:  

cus_id , cus_name , contact , email

            Cart:

cus_id, pro_id, qty

            Order:

order_id , cus_id , pro_id, qty, amount

Create a web page through which you will retrieve data from cart table and display on web page Customer Name, Product Title, Quantity, Price, Amount and create a button in front of each record for delete from cart , when you click on delete from cart button record will be deleted from cart table also create a button on bottom of web page on clicking finalize order records should be inserted in order table make sure all record should be inserted in single clicking. For above question below web page structure is given.

 

CUSTOMER NAME : ____________________

Product Title

Quantity

Price

Amount

Action

Product 1

10

300

3000

DELETE

Product 2

5

400

200

DELETE

Product 3

5

100

500

DELETE

Total Amount: Rs 3700/-

 

Finalize Order

 

 

 

Note: Amount will be calculated on run time, it will not be retrieved from database.

Solved
Programming in PHP 1 Answer dipro saha

Login to view answer.