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
Zoha (not verified)
Thu, 06/28/2018 - 16:50
Permalink
Error missing username and password
hey i have imported the database and replace every where mysql to mysqli after doing all these i am having this error username missing and password is missing
Anonymous (not verified)
Tue, 02/20/2018 - 22:45
Permalink
Thanks ok well thanks
Thanks ok well thanks
NotFennic (not verified)
Thu, 01/25/2018 - 19:02
Permalink
Xammp or Mysql?
Excuse me are you using xammp because i use xammp for my project
need help (not verified)
Thu, 12/07/2017 - 09:47
Permalink
cannot login
anyone can please help for:
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\inventory\inventory\inventory\db.php:6 Stack trace: #0 C:\xampp\htdocs\inventory\inventory\inventory\login.php(6): require_once() #1 {main} thrown in C:\xampp\htdocs\inventory\inventory\inventory\db.php on line 6
muneendra k
Wed, 11/15/2017 - 20:33
Permalink
errors in
Notice: Undefined index: date in C:-\inventory\inventory\tableedit.php on line 173 i didn't get what is the problem here and one more thing is here in inventory column the date is automatically changes which means the date is updated when we open the system. rectify and clarify me sir......its good coding. thank you so much
muneendra k
muneendra k
Wed, 11/15/2017 - 11:07
Permalink
simple inventory module
sir, send me the modules and system requirements to this project( UML diagrams and module descriptions). THANK U
muneendra k
duralumin (not verified)
Wed, 10/04/2017 - 15:31
Permalink
asking
do you have a boyfriend?
Anonymous (not verified)
Mon, 09/18/2017 - 04:47
Permalink
Having problem login in
Error messages coming up when I tried logging
peter Sowet Aduma (not verified)
Tue, 07/25/2017 - 00:14
Permalink
Inventory
thanks so much i hope the project will help me greatly...
tanarat (not verified)
Sun, 06/11/2017 - 22:32
Permalink
hi
very good best !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1
Anonymous (not verified)
Sat, 05/06/2017 - 23:25
Permalink
why is the log in broken? its
why is the log in broken? its just saying oops something went wrong? help me please
Ashish mishra (not verified)
Wed, 05/03/2017 - 20:27
Permalink
Regarding project report on simple inventory management by argie
Hi argie,can you please provide the report of your project on inventory management.that can help to understand the project easily..
Thank you
UniGirl (not verified)
Sun, 04/30/2017 - 01:15
Permalink
Help me
I've error everytime I log in..
The error is :
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\inventory\inventory\db.php:6 Stack trace: #0 C:\xampp\htdocs\inventory\inventory\login.php(6): require_once() #1 {main} thrown in C:\xampp\htdocs\inventory\inventory\db.php on line 6
Can anyone fix this error for me? God bless you..
Aadi Malik (not verified)
Thu, 08/11/2016 - 13:10
Permalink
Error in Date ,daily sale and qnty sold
date error:173
daily sales error:215
qnty sold error:207
zuber (not verified)
Tue, 06/14/2016 - 15:48
Permalink
php
I have help for php
Anonymous (not verified)
Sat, 12/05/2015 - 17:05
Permalink
mayroon bang code para sa
mayroon bang code para sa delete product??
uzair.uzii
Sat, 11/14/2015 - 00:53
Permalink
nice sharing, keep it up
nice sharing, keep it up
Santheesh (not verified)
Tue, 07/07/2015 - 16:30
Permalink
How to run this project
I dnt knw how to run the project please help me
Tiberiu (not verified)
Wed, 05/27/2015 - 04:18
Permalink
Nice code. Keep on coding!
Hi Argie,
Just looked at the code and I liked it.
I head a bit of headwind working through all the errors but with 2 hours if coding, all is working properly (at least for me :) ).
The code is nice and easy to read/adjust, but if I may, I would like to make some suggestions:
- for the Notice error: 'undefined index id' that everyone is complaining there are two simple mechanisms to put in place to make sure it doesn't show in the browser:
1. In index.php put the following lines:
if(isset($_GET['id'])){
$remark=$_GET['id'];
if($remark=='success'){
echo '<ul>';
echo '<li>'." Registration Success You can now login ".'</li>';
echo '</ul>';
}
}
Normally this would not show if the error reporting level is set to low, so ...
2. Instruct users to set a lower error logging level like E_STRICT or E_ERROR or to exclude notice with ~E_NOTICE.
I would not suggest method 2 especially when you are in development mode :).
- mysql statement is deprecated in MySQL 5 so my suggestion is to use mysqli statements instead. This worked for me.
All in all, good code and really good effort. Keep on coding.
penggot (not verified)
Mon, 05/04/2015 - 10:22
Permalink
php
for sure, galing lang itong codes na ito sa ibang website, kya ignore lang ang gngwa instead of debugging the errors..
Dr. Switch (not verified)
Mon, 04/20/2015 - 08:19
Permalink
Nice
Hmmmm... Nice Keep up to help others... at same time you gats update your scripts...
Anonymous (not verified)
Mon, 03/30/2015 - 22:50
Permalink
I want to learn more on this
I want to learn more on this
raffy (not verified)
Wed, 11/26/2014 - 15:59
Permalink
boo
its not working . login error !
MasterFerdz (not verified)
Wed, 03/25/2015 - 02:17
Permalink
its not working . login error !
If you are having login error, you might want to check the index.php to login.php to db.php
check if all the code is connected to your database.
admin
admin
pinkoman555
Sun, 11/16/2014 - 04:06
Permalink
Pinkoman
argie thanks for this kindness
i will check it out later
Pinkoman.com
Pinkoman
chess (not verified)
Sat, 10/11/2014 - 19:10
Permalink
how to add sold items
sir, how can i add a sold items.. it won't work if i click the row .. in your codes
MasterFerdz (not verified)
Wed, 03/25/2015 - 02:20
Permalink
how to added sold items
if you are able to click the row and able to create input, all you have to do is refresh the page. thats the only flaw of this inventory sys. :)
chess (not verified)
Sat, 10/11/2014 - 19:06
Permalink
table_edit_ajax.php
ahhm... sir , how can i add a sold items ???
when i click the row it won't work.. plzz . help me .
x (not verified)
Tue, 09/02/2014 - 15:19
Permalink
sir bakit hindi ko po ma
sir bakit hindi ko po ma import yung database
eto poh yung lumalabas
Error
SQL query:
-- --------------------------------------------------------
--
-- Table structure for table `inventory`
--
CREATE TABLE IF NOT EXISTS `inventory` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`item` VARCHAR( 100 ) NOT NULL ,
`qtyleft` INT( 11 ) NOT NULL ,
`qty_sold` INT( 11 ) NOT NULL ,
`price` INT( 11 ) NOT NULL ,
`sales` INT( 11 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =6;
MySQL said: Documentation
#1017 - Can't find file: 'inventory' (errno: 2)???
help poh newb lang poh kc ako sa php
victor daniel (not verified)
Sat, 08/30/2014 - 20:32
Permalink
sales code is important
sales error i found so what are the code for sales
artha (not verified)
Tue, 08/26/2014 - 07:37
Permalink
fix code
- in original code :
---------
<?php
//Start session
session_start();
- in login.php please edit like this
-----------
<?php
//Start session
session_start();
you must place code on the top, cannot any space.
jrc (not verified)
Fri, 06/20/2014 - 01:18
Permalink
Error when trie to loging
Error when trie to loging
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at login.php:3) in login.php on line 5
Warning: session_regenerate_id() [function.session-regenerate-id]: Cannot regenerate session id - headers already sent in login.php on line 55
Warning: Cannot modify header information - headers already sent by (output started at login.php:3) in login.php on line 61
machachari (not verified)
Tue, 06/17/2014 - 00:24
Permalink
dude u save me, thumbs up
dude u save me, thumbs up
Apata Babajide (not verified)
Sat, 05/31/2014 - 00:00
Permalink
you are a blessing to US
Am short of words what more can I say than "Thanks so much..."?
dejo (not verified)
Thu, 05/22/2014 - 21:20
Permalink
I can not add item
I can not add items thorough the additem button..? please help
Anonymous (not verified)
Wed, 04/30/2014 - 15:18
Permalink
something went wrong
when i log in and set the usernama and password to admin. its a message that said something went wrong.how i fixed it? pls help me.... pls
rosemar (not verified)
Tue, 04/29/2014 - 11:03
Permalink
error in log in
bakit hindi po ako maka log-in???,,,,query failed po yung lumalabas tapos sa registration,,pag nag register ako....you cannot add another user yung lumalabas???,,,please pm me @ [email protected]
4chan (not verified)
Thu, 04/03/2014 - 19:58
Permalink
tableedit.php
For those with errors on line 283/284, you need to select a date range first.
Working fine here, with the exception of a few typo's which had to be changed to reflect the names in the corresponding tables.
Thank you
michellepradia
Sat, 03/15/2014 - 00:49
Permalink
tableedit.php
hi eto na lang po yung problem ko sa tableedit.php
Notice: Undefined variable: a in C:\xampp\htdocs\inventory\tableedit.php on line 283
Notice: Undefined variable: b in C:\xampp\htdocs\inventory\tableedit.php on line 283
anu po gagawin ko para matangal yung msg na yan tnx u po
pde po bang pahinge ng copy ng documentation ninyo jan tnx u ... kung ok lng po isend ninyo na lng sa y.m ko po na [email protected] tnx u
Anonymous (not verified)
Wed, 03/12/2014 - 00:16
Permalink
error in log in
bakit po hindi ako maka log in? Opps some thing went wrong po ung lumalabas... I need ur help po...
laurencejean (not verified)
Tue, 03/04/2014 - 19:51
Permalink
error in log in
username and password not found..
Kyle (not verified)
Thu, 02/27/2014 - 18:31
Permalink
Thank you
I would like to thank you personally. This is a big help for me learning php
michellepradia
Thu, 02/20/2014 - 17:21
Permalink
simple inventory system
sir panu ko po mah run ung gawa ninyo ?
terance (not verified)
Wed, 02/19/2014 - 19:51
Permalink
it works correctly.first of
it works correctly.first of all you have to import mysql database into the server.then type username and password.
kpbahinting
Fri, 02/14/2014 - 04:39
Permalink
i can't access it...i already imported the sql into myphpadmin.
i can't access it...i already imported the sql into myphpadmin...can't login into the system...
Malay Majumdar (not verified)
Mon, 02/10/2014 - 15:43
Permalink
inventory
Unable to access db. After login shows the page "Opps some thing went wrong" please advise.
randi (not verified)
Mon, 01/06/2014 - 10:08
Permalink
program
sorry i'am not accesss your progrem
Shawn H. (not verified)
Sat, 12/07/2013 - 06:25
Permalink
Where to put files.
I am very new to this...Where do you put the folder with all the files???
I am using phpmyadmin
tuytoosh
Sun, 11/10/2013 - 06:12
Permalink
Query failed
i cant work with it
i import sql file with phpmyadmin and run script but when i loged in the browser said "Query failed"
Fams (not verified)
Tue, 10/01/2013 - 20:29
Permalink
I got error
Notice: Undefined index: id in C:\wamp\www\inventory\index.php on line 49
Pages
Add new comment