This Pharmacy Management System in PHP MySQL with Source Code allows the administrative user the following options:
- Add, List, Edit and Delete Suppliers
- Add, List, Edit and Delete Categories
- Add, List, Edit and Delete Medicines
- Add, List, Edit, Delete and Print Invoices
- List the Report of Sales, Products and Expired Products by Time Periods
Explanatory Video of the Pharmacy Management System (Spanish)
Access to the Pharmacy Management System in PHP MySQL with Source Code
The administrative access user is firstname.lastname@example.org and the password is 1234abcd..
Contact me if you have questions
You can contact me on my Whatsapp at the following link:
Commissioning of the Pharmacy Management System in PHP MySQL on a local server
The process is a recurring theme in my publications, the following applications must be downloaded and installed with all the default parameters:
Pharmacy Management System Download
The application is related in the following link:
To download the application you must enter the following location from Visual Studio Code
Already in this folder, within Visual Studio Code, press the View option and then Terminal, and in the window that appears at the bottom, write the following code and press Enter:
git clone https://github.com/configuroweb/farmacia.git
Inside the htdocs folder a new folder will be created called farmacia and there will be the project already entered, what remains is, from Visual Studio Code, access this folder from the Open Folder option and access farmacia, this way you will have the application files to modify them at will.
Creation of the database
For the creation of the database, you need to have the Apache and MySQL services in XAMPP, if you open XAMPP for the first time you choose the language of your preference between German and English.
After activating the Apache and MySQL services, you can access the following URL to create the database and copy the SQL script.
From the Database Manager, you create the database with the name pharmacy, it is recommended that the collation be UTF SPANISH 2 CI, so that the database supports accents and characters specific to our language.
After creating the database, you must click on the SQL section, copy and paste the code found in the following link:
As soon as you complete this process, the application will be operational at the following link:
If you have additional questions about setting up PHP applications on a local server, you can access the following post
Commissioning of the Pharmacy Management System in PHP MySQL in a Hosting
I explain the process at a general level, in the video below:
Any questions remain pending.