// Check if any medicine requires prescription $has_prescription_required = false; // ... query to check cart items
$sql = "INSERT INTO users (name, email, password, phone) VALUES (?, ?, ?, ?)"; $stmt = $pdo->prepare($sql);
$sql = "INSERT INTO cart (user_id, medicine_id, quantity) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE quantity = quantity + ?"; $stmt = $pdo->prepare($sql); $stmt->execute([$user_id, $medicine_id, $quantity, $quantity]); online pharmacy management system project in php
else // Logged-in user: store in database $user_id = $_SESSION['user_id']; $medicine_id = $_POST['medicine_id']; $quantity = $_POST['quantity'];
-- Medicines table CREATE TABLE medicines ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(200) NOT NULL, category_id INT, price DECIMAL(10,2) NOT NULL, stock INT NOT NULL, requires_prescription TINYINT DEFAULT 0, description TEXT, image VARCHAR(255), expiry_date DATE, status TINYINT DEFAULT 1, FOREIGN KEY (category_id) REFERENCES categories(id) ); Project Overview An Online Pharmacy Management System allows
header('Location: medicines.php?msg=added'); ?> <?php session_start(); require_once 'includes/config.php'; if (!isset($_SESSION['user_id'])) // Guest cart stored in session if (!isset($_SESSION['cart'])) $_SESSION['cart'] = [];
?> <?php require_once '../includes/config.php'; require_once '../includes/auth.php'; // Ensure admin login if ($_SERVER['REQUEST_METHOD'] == 'POST') $name = $_POST['name']; $category_id = $_POST['category_id']; $price = $_POST['price']; $stock = $_POST['stock']; $requires_prescription = isset($_POST['requires_prescription']) ? 1 : 0; $description = $_POST['description']; and manage prescriptions
1. Project Overview An Online Pharmacy Management System allows customers to browse medicines, place orders, and manage prescriptions, while administrators handle inventory, orders, and users.