Please anser ASAP ya, THANK YOUUUU

question:

I have given my product and cart tables. The stock will decrease if user adds the product to the cart.

How to make sure that when the product is removed from the cart, the stock will be added back again into the product table?

SELECT * FROM 'product` Profiling [ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ] Show all Number of rows: 25 Filter rows: Search this table Sort by key: None Extra options SELECT * FROM "cart" Profiling [ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ] id product_name product_price product_image qty total_price product_code In Stock: 5 Quantity : Add to cart