Pharmacy Management System in PHP + MySQL

ABSTARCT :

Pharmacy management system is one of the most essential tools that are mostly used in medical store in Tanzania; it 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 in Tanzania 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 in Tanzania, 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 in Tanzania. Using this system, it will help us to records all transaction made at the daily sales, recognise all debtors, customers, employees, balance stock, etc. It will manage all activities around the shop that increases productivity and maximize profit, it will also minimizing the risk of getting loss because all transactions are recorded to the system.

EXISTING SYSTEM :

? The person who has access to this part of the system can insert new medicine, update existed one and check the medicines quantities. ? We insert new medicine, update an existed one and check the medicines quantities. ? The database built using SQL Server contains the pharmacy information related to the medicines, patient information….etc. the GUI frames ease the use of the proposed system by unskilled users. ? A Pharmacology is the branch of biology deals with the properties of chemicals and interests with the study of use, action, side effect of drug.

DISADVANTAGE :

? It is the process of identifying problems, opportunities, and objectives. ? This phase required the analysts to look honestly at what is occurring in a business. Then, together with other organizational members, the analyst pinpoints problems. ? The analyst was able able to see whether some aspect of information systems applications can help the business reach its objectives by addressing specific problems or opportunities. ? The output of this phase is a feasibility report containing a problem definition and summarizing the objectives. ? It is a process of collecting factual data, understand the processes involved, identifying problems and recommending feasible suggestions for improving the system functioning.

PROPOSED SYSTEM :

• In this paper, a hospital e-pharmacy system is proposed in order to facilitate the job, outdo the mentioned problems. • The proposed system is equipped with alarm that alerts the admin about all medicines which are reached the minimum quantity and medicines that expired. • The proposed system managing as most as possible the whole job of hospital pharmacy. • The GUI frames are used for controlling the work of the proposed system, while the database is for saving the related information. • The proposed system was tested in terms of registration function by entering new records for inpatient and outpatient, release and update function.

ADVANTAGE :

? Improving performance and efficiency in pharmacy shops is a major goal of Pharmacy Management System. ? The overall objective of this project is to establish a System for pharmacy shops so as to improve the performance and efficiency of pharmacy shops management. ? If a major change to a system has been needed, a new project was being sated to carry out the change. ? Pharmacy management system is designed to improve the accuracy, enhance safety and efficiency in the pharmaceutical store. ? Pharmacy management System is a very effective tool for an organization to be efficient in business management.