Web-based Pharmacy Product Management System using PHP and MySQL Database

This PHP Project is entitled Web-based Pharmacy Product Management System. This application is mainly developed to manage the medicinal drugs/product of a certain pharmacy. It contains multiple user-friendly functionalities including the sales and stock management.

How it Works?

This Web-based Pharmacy Product Management System is a straight-forward application that allows the user to manage the relevant data of the product of the pharmacy is selling. User are required to login first in order to access the features and functionalities of the system. The application contains multiple forms and list of Product Category, Suppliers, Products, stocks, and sales. The system main features are the Sales Management and Stock Management of the products. In sales, the stock or the remaining quantity of each product are automatically deducted each time the product are sold.

Features and Functionalities

Here are the following Features and Functionalities of this Pharmacy Product Management System:

• Dashboard Page
• User Management
   
  • Admin Record
  • Add User
  • Edit Profile
  • Edit Photo
• Category Management
   
  • List of Categories
  • New Category Form
  • Delete Category
• Supplier Management
   
  • List of Suppliers
  • New Supplier Form
  • Delete Supplier
• Product Management
   
  • List of Products
  • New Product Form
  • Delete Product
• Sales Management
   
  • List of Sale
  • New Sale Form
  • Delete Sale
• Stock Management
   
  • List of Stocks
  • New Stock Form
  • Delete Stock
• Change Password
• Backup Database

Screenshots

Here the following screenshots taken of some pages of the application:

Category Page

Supplier Page

Product Page

Stock Records Page

Sales Record

Sale Form Page

How to Run ??

Requirements

• Download and Install any local web server such as XAMPP/WAMP.
• Download the provided source code zip file. (download button is located below)

Installation/Setup

1. Open your XAMPP/WAMP's Control Panel and start Apache and MySQL.
2. Extract the downloaded source code zip file.
3. If you are using XAMPP, copy the extracted source code folder and paste it into the XAMPP's "htdocs" directory. And If you are using WAMP, paste it into the "www" directory.
4. Browse the PHPMyAdmin in a browser. i.e. http://localhost/phpmyadmin
5. Create a new database naming product_expiry_goodness.
6. Import the provided SQL file. The file is known as product_expiry_goodness.sql located inside the db folder.
7. Browse the Stock Management System in a browser. i.e. http://localhost/product_expiry/.

Default Admin Access Information

Email: [email protected]
Password: escobar2012

Feel Free to download the source code for free on this website. Download button is located below this article content.

There you have it! I hope this Web-based Pharmacy Product Management System using PHP and MySQL Database will help you with what you are looking for and you'll find something useful from the source code for your current and future web application projects.

Explore more on this website for more Free Source Code, Tutorials, and Articles covering various Programming Languages.

For your final year Research project, web and mobile development, custom software development , reach us Via whatsapp +2348067361023