add to cart insert databse & checkout

carttable

id , userid , totalcartprice , isdeleted

cartdatatable

id cartid productid , quantity , offerid , price , unitcharge, isdeleted

if any user press add to cart button in appication that time you have to cal one web service with post method

{

productid:"4",

quantity:'2',

usrerid='1'

}

in your post api or webservice using product_id you have to check product details in that

1) available quantity in cart

if product is not available means you to stop the cart process and display the proper message to user

if(quantity=="available")

{

first check user already existed in cart or not

query to cart table with userid

if(user=="existed")

{

update data to cart table with proper total price

}

else

{

insert data to carttable id is primary key , userid , totalprice= productprice * quantity , isdeleted=0

}

ofter inserting carttable insert data to cartdatatable and map the carttable primary key

and rest of the information insert accoroding to your product details

if it helps please accept any doubt pls ask me

1 Reply

Know the answer? Post it — somebody with the same question will find it here.