Inventory and Monitoring System using PHP with Source Code

Language

Hi! This is an Inventory and Monitoring System Project in PHP and MySQL database. The system was mainly built/developed to manage a certain pharmacy's stock/items. The system will help the pharmacy's management to monitor their stock in and stock out easily. They can easily restock the items and remove the expired medicinal drugs from the stock list. The system has also a simple sales transaction feature. The list of in-stock items and sales transaction are printable and the sales transaction is listed by filtered date.

This Inventory and Monitoring System Project was developed using PHP, MySQL Database, PDO, OOP, HTML, CSS, JavaScript (jQuery and Ajax), and bootstrap for the design. This system might gonna help you to learn more techniques or strategies in developing a PHP Project like this or has similar functionalities. You can learn such as CRUD Operations, Submit form data using Ajax, Object-Oriented Programming, and many more. The source code is free to download, continue reading for the features and how to run details.

Features

  • Manage Items/Products
  • Insert New Stock
  • Remove Stock
  • Simple Sales Transaction
  • Monitor In Stock Items/Products
  • Printable List of In Stock and Sales List

How to Run

Requirements

  • Download and Install any local web server such as XAMPP/WAMP with at least have a PHP version of 5.2.
  • Download the provided source code zip file. (download button is located below)

Installation/Setup

  1. Open your XAMPP/WAMP's Control Panel and start the "Apache" and "MySQL".
  2. Extract the downloaded source code 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 "regis".
  6. Import the provided SQL file. The file is known as "regis.sql" located inside the extracted source code folder.
  7. Browse the Inventory and Monitoring System in a browser. i.e. http://localhost/regis_inventory

Credentials

Username: admin
Password: admin

DEMO

I hope this Inventory and Monitoring System Project in PHP will help you with what you are looking for. Feel Free to modify it the way you want to enhance your programming capabilities.

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.

Comments

Submitted byKirby2 (not verified)on Mon, 05/15/2017 - 12:34

Hindi pwede rename ng db?
Submitted byTestingGP (not verified)on Mon, 05/22/2017 - 16:15

Error: L17+ when i try to log in and i already import the base
Submitted byTemi (not verified)on Wed, 10/25/2017 - 16:13

In reply to by TestingGP (not verified)

do you have solution for this same problem already imported the database. still have Error: L17+
Submitted bysamqarison Sat, 06/17/2017 - 18:44

I like you. Your work is just awesome and so helpful. Thanks.

Salamat dito brad. Ang daming natutunan ko dito bilang baguhan sa PHP. May request sana ako brad, kung pwede lang sana na dagdagan mo ung add employee form ng para sa picture pra maka pag save ng picture sa database. Salamat sa tulong.
Submitted byTemi (not verified)on Thu, 10/26/2017 - 11:47

Try to open it in netbeans as my editor. what is the problem with Error: L17+. Already imported the data. Thank You

How to solve the duplication item in the cart and in the sales. If you add an item with the same name and same item id it will duplicate. Is it possible to solve this problem?
Submitted bySyeda (not verified)on Sun, 12/23/2018 - 01:00

when i enter the user name and password it pops up a message “Localhost says’ error L17+ “. Kindly help me to resolve error L17+
Submitted by Error: L17+ (not verified)on Wed, 05/15/2019 - 13:44

when i enter the user name and password it pops up a message “Localhost says’ error L17+ “. How to solve it

Add new comment