1. PHP
  2. Simple Inventory Sytem using PDO (For Beginners!)

Simple Inventory Sytem using PDO (For Beginners!)

Submitted by RobertSoriano on Monday, January 13, 2014 - 21:48.
Language
PHP
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 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.

Tags
inventory
simple
simple inventory
php inventory
inventory php
pdo inventory
php pdo inventory
pdo php inventory
simple inventory system
simple inventory system using php

Comments

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

Hi,

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 by mudassir (not verified) on Fri, 09/26/2014 - 14:12

no search text field in sourcecodester

Submitted by adamsa (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 by ADG (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 by AJ Namsu on Fri, 07/20/2018 - 16:34

bro thaanks for this program

Add new comment

About text formats