Cart persistence across login/logout Solution: Merge session cart into database cart when user logs in.

CREATE TABLE categories ( id INT(11) AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50) NOT NULL, description TEXT );

// checkout.php <script src="https://checkout.razorpay.com/v1/checkout.js"></script> <form id="payment-form"> <script> var options = "key": "YOUR_KEY_ID", "amount": "<?php echo $total * 100; ?>", "name": "Online Pharmacy", "description": "Order #<?php echo $order_number; ?>", "handler": function (response) // Send payment_id to server for verification fetch('verify_payment.php', method: 'POST', body: JSON.stringify(payment_id: response.razorpay_payment_id, order_id: '<?php echo $order_number; ?>') );

-- Order items table CREATE TABLE order_items ( id INT PRIMARY KEY AUTO_INCREMENT, order_id INT, medicine_id INT, quantity INT, price DECIMAL(10,2), FOREIGN KEY (order_id) REFERENCES orders(id), FOREIGN KEY (medicine_id) REFERENCES medicines(id) );

?>

The front-end interface for patients.