A.H PMS Report
A.H PMS Report
A.H PMS Report
A
MINI PROJECT REPORT ON
“PHARMACY MANAGEMENT SYSTEM”
Submitted in partial fulfilment for the requirement of the 5th Semester
BACHELOR OF ENGINEERING
in
COMPUTER SCIENCE AND ENGINEERING
Submitted by
AKSHAY D (1AH19CS004)
2021-2022
ACS COLLEGE OF ENGINEERING
#74, Kambipura, Mysore Road, Bengaluru-560074
Department of Computer Science and Engineering
CERTIFICATE
1.
2.
ACKNOWLEDGMENT
I take this opportunity to express my sincere gratitude and respect to the ACS College of
Engineering, Bengaluru for providing me an opportunity to carry out my mini project
report.
I express my sincere regards and thanks to Dr. V Mareeswari, Associate Professor &
HOD, Computer Science and Engineering, ACSCE, Bengaluru for the encouragement
and support throughout encouragement the work.
With the profound sense of gratitude, I acknowledge the guidance support and
encouragement to my guide Mrs. Poornima R M, Assistant professor of Computer
Science and Engineering, ACSCE, Bengaluru.
AKSHAY D
(1AH19CS004)
HITESH RAO S
(1AH19CS040)
ABSTRACT
Nowadays, “PHARMACY MANAGEMNET SYSTEM” is one of the most essential took that are mostly
used in medical store: 1 is mostly used to manage pharmacy related activities such as medical inventory,
record keeping, sales management as well as managing the drug stock and information of the expired
medicines. Many pharmacies are still operating manually; they don't have adequate software to manage their
daily activities. It needs the pharmacist assistant to check the expired date of the medicine twice a week, and
it can take a lot of time to find out whether certain medicine are out of stock.
In this project we tried to develop a computerised and web based Pharmacy management system. Our main
intention is to allow this application to be used in most retailing pharmacies, where a small point of
customization will be required to each pharmacy in the implementation period. This system is designed to
overcome all challenges related to the management of medicine that were used to be handled locally and
manually.
Pharmacy management system has its own significance to the retail pharmacy shops. Using this system
it will help to recognise all customers, employees, balance stock, etc. It will manage all activities around
the shop that increases productivity and maximize profit, i will also minimize the risk to check expiry
date of each product and also saves time.
CONTENTS
ACKNOWLEDGMENT I
ABSTRACT II
INTRODUCTION PAGE1
ABOUT PAGE 1
NON-FUNTIONAL REQUIREMENTS
ER DIAGRAM
2 ER MAPPING
NORMALIZATION
BASIC MODULES
ADMIN MODULE
PHARMACIST MODULE
MEDICINE MODULE
4 USER MODULE
FEEDBACK MODULE
6 SNAPSHOTS
7 APPLICATIONS
8 CONCLUSION
9 REFERENCES
Pharmacy Management System
Chapter 1
INTRODUCTION
PHARMACY MANAGEMENT SYSTEM:
The main aim of the project is the management of the database of the pharmaceutical shop. This
project is insight into the design and implementation of a “PHARMACY MANAGEMENT
SYSTEM”. This is done by creating a database of the available medicines in the shop. The
primary aim of pharmacy management system is to improve accuracy and enhance safety and
efficiency in the pharmaceutical store. The aim of this project is to develop software for the
effective management of a pharmaceutical store. We have developed this software for ensuring
effective policing by providing statistics of the drugs in stock. The database is then connected to
the main program by using interconnection of the Visual Basic program and the database
already created. Pharmacy management system is useful to maintain correct database by
providing an option to update the drugs in stock. This is pharmacy management system; it is
used to manage most pharmacy related activities in the pharmacy.
Page 1
Dept. of CSE, ACSCE 2021 -22
Pharmacy Management System
pharmacy. Pharmacy management system deals with the maintenance of drugs and consumables
in the pharmacy unit. This pharmacy management system is user friendly.
This project will involve design and implementation of a computerized stock control system.
This is a system that will allow an easy and effective way to control and maintain business
processes. For instance stock levels which were initially manual will be automated. Maximum
stock levels will be computerized hence investment of inventory will be kept at minimum so that
the funds are made available for more productive uses thereby avoiding borrowing and
consequent loss on interest. Losses will be minimized on account of obsolescence due to
overstocking. When danger levels are reached, the system will then automatically place an order
to the supplier informing him/her to supply the required product and in the required quantity
(Predetermined reorder quantity).Minimum stock levels will be maintained automatically
making sure that items are available in the store where and when needed. The system is intended
to run on a networked environment so information will be shared efficiently hence reducing on
the time wasted by moving from one place to another hence a database will be used to capture
the information. This will increase the privacy of the customer’s information since the database
will be accessed by authorized personnel only.
PROBLEM STATEMENT:
Every organization today is committing thousands of dollars in making sure it matches with the
trends of global growth in the world of technology. This has made exchange of goods and
services easier considering that transactions are computerized or networked to be done over the
now famous Internet. It is in this wake of reality that many efforts are made to ensure efficient,
reliable and cost effective means of controlling the flow of stock in an organization. Business
processes are done manually which is prone to error. For instance maintaining stock levels is not
an easy task as a lot of time is wasted when stock taking is in process. I.e. the store has to be
closed for at least three days to allow the process to be carried out. Purchase process is done
manually which wastes a lot of time and money since the procurement personnel has to travel to
the supplier so as to place an order. Keeping customer’s information is also a challenge to many
businesses minus the database to restrict the number of people who should have access to the
information. This calls for a control system that will foresee perfect control of business
transactions and ensure stock flow stability.
Case Study
The success of any organization hinges on its ability to acquire accurate and timely data
about its operations, to manage this data effectively, and to use it to analyse and guide its
activities. It deals with the automating tasks of maintaining of Bills. In Pharmacy, Billing
management is the key process. In addition, Pharmacy management system will be able to
process drug prescription with ease. Including safe data store about medicine as well as fast
searching, delete and update of medicines. The pharmacy management system is built for the
sake of ensuring effective and clear data saving and manipulating as well as neat work on the
pharmacy medical products. The pharmacy management system is easy for use so the user
can do pharmacy actions without ambiguities. This refers the pharmacy management system
project highly minimize time and resource by which, searching the medicine data you can get
the data in quickest time. The main Objectives of the PMS is making the pharmacy
organizations computerized by creating neat work through minimizing or eliminating wasting
of time as well as removing the resources such as papers for data saving since know a days is
paper based, decrease malfunctioned works on the medical usage by giving correct
information on each medicine
This easy-to-use, integrated database application is geared towards reducing time spent
on administrative tasks. The system is intended to accept process and generate report
accurately and any authorized user can access the system at any point in time provided
software is available. The system is also intended to provide better services , provide
meaningful, consistent, and timely data and information and finally promotes efficiency by
converting paper processes to electronic form. The system was developed using technologies
such as, PHP,HTML,CSS and MySQL. PHP,HTML,CSS is used to build the user interface
and database was built using MySQL. The system is free of errors and very efficient and less
time consuming due to the care taken to develop it. All the phases of software development
cycle are employed, and it is worthwhile to state that the system is very robust. Provision is
made for future development in the system.
Proposed System
The design of the pharmacy management system is based on the computer which will
simplify the maintenance of the information, accessible and efficient. The “PHARMACY
MANAGEMENT SYSTEM” will provide the information about the end of the drugs in the
medical so that the physician can order them drugs before the end. The admin and pharmacist
will get more accurate results at the time sell, about the details of the use of medicines and the
dosages so that the system will become more reliable to use than the present system. The records
of each work will be secure as to access the information the user must have to provide the ID
and password in the system.
CHAPTER
2
LITERATIRE SURVEY
2.1 a) “A hospital resource and patient management system based on real-time data
capture and intelligent decision making” Author(s): Musa, A. Lancashire Bus. Sch.,
Univ. of Central Lancashire, Preston, UK Yusuf, Y, Meckel.M. Systems and Informatics
(ICSAI), 2012 International Conference
One of the major challenges existing hospital management systems face is around
operational efficiency and wait times between different processes, departments and
persons. This paper highlights such limitations of existing systems and proposes a
RFID(Radio Frequency ID) and wireless sensor based , location and information
management framework that facilitates real time tracking of hospital assets, personnel
and patients as they move through pre-set procedures as part of daily activities of the
hospitals. The system covers the visual simulation and providing ability to analyse the
ongoing operations so they can be corrected to achieve increased process efficiency and
service levels.
This paper reviews the HIS (Hospital Information Systems) which are widely used in
many hospitals in China mainly to provide easier and faster way for daily medical tasks
/activities with a GUI And provides for overcoming some of the limitations of HIS , eg.
HIS aims at improving quality of health care services but do not have way of evaluating
/measuring those. So this paper proposes HSMS (Hospital Services Management
System) which aims at improving quality of services, identifying cost reduction areas ,
analyses and evaluate /rate heath care services . The ability to evaluate the services
facilitates hospital achieve higher Customer satisfaction scores and get a competitive
edge against those hospitals which score less or use HIS and do not have ways of
promoting the quality of their services.
LIMITATIONS
Time consumption in data entry as the records are to be manually maintained faculties
a lot of time.
Lot of paperwork is involved as the records are maintained in the files and registers.
Reliable on use of papers for storing valuable data information is not at all reliable.
Storage Requires as files and registers are used, so the storage space requirement is
increased.
Data is difficult as the data is stored using papers in files and registers manually.
CHAPTER 3
FUNTIONAL REQUIREMENTS
Log in:
Admin activity:
• Here we need provide complete authority to access all the information about the
pharmacist, user, feedback, and medicines. Also allow to update the profile of
pharmacist and user.
Pharmacist activity:
• Here we need to provide the pharmacist to view the user and medicine details.
User activity:
• Here we need to provide the user to view the medicine available , to order the
medicine of the user according to their requirement and also based on the availability
of the stocks.
• It also provides the facility to view the feedback list and also to contact them at the
time of emergency via email or calling them directly using the stored details.
NON-FUNTIONAL REQUIREMENTS
The following are the system requirements for hospital management system
HARDWARE SPECIFICATION
SOFTWARE SPECIFICATION
Frontend- PHP,HTML,CSS
Backend-MySQL
Page 8
CHAPTER 4
SYSTEM DESIGN
4.1 ENTITY RELATIONSHIP MODEL
med-
Med_
sold
User- med_nam
id
Amount Quantit
Page 9
Page 10
MEDICINE
Med_id Ph_id Med_name Quantity Expiry_date Amount
PHARMACIST
Ph_id Ph_name Ph_password Ph_address Ph_phone Ph_email Admin_id
USER
User_id User_name User_password User_phone User_email
FEEDBACK
Rating Review User_id
MEDICINE_SOLD
Med_id Med_name Quantity Amount User_id
2.1 NORMALIZATION:
ADMIN
FUNCTIONAL DEPENDENCIES
Candidate key- Admin-id
Admin_id -> (Admin_id, Admin_name, Admin_password, Admin_email, Admin_phone)
Admin_email -> (Admin_name, Admin_password, Admin_id)
JUSTIFICATION
The relation is in 1NF as all the attributes are atomic.
The relation is also present in 2NF as all the non-prime attributes are fully functionally
dependent on the prime attribute Admin_id and there is no partial dependency.
The relation is also present in 3NF as there are no transitive dependency.
FEEDBACK
FUNCTIONAL DEPENDENCIES
Candidate key- User_id
User_id -> (User_id, ,Ratings, Review)
JUSTIFICATION
The relation is in 1NF as all attributes are atomic.
The relation is in 2NF as all non-prime attributes are fully functionally dependent on
prime attribute.
The relation is in 3NF as there are no transitive dependency between prime attribute
User_id and other non-prime attributes.
\
MEDICINE_SOLD
FUNCTIONAL DEPENDENCIES
med_id -> Med_name, Med_id, Quantity
,Amount,User_id
Med_id->
Med_name.
JUSTIFICATION
The relation is in 1NF as all attributes are atomic.
The relation is in 2NF as all non-prime attributes are fully functionally dependent on
prime attribute Med_id.
The relation is in 3NF as there are no transitive dependency.
MEDICINE
FUNCTIONAL DEPENDENCIES:
Med_id->(Med_id,Med_name,Quantity,Expr_date,amount)
JUSTIFICATION:
The relation is in 1NF as all attributes are atomic.
The relation is in 2NF as all non-prime attributes are fully functionally dependent on
prime attribute Med_Id.
The relation is in 3NF as there are no transitive dependency between prime attribute Id
and other non-prime attributes
PHARMACIST
FUNCTIONAL DEPENDENCIES:
Candidate key- category_id
Ph_id -> (Ph_id, Ph_name, Ph_password, Ph_address, Ph_phone, Ph_email, Admin_id)
JUSTIFICATION :
The relation is in 1NF as all attributes are atomic.
The relation is in 2NF as all non-prime attributes are fully functionally dependent on
prime attribute.
The relation is in 3NF as there are no transitive dependency between prime attribute
Ph_id and other non-prime attributes.
USER
FUNCTIONAL DEPENDENCIES:
Candidate Key -> (User_id)
User_id -> (User_id, User_name, User_password, User_phone, User_email)
JUSTIFICATION :
The table is 1NF as all the attributes are atomic in nature.
The relation is in 2NF as there is no partially dependency on non-prime attributes.
The table is in 3NF as there is no transitive dependency between prime attributes
User_id and other non prime attribute
CHAPTE
R5
FRONT END DESIGN
<html>
<head>
<style>
#title{
}
ul {
}
li {
background-color:#00b300; font-size:33px;
color:white; margin-left:20px; margin-top:20px;
margin-bottom:20px;
float: right;
#titlehead{
float: left;
}
li a {
li a:hover:not(.active) {
background-color: #4dff4d;
}
.active {
background-color: #4dff4d;
}
*{
box-sizing: border-box;
}
input[type=text], select,
textarea,input[type=password],input[type=email],input[type=number],input[type=date]
{ margin-right:400px;
text-align:center; width: 40%; padding: 12px;
border: 1px solid #ccc; border-radius: 4px; resize: vertical;
}
label {
font-size:18px; margin-left:450px;
input[type=submit] {
background-color: #00b300; color: white;
padding: 12px 20px; border: none;
border-radius: 4px; cursor: pointer; float: right;
}
input[type=submit]:hover { background-color: #4dff4d;
}
.container {
margin-top: 0;
}
}
</style>
</head>
<body>
<ul>
</ul>
<div class="col-25">
<label for="lname">Password</label>
</div>
<div class="col-75">
Password...">
</div>
</div>
<div class="row">
<input type="submit" style="margin-right:600px; margin-top:10px;" value="Submit">
</div>
</form>
<h4 style="text-align:center;margin-left:1%;margin-top:5pt;"> Not a member / <a
href='user_signup.php'>signup</a></h4>
</div>
</body>
</html>
}
ul {
}
li {
}
}
li a {
}
.active {
}
*{
li a:hover:not(.active){
font-size:18px; margin-left:450px;
padding: 12px 12px 12px 0; display: inline-block;
}
input[type=submit] { background-color: #00b300; color: white;
padding: 12px 20px; border: none;
border-radius: 4px; cursor: pointer; float: right;
}
input[type=submit]:hover { background-color: #4dff4d;
}
.container {
}
.col-25 {
.col-75 {
float: left;
<li><a href="home.php">Home</a></li>
</ul>
<h2 style="font-style:italic; font-size:30px;padding-left:30px;">User Signup</h2>
<div style="text-align:center;"> <img src="image\user.png"> </div>
<div class="container">
<form action="user_signup_action.php" method = "get">
<div class="row">
<div class="col-25">
<label for="lname">User Id</label>
</div>
<div class="col-75">
<input type="text" pattern=".{1,}" required name="userid" placeholder="Enter user Id...">
</div>
</div>
<div class="row">
<div class="col-25">
<label for="lname">Name</label>
</div>
<div class="col-75">
<input type="text" pattern=".{1,}" required name="name" placeholder=" Name...">
</div>
</div>
<div class="row">
<div class="col-25">
<label for="lname">Password</label>
</div>
<div class="col-75">
</div>
</div>
<div class="row">
<div class="col-25">
<label for="lname">Phone Number</label>
</div>
<div class="col-75">
<input type="text" pattern=".{1,}" required name="number" 0
}
li a:hover:not(.active) {
}
.active {
background-color: #4dff4d;
background-color: #4dff4d;
}
#img_title{
}
#posts{
}
#card{
#home_img{ padding-left:50px;
padding-bottom:10px;
}
#done{
}
table {
margin-left:10%; margin-top:0%;
background-color:white;
}
th,td {
font-size:18pt; padding:10pt; text-align:center;
}
</style>
</head>
<body>
<ul>
<li id="titlehead"><p id="title">Pharmacy</p></li>
<li style=margin-right:10px;><a href="pharmacist_logout.php">Logout</a></li>
<li><a class="active" href="pharmacist_home.php">Pharmacist</a></li>
</ul>
</body>
</html>
Similar template has been used for feedback, log, user and pharmacist.
#title{
ul {
li {
}
text-decoration: none;
}
li a:hover:not(.active) { background-color: #4dff4d;
}
.active {
background-color: #4dff4d;
}
*{
box-sizing: border-box;
}
input[type=text], select,
textarea,input[type=password],input[type=email],input[type=number],input[type=date] {
margin-right:400px; text-align:center; width: 40%; padding: 12px;
/* Responsive layout - when the screen is less than 600px wide, make the two columns stack on
<div class="col-25">
<label for="lname">Medicine Name</label>
</div>
<div class="col-75">
<input type="text" pattern=".{1,}" required name="name" placeholder="Enter Medicine
Name...">
</div>
</div>
<div class="row">
<div class="col-25">
<label for="lname">Quantity</label>
</div>
<div class="col-75">
Quantity...">
value="BUY">
</form>
</div>
</body>
</html>
</div>
</div>
<div class="row">
<input type="submit" style="margin-right:600px; margin-top:10px;"
</div>
Connectivity:
<?php
$servername = "localhost";
$username = "root";
$password = "";
// Create connection
$conn = new mysqli($servername, $username, $password);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Create database
$sql = "CREATE DATABASE IF NOT EXISTS pharmacydb"; if ($conn->query($sql) ===
TRUE) {
//echo "Database created successfully";
$conn->close();
}
?>
CHAPTER-4
BASIC MODULES
MODULES
The main modules in this project are Admin module, Pharmacist module, Medicine module,
User module, Feedback module and Logs module.
ADMIN MODULE:
The main purpose for developing this admin module is to manage the overall activity
of the pharmacist and medicine stock. He can login and can add other admins for managing the
pharmacy. He also adds the pharmacist to update the medicine stock. Admin has been given
privilege to view the stock and Feedback given by the User. He can view the log i.e.; admin
monitor the activity of the medicine being added or sold.
PHARMACIST MODULE:
This module is designed so that the pharmacist could manage the medicine. Pharmacist can
add the medicine when the stock is over. He can view the User and the total Stock that are
available in the pharmacy.
MEDICINE MODULE:
This module is used by the user to buy the medicine available in the stock. Medicine could
be added to the stock by the pharmacist.
USER MODULE:
The User module has been given privilege to log into his account. If the user wishes to buy
medicine, then he can view the medicine and can buy them by paying the appropriate amount
for the medicine. User can give feedback based on the service provided.
FEEDBACK MODULE:
This module is used for receiving the feedbacks from the User. Only Admin can view the
feedback given by the User.
MEDICINE_SOLD MODULE:
This module is developed to track down the activity in the medicine database. Any
deduction in the medicine by the pharmacist will be added into the medicine_sold table. Admin
can view the medicine_sold table, and can check the activity in the medicine database.
CHAPTER-5
IMPLEMENTATION USING MYSQL AND PHP
Table creation
Admin Table:
Pharmacist Table:
Medicine Table:
User Table:
Feedback TABLE:
Medicine_sold TABLE:
Admin Table
Pharmacist Table
Medicine Table
User Table
Feedback Table
INSERT INTO `feedback` (`user_id`, `Rating`, `review`) VALUES (56, 10, 'Awesome!');
Medicine_sold Table
Trigger:
A trigger is a special type of stored procedure that automatically runs when an event occurs in
the database server. When data modification event is made against a table, it automatically
affects the other triggered table.
BEFORE triggers run the trigger action before the triggering statement is run. AFTER triggers
run the trigger action after the triggering statement is run.
DELIMITER //
CREATE TRIGGER `medlog` AFTER UPDATE ON `medicine_database`
FOR EACH ROW INSERT INTO logs values(null, NEW.medicine_name, NEW.med_id,
NOW(), 'Updated', NEW.quanity)
// DELIMITER ;
DELIMITER //
CREATE TRIGGER `medlog1` AFTER INSERT ON `medicine_database`
FOR EACH ROW INSERT INTO LOGS values(null, NEW.medicine_name, NEW.med_id,
NOW(), 'Inserted', NEW.quanity)
// DELIMITER ;
Stored Procedure:
A stored procedure in SQL is a type of pre-written code that can be stored for later execution
and then used many times hence, saving time. It is a group of SQL statements that performs the
task. The stored procedure can be invoked explicitly whenever required.
DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `get medicine_database`() NO SQL
SELECT * from medicine_database$$ DELIMITER ;
PHP Connectivity
PHP code for user signup
<?php
session_start(); include("connection.php");include("functions.php");
$sql = "CREATE TABLE IF NOT EXISTS user_database ( user_id VARCHAR(50)
PRIMARY KEY,
user_name VARCHAR(50), user_password VARCHAR(50), user_phone VARCHAR(50),
user_email VARCHAR(50)
)";
if ($conn->query($sql) === TRUE) {
//echo "Table created successfully";
} else {
echo "Error creating table: " . $conn->error;
}
$userid = filter_input(INPUT_GET,'userid');
$username = filter_input(INPUT_GET,'name');
$userpass = filter_input(INPUT_GET,'pass');
$usernumber = filter_input(INPUT_GET,'number');
$useremail = filter_input(INPUT_GET,'email');
$sql = "SELECT * FROM user_database WHERE user_id = '$userid'";
$result = $conn->query($sql); if(mysqli_num_rows($result)>0){
echo "<div id='card'><p>User ID Already Exists</p><form action='user_signup.php'
method='get'><button type='submit' id='done'>Try Again</button></form></div>";
}else{
$sql = "INSERT INTO user_database (user_id, user_name, user_password, user_phone,
user_email)
VALUES ('$userid', '$username', '$userpass','$usernumber','$useremail')";
if ($conn->query($sql) === TRUE) {
//echo "New record created successfully";
$_SESSION["userid"] = $userid;
echo "<div id='card'><p>New user Successfully Added</p><form action='user_home.php'
method='get'><button type='submit' id='done'>Done</button></form></div>";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
}
$conn->close();
?>
<?php session_start();
require('connection.php');
$userid = filter_input(INPUT_GET,'userid');
$pass = filter_input(INPUT_GET,'pass');
$sql = "SELECT * FROM user_database
WHERE user_id='$userid' AND user_password='$pass'";
$result = $conn->query($sql); if ($result->num_rows > 0) {
$_SESSION["userid"] = $userid; header("Location: user_home.php");
}
else {
echo "<div id='card'><p>Invalid Id or Password!!!</p><p>Try again with valid Id
and Password</p><form action='user_login.php' method='get'><button type='submit'
id='done'>Done</button></form></div>";
}
?>
The similar php code have been implemented for admin and pharamacict code.
else {
$conn->close();
?>
The similar php code has been implemented for adding new admin and pharmacist.
<?php
session_start(); include("connection.php");
$name = filter_input(INPUT_GET,'name');
$qty = filter_input(INPUT_GET,'qty');
$sql1="SELECT quanity FROM medicine_database WHERE medicine_name='$name'";
$sql="SELECT amount FROM medicine_database WHERE medicine_name='$name'";
$ret=mysqli_query($conn, $sql);
$ret1=mysqli_query($conn, $sql1); if($qty <= 0){
echo "<div id='card'><h1>Incorrect quantity. .. </h1><form action='user_home.php'><button
type='submit' id='done'>Done</button></form></div>";
}
while($row=mysqli_fetch_assoc($ret1))
{
$quan=$row['quanity']; if($quan <=0){
echo "<div id='card'><h1>Out of stock... </h1><form action='user_home.php'><button
type='submit' id='done'>Done</button></form></div>";
}
}
if(mysqli_num_rows($ret)>0)
{
while($row=mysqli_fetch_assoc($ret))
{
$amount=$row['amount'];
}
$_SESSION['mediname'] = $name;
$_SESSION['quantity'] = $qty;
$amt=$amount*$qty;
session_start(); include("connection.php");
$pharmacistid = filter_input(INPUT_GET,'pharmacistid');
$sql = "DELETE FROM pharmacist_database WHERE pharmacist_id='$pharmacistid'";
if ($conn->query($sql) === TRUE) {
echo "<div id='card'><p>Pharmacist deleted successfully</p><form action='admin_home.php'
method='get'><button type='submit' id='done'>ok</button></form></div>";
}
else {
echo "Error deleting record: “. $conn->error;
}
?>
The similar php code has been implemented for deleting admin.
<?php session_start();
include("connection.php");
$name = filter_input(INPUT_GET,'search');
$sql="SELECT * FROM medicine_database WHERE medicine_name='$name'";
$ret=mysqli_query($conn,$sql); if(mysqli_num_rows($ret)>0)
{
echo"<div id='dem'>";
echo"<table border='1'><tr><th>Medicine Name</th><th>Quantity</th><th>Expiry
Date</th><th>Amount/qty</th></tr>";
while($row=mysqli_fetch_assoc($ret))
{
echo"<tr><td>{$row['medicine_name']}</td><td>{$row['quanity']}</
td><td>{$row['expiry_date']}</td><td>{$row['amo unt']}</td></tr>";
}
echo"</table>";
echo"<form action='user_home.php'><button type='submit' id='done' style='margin-
left:10%;margin- top:20px'>Go Back</button></form>";
}
if(mysqli_num_rows($ret)==0)
{
echo "<div id='card'><h3>We dont have any such medicine, Come back later when the stock is
updated... </h3><form action='user_home.php'><button type='submit'
id='done'>Done</button></form></div>";
}
?>
<?php
$_SESSION["userid"] = ""; header("Location: home.php");
The similar php code has been used fr logging out from admin and pharmacist’s dashboard.
The similar PHP code is used for viewing the log, medicine, admin and pharmacist.
CHAPTER 6
SNAPSHOTS
HOME PAGE:
USERLOGIN:
IN SAME MANNER THE PHARMACIST LOGIN AND ADMIN LOGIN HAVE BEEN
DEPICTED.
DASHBOARD
1) Admin dashboard:
2)Pharmacist dashboard:
3)User dashboard:
BUY MEDICINE
Dept. of CSE, ACSCE 2021 -22 Page 47
Pharmacy Management System
VIEW
1)VIEW MEDICINE: THIS IS USED TO VIEW THE MEDICINES AVAILABLE IN THE
STOCK
2)VIEW LOG: THIS IS USED TO VIEW THE MEDICINES PURCHASED FROM THE
STOCK.
THIS IS TO VIEW THE MEDICINE THAT HAS BEEN ADDED TO THE STOCK
SUCCESSFULLY.
APPLICATIONS
The pharmacy management system can be efficiently used by any medical store to
automate the process of data management and maintenance of records related to stock,
liquid flows, staffs, customers, and suppliers.
New features, modules, and other components can be incorporated into the system as per
user requirements in future.
A pharmacy management system helps you to manage your pharmacy's resources easily
and in an efficient manner.
It helps you to easily keep track of medicine and equipment stock. You can easily check if
any of the out-of-stock items are available in any of your other stores.
This program can be used in any pharmaceutical shops having a database to maintain.
The software used can generate reports, as per the user’s requirements.
The software can print invoices, bills, receipts etc.
It can also maintain the record of supplies sent in by the Pharmacist.
Page 52
Dept. of CSE, ACSCE 2021 -22
Pharmacy Management System
CONCLUSION
The aim of this project is to develop software for the effective management of a
pharmaceutical store. We have developed this software for ensuring effective policing by
providing statistics of the drugs in stock. Pharmacy management system is useful to maintain
correct database by providing an option to update the drugs in stock. This is pharmacy
management system; it is used to manage most pharmacy related activities in the pharmacy.
User can buy any medicine by sitting at home. Also, this software is User friendly that any
person with the basic knowledge can access the software and can buy the medicine that he is
required.
Effective implementation of this software will take care of the basic requirements of
the pharmacy management system because i t is capable of providing easy and
effective storage of
information related to activities happening in the stipulated area. With these, the objectives
of the system design will be achieved.
Pharmacy management system was developed to ensure the security of information and
reliability of Pharmacy records when accessing and providing services to the
customers. The information gathered during the data collection was properly analysed and
the results provided the basis for the new system. The system was tested and found to
be functional and the outputs produced by this system were encouraging. The application
will hence reduce the loss of information unlike the existing system and also information
will be processed fast
REFERENCES
For PHP
https://www.w3schools.com/php/default.asp
https://www.sitepoint.com/php/
https://www.php.net/