Simple Inventory System Using PHP/MySQL

I developed this code to those beginner programmer who found difficulties in creating their inventory system using php/mysql. The feature of this system are, it generates daily inventory report, secure login because i use md5 encryption for login and registration . It also generate reports such as daily, weekly, monthly, and yearly. This system has many features not just the features written above. To try this system just download and run this system. If you have question, suggestion or anything, just leave comment and it's my pleasure to entertain your comments.
database name: liveedit
username: admin
password: admin
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
k Sharma (not verified)
Thu, 08/29/2013 - 16:40
Permalink
not running your inventory
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\xampp\htdocs\inventory\login.php:3) in C:\xampp\htdocs\inventory\login.php on line 5
how can i solved the problem
thank u
Chammburger (not verified)
Fri, 11/27/2015 - 10:17
Permalink
Fixing the session_start() error
Remove the empty lines and spaces at the beginning of login.php. The opening block of the php function should be the first think in the page. I had two blank lines when I installed. The error went away after deleting the two empty lines.
chim (not verified)
Wed, 08/07/2013 - 23:33
Permalink
php
hello
helloworld (not verified)
Wed, 08/07/2013 - 21:57
Permalink
inventory system
why is not computing the sales ? help me
Eun (not verified)
Sun, 08/04/2013 - 00:24
Permalink
Error in Log in
Good Day, I have downloaded this file but it seems every time I log in it says Opps some thing went wrong.
It also has a notice:
Notice: Undefined index: id in C:\xampp\htdocs\inventory\index.php on line 49
What does it mean? How do I get the program running? Please help, I want to learn more about making an inventory system using php/mysql :3
I'm a junior IT student and I'm also working on my own inventory system. I need to research more design and layouts. Thanks! :)
usbaw
Wed, 05/06/2015 - 14:19
Permalink
Error encounter: Login
Error: Opps some thing went wrong
login.php
--Original Code--
$mysql_hostname = "localhost";
$mysql_user = "root";
$mysql_password = "";
$mysql_database = "liveedit";
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password)
or die("Opps some thing went wrong");
mysql_select_db($mysql_database, $bd) or die("Opps some thing went wrong");
--My changes--
$mysql_hostname = "localhost";
$mysql_user = "root";
$mysql_password = "";
$mysql_database = "inventory"; //chaange this name of datbase name
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password)
or die("Opps some thing went wrong");
mysql_select_db($mysql_database, $bd) or die("Opps some thing went wrong");
I hope it will help to you guys.
Thanks,
Anonymous (not verified)
Sun, 07/14/2013 - 22:20
Permalink
Help
hey, thanks for the code, it is precise and concise to what i needed, am still a novice at php.mysql, but it seems there are some errors, these i get when i try running it, when i go to the sales tabs i get this
Notice: Undefined index: from in /Applications/MAMP/htdocs/inventory/inventory/tableedit.php on line 288
Notice: Undefined index: to in /Applications/MAMP/htdocs/inventory/inventory/tableedit.php on line 289
when i try prinitng the it seems to havent defined the variable $rtrt in table edit.php, help me to fix this
ma email adress is [email protected]
anonymous
Fri, 06/07/2013 - 07:38
Permalink
Thanks
This is very close to what I was looking for - close enough that I can pull snippets from here and there. It took all of 5 minutes to realize that I needed to add the following to the liveedit.sql:
CREATE DATABASE `liveedit`;
USE `liveedit`;
and change the user and password in db.php.
Anonymous (not verified)
Fri, 05/31/2013 - 07:42
Permalink
pls. help
something wrong with your database when i import it on mysql
MasterFerdz (not verified)
Wed, 03/25/2015 - 02:15
Permalink
nothing is wrong with the database
If you will check and read the sql there is nothing wrong with it. if import is not working for you, just manually encode the sql code and the run it.
Anonymous (not verified)
Thu, 05/23/2013 - 16:39
Permalink
Requesting for the project proposal
Dear Argie,
Am doing the same project for my final year. Could i kindly have your documentation spefically the literature review so i could cite you as my source. Please.
Anonymous (not verified)
Sun, 04/28/2013 - 21:09
Permalink
SCREAM:ERROR SUPPRESION INGNORED FOR
I am new in php.I downlode it and when i run this project above
error display & also Notice:undefined indexd : id in c:\wamp\www\inventory\index.php on line 49
please reply
Anonymous (not verified)
Mon, 04/22/2013 - 16:03
Permalink
Its working well, Thanks. But
Its working well, Thanks. But how do you sell a product ??
Anonymous (not verified)
Sun, 03/24/2013 - 20:50
Permalink
argie
hello po... bakit po ba nka error ang log in...
Anonymous (not verified)
Mon, 04/01/2013 - 14:43
Permalink
try mo iload ang sql file sa
try mo iload ang sql file sa db... pra mgkaruon nang content ang db mo
Anonymous (not verified)
Sat, 02/23/2013 - 13:59
Permalink
ayaw maglog in
ayaw maglog in
Anonymous (not verified)
Thu, 02/21/2013 - 18:43
Permalink
another bug
tq argie for share some script :)
but, I found bug, can u update this script, I just can't how to fix this :(
Anonymous (not verified)
Wed, 02/20/2013 - 23:48
Permalink
hi argie
thx will see it n back to u soon
Anonymous (not verified)
Sun, 02/10/2013 - 23:38
Permalink
Sales error
Hi Argie,
Need help on the sales menu. Error are listed below:
Notice: Undefined index: from in C:\xampp\htdocs\inventory\tableedit.php on line 283
Notice: Undefined index: to in C:\xampp\htdocs\inventory\tableedit.php on line 284
The codes are: $a=$_POST['from']; $b=$_POST['to'];
Any thoughts about this?
Thanks a lot!
Jean
Anonymous (not verified)
Tue, 01/22/2013 - 12:55
Permalink
error on quantity sold
hi argie when i put integer in the quantity sold field in the inventory i need to refresh the system to see the computation in the sales field. . what i am looking is that when i put integer it must be automatically compute and no need to refresh sir argie! but still your program is great very helpful gb
Anonymous (not verified)
Sun, 01/13/2013 - 07:43
Permalink
Easy to fix errors
If you need help putting the inventory system to work, you can contact me and for a small fee $20) I can help you get it up and running: [email protected]
Anonymous (not verified)
Fri, 01/11/2013 - 10:52
Permalink
hello
hello why is it that there is always error to the qty sold in the inventory??? "Notice: Undefined variable: rtrt in C:\wamp\www\inventory\tableedit.php on line 207" that is exactly the error and i did not change everything :) thank you
Anonymous (not verified)
Tue, 01/22/2013 - 12:57
Permalink
fix that error
i tried removing that error and still run. . just remove the following error listed there
Anonymous (not verified)
Tue, 01/08/2013 - 09:54
Permalink
thanks!
it's all working fine. nice!
jikan (not verified)
Mon, 10/14/2013 - 23:21
Permalink
php
what did you do to work?
Anonymous (not verified)
Sat, 01/05/2013 - 14:52
Permalink
qty updating fixed
change updateproduct.php file to:
<?php
include("db.php");
$proid=$_POST['ITEM'];
$itemnumber=$_POST['itemnumber'];
//mysql_query("UPDATE inventory SET qtyleft='$itemnumber'
//WHERE id='$proid'");
$result = mysql_query("SELECT * FROM inventory
WHERE id='$proid'") or die(mysql_error());
$row = mysql_fetch_array( $result );
$count = $row['qtyleft'] + $itemnumber;
$result = mysql_query("UPDATE inventory SET qtyleft='$count' WHERE id='$proid'")
or die(mysql_error());
header("location: tableedit.php#page=addproitem");
?>
BoyBawang (not verified)
Wed, 04/16/2014 - 15:20
Permalink
thank you bro !
Bro ! i love you thanks to this code
Anonymous (not verified)
Sat, 01/05/2013 - 07:13
Permalink
...
thanks argie!
to all those who are complaining - password, some features not working, blahblah.. why don't you all try to put an effort in reading the code and do a little bug fixing. yes, there are some minor bugs but otherwise argie's work is fine. sheesh!
for one thing, the login, of course, will not work if you haven't damn loaded the SQL file.
zxzx (not verified)
Mon, 06/01/2015 - 02:38
Permalink
zzzz
where is db file
Anonymous (not verified)
Fri, 12/21/2012 - 14:53
Permalink
kuya..
bakit po yung sa add product nag iinstant update po? d po nag aadd..? tnx..
Anonymous (not verified)
Thu, 11/07/2013 - 15:26
Permalink
sira yung codes mo
sira yung codes mo
renee (not verified)
Fri, 11/02/2012 - 14:29
Permalink
Add stock
Hi Argie,
Great code but I do have a question though. On the add item, instead of adding the stock, the app just updates the value of qtyleft. For example the product "qweqwqw" has 10 on qtyleft and if I go to add item and put 15 on quantity, I would like qweqwqw to become 25 instead of 15. How do I go about this? Thanks.
Hoping for your reply.
-Renee
argie
Fri, 11/02/2012 - 15:55
Permalink
to renne
pm me [email protected]
Arcel (not verified)
Tue, 10/17/2017 - 22:47
Permalink
Can you send me the code for
Can you send me the code for this? we have the same problem.
zethan villarino (not verified)
Fri, 05/08/2015 - 14:22
Permalink
php
you look grreat huh teach me how to make a basic program in easyway???
Angelie (not verified)
Sat, 08/09/2014 - 17:36
Permalink
Hi Argie .. I am Angelie can
Hi Argie .. I am Angelie can I ask for your help ?? I downloaded your codes , but the sales one .. is not working :( I hope u can help me .. thank u :D
renee (not verified)
Sat, 11/03/2012 - 01:24
Permalink
PM sent
Hi Argie,
I have sent you a PM. I hope you can help me.
Regards,
Renee
Anonymous (not verified)
Sun, 10/07/2012 - 21:24
Permalink
No use brother to upload such a zip file.
Please don't waste time to read & upload it's file. It contains error in login. System isn't work properly.
Anonymous (not verified)
Thu, 08/23/2012 - 15:21
Permalink
error in log in
error in log in
marc david galang (not verified)
Sun, 07/20/2014 - 22:08
Permalink
error in log in
baka may mali sa database mo or yung login_process mo.
Anonymous (not verified)
Mon, 08/20/2012 - 02:29
Permalink
username and password not found
Hi. Am I using the correct username and password? I use "admin" for both but I get an error message that username and password not found. I tried entering "3", "admin", "admin" on the register form based on the value on the database but it says "You dont have access to add user pls. contact the administrator".
Tom Kayonjo (not verified)
Mon, 07/23/2012 - 17:40
Permalink
how do u make sales? i think
how do u make sales? i think something is missing
Pages
Add new comment