/Medical-Store-Inventory-Management-System

This is my course project for CS315 - Introduction To Database Systems course at IIT Kanpur.

Primary LanguagePHPMIT LicenseMIT

Medical Store Inventory Management System

This is my course project for CS315 - Introduction To Database Systems course at IIT Kanpur.

Instructions To Setup The Project

  1. Rename sample-config.php to config.php and change the variable values inside it.

  2. Have a MySQL server ready and run the following queries as root:

    CREATE USER '$dbuser'@'$dbhost' IDENTIFIED BY '$dbpass';
CREATE DATABASE $db;
GRANT ALL ON $db.* TO '$dbuser'@'$dbhost';
USE $db;
CREATE TABLE CREATE TABLE $dbtable
(
    username    varchar(15),
    password    varchar(32),
    role        varchar(15)
);

    Replace the $ variables with the same ones you have used in config.php

  3. Add users in MySQL

    INSERT INTO $dbtable VALUES ('username','password','role');

    REPLACE username and password with those which you will give out to the people involved. The allowed values of 'role' are 'med_admin','receptionist','doctor'