Online Pharmacy Management System Project In Php <Trusted>

if ($has_prescription_required && isset($ FILES['prescription'])) $target_dir = "uploads/prescriptions/"; $prescription_path = $target_dir . time() . " " . basename($_FILES['prescription']['name']); move_uploaded_file($_FILES['prescription']['tmp_name'], $prescription_path);

$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]);

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. online pharmacy management system project in php

$user_id = $_SESSION['user_id']; $prescription_path = null;

// Handle image upload $image = $_FILES['image']['name']; $target = "../uploads/" . basename($image); move_uploaded_file($_FILES['image']['tmp_name'], $target); else $_SESSION['cart'][$medicine_id] = $quantity

if (isset($_SESSION['cart'][$medicine_id])) $_SESSION['cart'][$medicine_id] += $quantity; else $_SESSION['cart'][$medicine_id] = $quantity;

header('Location: cart.php'); ?> <?php require_once 'includes/config.php'; if (!isset($_SESSION['user_id'])) header('Location: login.php'); exit(); ?php require_once 'includes/config.php'

-- Orders table CREATE TABLE orders ( id INT PRIMARY KEY AUTO_INCREMENT, user_id INT, order_number VARCHAR(50) UNIQUE, total_amount DECIMAL(10,2), payment_method ENUM('cod', 'card', 'online'), order_status ENUM('pending', 'confirmed', 'shipped', 'delivered', 'cancelled') DEFAULT 'pending', prescription_uploaded VARCHAR(255), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (user_id) REFERENCES users(id) );

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'] = [];

Maintaining stock accuracy Solution: Use database transactions; decrement stock only after order confirmation; prevent negative stock with CHECK (stock >= 0) .

$sql = "INSERT INTO users (name, email, password, phone) VALUES (?, ?, ?, ?)"; $stmt = $pdo->prepare($sql);