Project: Pharmacy Sales and Inventory System using PHP/MySQL
The Pharmacy Sales and Inventory System is a simple project that will help pharmacy businesses manage the medicine that they are selling and monitor their available stocks. This will also help to track the expired medicine product on hand which this system notifies them when the expiry date of their stock will come. And by this, they will check the remaining stock of the medicine product that is expired and encode to the system to deduct the count of stock that has already for inventory monitoring and sales product availability. This system categorizes the medicine list by the type of medicine for and also the type of medicine such as tablet and capsule, with this feature will help the cashier to search in details of the product that the customer is looking for, for example, the customer is looking for a 500 mg of Amoxicillin capsule medicine which is categorized in the group of medicine use for an antibiotic but the pharmacy does not have stock of this medicine at that time, the pharmacist will simply search a product in detail and enter the antibiotics word in the search bar so the medicine with available stocks in antibiotics will be filtered then the pharmacist can offer another product that has a similarity with what the customer is looking for.
The flow of the Pharmacy Sales and Inventory System is as follows:
Username: admin
Password: admin123
I hope the simple Pharmacy Sales and Inventory System using PHP/MySQL project will help you with what you are looking for. Feel free to download and modify the source code.
Explore more on this website for more Source Code and Tutorials.
Enjoy!
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.
Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.
FOR YOUR OWN SAFETY, PLEASE:
1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
Fatal error: Uncaught Error: Call to a member function fetch_array() on bool in C:\xampp\htdocs\pharmacy-sales-and-inventory-system-using-php\pharmacy\login.php:18 Stack trace: #0 {main} thrown in C:\xampp\htdocs\pharmacy-sales-and-inventory-system-using-php\pharmacy\login.php on line 18
Hi guys. Sorry for the mistake. I have updated the source code. The SQL file is now included in the database folder. Thanks
Hi, the login credential is provided in the article which is admin as the username and admin123 as the password.
Hi, I did check the system using the latest xampp and I did find the error in logging in. Sorry for the inconvenience. It was because of the strict mode of the latest PHP version. To fix it, kindly open the admin_class.php in your text editor and go-to line 39, and replace the code with the code below.
$ip = isset($_SERVER['HTTP_CLIENT_IP']) ? $_SERVER['HTTP_CLIENT_IP'] : (isset($_SERVER['HTTP_X_FORWARDED_FOR']) ? $_SERVER['HTTP_X_FORWARDED_FOR'] : $_SERVER['REMOTE_ADDR']);
Hi, newbie here.
Just want to ask, in the sales page
instead of reference number, is it possible to replace it with user details who did the transaction.
thankyou in advance.