header('Location: cart.php'); ?> <?php require_once 'includes/config.php'; if (!isset($_SESSION['user_id'])) header('Location: login.php'); exit();
// Generate unique order number $order_number = 'ORD-' . strtoupper(uniqid());
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
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);
-- 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) ); online-pharmacy/ │ ├── assets/ │ ├── css/ │ ├── js/ │ └── images/ │ ├── includes/ │ ├── config.php (database connection) │ ├── header.php │ ├── footer.php │ └── auth.php (session & role check) │ ├── admin/ │ ├── index.php (admin dashboard) │ ├── medicines.php (CRUD operations) │ ├── categories.php │ ├── orders.php │ └── users.php │ ├── user/ │ ├── profile.php │ ├── cart.php │ ├── checkout.php │ └── my-orders.php │ ├── public/ │ ├── index.php (home page) │ ├── shop.php (medicine listing) │ ├── product-details.php │ ├── login.php │ ├── register.php │ └── logout.php │ ├── uploads/ │ └── prescriptions/ │ └── sql/ └── database.sql 5. Key Implementation Examples Database Connection ( includes/config.php ) <?php $host = 'localhost'; $dbname = 'pharmacy_db'; $username = 'root'; $password = ''; try $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); session_start(); catch(PDOException $e) die("Connection failed: " . $e->getMessage()); header('Location: 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'];
Cart persistence across login/logout Solution: Merge session cart into database cart when user logs in. Conclusion This Online Pharmacy Management System covers core e-commerce functionality tailored for pharmaceutical needs. The complete source code can be built in 2-3 weeks by a mid-level PHP developer. For production, add HTTPS, implement proper logging, and comply with local pharmaceutical regulations (preservation of prescription records, data retention policies). implement proper logging
$sql = "INSERT INTO medicines (name, category_id, price, stock, requires_prescription, description, image) VALUES (?, ?, ?, ?, ?, ?, ?)"; $stmt = $pdo->prepare($sql); $stmt->execute([$name, $category_id, $price, $stock, $requires_prescription, $description, $image]);