Loading

Simple Inventory System Using PHP/MySQL

Submitted by: 
Language: 
Visitors have accessed this post 111967 times.


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

how do u make sales? i think something is missing

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".

error in log in

baka may mali sa database mo or yung login_process mo.

Please don't waste time to read & upload it's file. It contains error in login. System isn't work properly.

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's picture

pm me [email protected]

Hi Argie,

I have sent you a PM. I hope you can help me.

Regards,
Renee

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

bakit po yung sa add product nag iinstant update po? d po nag aadd..? tnx..

sira yung codes mo

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.

change updateproduct.php file to:

$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");
??>

Bro ! i love you thanks to this code

it's all working fine. nice!

what did you do to work?

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

i tried removing that error and still run. . just remove the following error listed there

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]

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

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

thx will see it n back to u soon

tq argie for share some script :)
but, I found bug, can u update this script, I just can't how to fix this :(

ayaw maglog in

hello po... bakit po ba nka error ang log in...

try mo iload ang sql file sa db... pra mgkaruon nang content ang db mo

Its working well, Thanks. But how do you sell a product ??

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

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.

something wrong with your database when i import it on mysql

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.

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]

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! :)

why is not computing the sales ? help me

hello

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

Notice: Undefined index: id in C:\wamp\www\inventory\index.php on line 49

i cant work with it

i import sql file with phpmyadmin and run script but when i loged in the browser said "Query failed"

I am very new to this...Where do you put the folder with all the files???

I am using phpmyadmin

sorry i'am not accesss your progrem

Unable to access db. After login shows the page "Opps some thing went wrong" please advise.

kpbahinting's picture

i can't access it...i already imported the sql into myphpadmin...can't login into the system...

it works correctly.first of all you have to import mysql database into the server.then type username and password.

michellepradia's picture

sir panu ko po mah run ung gawa ninyo ?

I would like to thank you personally. This is a big help for me learning php

username and password not found..

bakit po hindi ako maka log in? Opps some thing went wrong po ung lumalabas... I need ur help po...

michellepradia's picture

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

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

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]

Pages

Add new comment

(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.

Filtered HTML

  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.