Simple Inventory Sytem using PDO (For Beginners!)


1. OPEN phpmyadmin and create your desired database name. 2. While you are in your desired database, upload the sql file included in the project. 3. Change the database name in db.php to your desired database name. 4. run using your web server (Ex. wamp or xampp) and enjoy! In this inventory system you can:
  1. Add/Edit/Delete Items
  2. View number of items sold
  3. Search for existing items
  4. Add Quantity to existing items
  5. Sell Items
  6. View Sales Reports

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 for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.


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.


Submitted byFaye (not verified)on Thu, 07/24/2014 - 03:20


Thanks for the code. However, I'm getting this message on the homepage:

Notice: Undefined variable: hostname in C:\xampp\htdocs\inventory\db.php on line 6
ERROR: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)
Notice: Undefined variable: conn in C:\xampp\htdocs\inventory\index.php on line 78

Fatal error: Call to a member function prepare() on a non-object in C:\xampp\htdocs\inventory\index.php on line 78

Thanks for your help.

Submitted bymudassir (not verified)on Fri, 09/26/2014 - 14:12

no search text field in sourcecodester
Submitted byadamsa (not verified)on Thu, 02/12/2015 - 08:07

if you can i would like you to customize this with more futures please let me know futures like connecting to my online store and get orders and deduct from inventory
Submitted byADG (not verified)on Tue, 06/20/2017 - 07:44

For those with problems, if works perfect right out of the box. The exact details for installing are covered perfectly by Mr. Soriano above. You do need a basic understanding of how databases work. Do not try to run this on older browsers, you will not like what you see. It is formatted for newer browsers. It is very basic code, but absolutely not for beginners!! This is a good teaching tool if you want to understand PDO.
Submitted byAJ Namsuon Fri, 07/20/2018 - 16:34

bro thaanks for this program

Add new comment