hi i am working in a project it is about online ordering of food ..
I have problem in createing the cart.
I have these tables
Member-will have the username and password, member id.
Fooddetails- will have foodid,foodname,fooddescrtion,foodimage,price.
Cartdetails-cart id ,quantity ,price,total,member id,
Orderdetails-order id,total,member id.
cart details has the ordered food details and the total.
orderdetails just has the total and order id .
my problem is the admin should know what are the foods ordered by the users
and the cartdetails should be destroyed as soon the user makes the order ..
hiiiiii@
0
Junior Poster in Training
Recommended Answers
Jump to PostSo what do you want? Unless you provide your code and show what's not working, I don't know how we can help.
Jump to PostCart table should has food's ID in case the user order the food and delete from cart table where food's ID and user's ID found.
All 7 Replies
diafol
hiiiiii@
0
Junior Poster in Training
hiiiiii@
0
Junior Poster in Training
hiiiiii@
0
Junior Poster in Training
hiiiiii@
0
Junior Poster in Training
ko ko
97
Practically a Master Poster
hiiiiii@
0
Junior Poster in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.