PHP Inventory

 

Survey on v2.0

I posted simple two question survey on future development of PHP Inventory. Please voice your opinion.

 

Screenshots of v2.0

Login screen Users page Add user

 

Description

PHP Inventory is free, open-source, web-based inventory tracking solution, designed to provide small businesses the efficiency of large companies.

Inventory Control reduces costly inventory errors, improves customer service, and will increase the value of your business. PHP Inventory is easy to use and implement without the cost or complexity of larger inventory tracking systems.

 

Demo

You can access program demo here: PHP Inventory demo

To login as administrator use:
Username: admin
Password: demo

To login as regular user use:
Username: user
Password: demo

 

Download & Installation

Download the file below and extract it. Installation instructions are located in readme.htm file

 

Support

Had (and still have) a huge problem with spam in the comments, so please use our contact form for support.

 

AttachmentSize
php-inventory_1.3.2.zip124.91 KB

Comments

How to display product list without login

Hey.. is there any solution?? i wanted to display product list to public without logging in first.. please helpp me

Security Update

Everyone who is using PHP Inventory 1.3.1 or earlier, please download v1.3.2, it contains security fix that prevents bypassing log-in screen.

MySQL error

Hello,

Yesterday I found your program and wanted to use as a basis for my own stock control for a store that will open soon (waiting for version 2.0, which looks set to distribute). The fact is that I get the following error:

PHP Warning: mysql_error () Expects parameter 1 to be resource, boolean Given in / opt / lampp / htdocs / inventory / lib / database.php on line 84

As you can see, I'm installing the application on a Linux system through lampp package (Apache, PHP amd MySQL bundle) but I receive this same error on my VPS Centos 5. I work under the latest versions of PHP, MySQL, Apache and in the case of my PC, Ubuntu (Now, I'm checking the lampp configuration...).

I would greatly appreciate your help, accept my congratulations and best regards,

Carlos

Best Solution

I found a radical solution by my own. The best way is to unistall lampp and use the natural way of linux... That is, install apache2, mysql and php (with phpmyadmin, of course). It works at all and have waste 5 minutes(Under lampp I found a solution configuring php.ini but many problems came after). Now it's time to implement some ideas, thanks again for your work and let me know if version 2.0 become soon.

Carlos

ADD.xml

Hi,

Good day!

Just downloaded the PHP-Inventory v1.2 and was encountering error messages every page. I already modified the "Allow_call_time_pass_reference = On" on the php.ini file to remove the "Depricated error messages".

Do I need to adjust all the "add.xml" files to that the system will extend up to 2010???

Many thanks,
JP

Year issues Change

Normally it is working if you change the add.xml in admin and user transactions.

<trans_date2 type="date" now="true">
			<title>Date</title>
 
			<fields>
				<month format="int" default="now" />
				<day format="int" default="now" />
				<year from="2004" to="2011" default="now"/>
			</fields>
		</trans_date2>

-----

If it did not work try to restart the webserver and try.

Year issues Change

With the new update released (1.3), year selection range defaults from 2004 to current year + 1. For example, currently we have 2011, so drop-down range will be 2004-2012.

Documentation

I download, install and use tool quickly. But I need customize, do you have any technical documentation?

Documentation

There is no technical documentation, only installation/upgrade instructions. If you want to modify the code - you are on your own :)

Capabilities comment

Hi
Here are my comments after playing around with this software.

1. I found that the number of items added MUST be 2 digit so to add 1 to the inventory of product A you need to key in '01'

2. Version 1.2 Cannot track a product with multiple serial numbers. When you add a product to the inventory, there is no field for the serial number.. you could use the notes section.. but I tried but I dont know how to make the notes appear in place of the username when the product detals are reported.

Allan

Re: Capabilities comment

The bug that required at least two digits for inventory changes is fixed now in v1.3.

php_inventory 1.2 and WAMP

I came across this small inventory program and decided to test it out

so I downloaded this package from
- http://www.wampserver.com/en/
- Which includes EVERYTHING you need to start using php_inventoty.

Some changes needs to be done. open the file site.sql in notepad.

site.sql changes
===================
Change all 'TYPE=My" to "engine=My" in notpad - (replace all)

PRIMARY KEY (`note_id`)
) engine=MyISAM AUTO_INCREMENT=11 ;

0. Launch Wamp - http://localhost
0.1 navigate to http://localhost/phpmyadmin/
1. Create the database with phpadmin
2. Choose the database
3. Open the SQL query window
4 Select all text from site.sql
5. Press / GO
6. copy all the php_inventory.zip files to c:\wamp\www\inv
7. Change the contents of ADD.XML so that the date extends past 2010
the file is located at C:\wamp\www\inv\forms\user\transactions



you can now login as admin / test and start playing it as follows
http://localhost/inv

The program is very basic. I am new to PHP and XML forms so I would like to know recommended tools available to extend the program.

Another option is to use a web database reporting tool to simply generate what is missing from mysql

** remember to put the WAMP startup link in your windows startup

Allan

Release Date for 2.0

Still waiting for 2.0. is it coming out anytime soon?

apostrophe in database inputing

i wonder can any one help ,,ive made some extra fields in the xml files and also built the tables to match into the database ,everything is working , inputting data and reading data back out , im getting one error ,,apostrophe's the database no longer like apostrophe's in any input on saving.

When I click to download I get an error

Hello,

When I click the link, php_inventory_1.2.zip that is above, I get the message, "Page not found." What is wrong?

Thanks advance for any help.

Nick.

Fixed it, sorry about that.

Fixed it, sorry about that.

Fatal Error

Hi!

I'm having a problem stated Fatal error: Cannot redeclare fputcsv() in C:\xampp\htdocs\lib\common.php on line 935, I've checked the program source were the error has been occur...don't know how to fix it..please help ASAP

Great little app, but does export include the count?

Hi,
This is a great little app that does what it claims to!
The only thing I couldn't get to work is the product export -- Does it export the product count? I see the count in the csv header but no data after the product..
thanks!

Stopping users see transaction history

Could someone help provide me with changes I need to make so that I can block standard users from adding new transactions or seeing the transactions that make up the count number. Basically I want it to be read only on the first page and so user can see the total "count" for each product but the user is not be able to go in and view the details that make the number up. I will leave that for admin users only. Help much appreciated. Thanks.

php-inventory 2.0????

I am just counting the time you will release the php inventory 2.0, it will be great

sir

when i run this program using localhost, the browser just display blank white page.. how do i configure the settings regarding database settings?i just want to learn about simple php. thanks for the help sir..

Installation on windows XP

can i install this on windows XP? thanks.

im getting lot of errors please help.

Hi im getting lot of errors please can you help me to solve these problems. aykun@hipnoticwheels.com is my email. waiting for your reply .
Thanks

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/site.php on line 183

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/77/5679977/html/inventory/lib/site.php:183) in /home/content/77/5679977/html/inventory/lib/site.php on line 57

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/common.php on line 719

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/xml.php on line 65

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/html.php on line 230

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/html.php on line 310

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/sqladmin.php on line 88

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/sqladmin.php on line 88

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/sqladmin.php on line 111

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/sqladmin.php on line 111

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/forms.php on line 1002

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/forms.php on line 2242
CDatabase::SelectDB() error

login in

don't seem to be login in, where is the problem even with the demo itself.

im getting lot of errors please help.

Hi im getting lot of errors please can you help me to solve these problems. aykun@hipnoticwheels.com is my email. waiting for your reply .
Thanks

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/site.php on line 183

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/77/5679977/html/inventory/lib/site.php:183) in /home/content/77/5679977/html/inventory/lib/site.php on line 57

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/common.php on line 719

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/xml.php on line 65

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/html.php on line 230

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/html.php on line 310

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/sqladmin.php on line 88

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/sqladmin.php on line 88

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/sqladmin.php on line 111

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/sqladmin.php on line 111

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/forms.php on line 1002

Warning: Call-time pass-by-reference has been deprecated in /home/content/77/5679977/html/inventory/lib/forms.php on line 2242
CDatabase::SelectDB() error

Deprecated: Call-time pass-by-reference has been deprecated

Hello!
I've a problem. Do you have solution for help me?
errors:
Deprecated: Call-time pass-by-reference has been deprecated in C:\wamp\www\inventory\lib\site.php on line 183
Call Stack
# Time Memory Function Location
1 0.0030 367208 {main}( ) ..\index.php:0

( ! ) Deprecated: Call-time pass-by-reference has been deprecated in C:\wamp\www\inventory\lib\common.php on line 719
Call Stack
# Time Memory Function Location
1 0.0030 367208 {main}( ) ..\index.php:0
2 0.0076 420816 require_once( 'C:\wamp\www\inventory\lib\site.php' ) ..\index.php:7

( ! ) Deprecated: Call-time pass-by-reference has been deprecated in C:\wamp\www\inventory\lib\xml.php on line 65
Call Stack
# Time Memory Function Location
1 0.0030 367208 {main}( ) ..\index.php:0
2 0.0076 420816 require_once( 'C:\wamp\www\inventory\lib\site.php' ) ..\index.php:7

( ! ) Deprecated: Call-time pass-by-reference has been deprecated in C:\wamp\www\inventory\lib\html.php on line 230
Call Stack
# Time Memory Function Location
1 0.0030 367208 {main}( ) ..\index.php:0
2 0.0076 420816 require_once( 'C:\wamp\www\inventory\lib\site.php' ) ..\index.php:7

( ! ) Deprecated: Call-time pass-by-reference has been deprecated in C:\wamp\www\inventory\lib\html.php on line 310
Call Stack
# Time Memory Function Location
1 0.0030 367208 {main}( ) ..\index.php:0
2 0.0076 420816 require_once( 'C:\wamp\www\inventory\lib\site.php' ) ..\index.php:7

( ! ) Deprecated: Call-time pass-by-reference has been deprecated in C:\wamp\www\inventory\lib\sqladmin.php on line 88
Call Stack
# Time Memory Function Location
1 0.0030 367208 {main}( ) ..\index.php:0
2 0.0076 420816 require_once( 'C:\wamp\www\inventory\lib\site.php' ) ..\index.php:7

( ! ) Deprecated: Call-time pass-by-reference has been deprecated in C:\wamp\www\inventory\lib\sqladmin.php on line 88
Call Stack
# Time Memory Function Location
1 0.0030 367208 {main}( ) ..\index.php:0
2 0.0076 420816 require_once( 'C:\wamp\www\inventory\lib\site.php' ) ..\index.php:7

( ! ) Deprecated: Call-time pass-by-reference has been deprecated in C:\wamp\www\inventory\lib\sqladmin.php on line 111
Call Stack
# Time Memory Function Location
1 0.0030 367208 {main}( ) ..\index.php:0
2 0.0076 420816 require_once( 'C:\wamp\www\inventory\lib\site.php' ) ..\index.php:7

( ! ) Deprecated: Call-time pass-by-reference has been deprecated in C:\wamp\www\inventory\lib\sqladmin.php on line 111
Call Stack
# Time Memory Function Location
1 0.0030 367208 {main}( ) ..\index.php:0
2 0.0076 420816 require_once( 'C:\wamp\www\inventory\lib\site.php' ) ..\index.php:7

( ! ) Deprecated: Call-time pass-by-reference has been deprecated in C:\wamp\www\inventory\lib\forms.php on line 1002
Call Stack
# Time Memory Function Location
1 0.0030 367208 {main}( ) ..\index.php:0
2 0.0076 420816 require_once( 'C:\wamp\www\inventory\lib\site.php' ) ..\index.php:7

( ! ) Deprecated: Call-time pass-by-reference has been deprecated in C:\wamp\www\inventory\lib\forms.php on line 2242
Call Stack
# Time Memory Function Location
1 0.0030 367208 {main}( ) ..\index.php:0
2 0.0076 420816 require_once( 'C:\wamp\www\inventory\lib\site.php' ) ..\index.php:7

( ! ) Notice: Undefined variable: password in C:\wamp\www\inventory\lib\database.php on line 85
Call Stack
# Time Memory Function Location
1 0.0030 367208 {main}( ) ..\index.php:0
2 0.0422 2077960 CSite->CSite( ) ..\index.php:9
3 0.0566 2124312 CDatabase->CDatabase( ) ..\site.php:149
4 0.0566 2124416 CDatabase->Connect( ) ..\database.php:70

Great Inventory, but lacking documentation

Hi there,

I am very pleased with the software used and have experimented a lot with it to customize it. The inventory is very customizable but is lacking in documentation on how to add new features in it.

I am finding it very difficult to add new catagories and add their respective add, edit, delete functions.

Could someone provide an explained documentation or user manual on how to do this and also how to use almost every feature of this software and be able to customise it?

If someone could please help me in this send an email to ultimategameplay@hotmail.com

Thanks,
Francesco

adding a if argument

i wonder would any of you guys know how to make a if argument work , the database has be used for stock and some stock is marked with (1) for in stock and others marked as (0) for out of stock or sold id like to add a button on the left that would only show records with the stock field (1) or stock field (0) so its easier to work out at a glance whats sold and whats not ,,i know how to edit the list.xml but the syntax of the if argument to show or not show only records with either (1) or (0) in is not my level of knowledge

have i explained myself correctly

mark

use of checkbox

For a start, my compliments for your work; this app displays one of the best interface structure I've ever seen: just out of curiosity, which is the web framework you've used? Now, my little question: I'm rearranging the DB to record our job activities and I need to use a checkbox in a form. I associated the checkbox field to an ENUM (values: 'on','off')datatype in mySQL, but there's no way I can get to actually update this field, or add a new one. I got some doubt that I miss out some parameters in the add.xml file where you define type=checkbox , etc. I put down some guesswork trying value=1 and other stuff, but nothing does. Can I find some documentation on the syntax to be used in these XML config files?
Thanks for your help
Fabio

Add this features

Good job sir, its nice if you can add this

1. Option in Admin Panel to add a new column so we can add new details like Min and Max stock of parts.

2. Search feature - users can search the Name, PartNumber etc.

3. Disallow users to transac if the part count is ZERO.

4. Auto send to email if somebody do a transactions.

Hope to consider this features.

Thanks

image view

great app and made with some thought as well

can it show images ive noticed changing a field type to image brings up the upload option im just wondering if there is a way of perhaps displaying a image from html code/link url in the description box for a record

great work please add me to your mailing list and newsletter

Re: image view

Image field will be working in version 2.0.

I can't sign you up for newsletter (requires your confirmation), you can do it here - http://www.phpwares.com/newsletter/subscriptions

About displaying UTF-8

First thanks for this wonderful system.

I've a problem about displaying UTF-8 character,

for example, in vendor page, I can input and update the DB with UTF-8 character, but, it cannot display on the listing.

However, when i click EDIT, it can be displaybe perfectly in the input textarea

What can i do? thanks.

error message

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/a6104530/public_html/lib/database.php on line 85

i've tried putting in my own code for it and it still won't work. Do you have any clue what the deal is with this???

Installation steps

Hi Guys,

It would be great help, if anyone can post installation steps (readme is not enough)

I got some issues after I installed and logged in using admin details, not able to proceed further.

Appreciate help.

Nick

db error - select ....

Hi,

I'm just new to this. I downloaded and installed the script for this PHP inventory to my webserver and changed the database details.

I was able to login on my URL using 'admin' and 'test' details.

However, I get this error when click on any of the side categories, like say 'products'

SELECT * FROM `` WHERE ``=''Incorrect table name ''

Where am I going wrong ?

Appreciate your help.

Nick

Table

make sure you have added the table in the site.xml to get the instance of it. Also make sure that you inserted it in the database.

Hope this helps.
Cheers!

Date field

Hi there,

Just got this up and running and I must say great little program. One of the items that I noticed is that when I try to add a new transaction all three date fields say {NAME} {NAME} {NAME}

Is that something that can be changed? Or is it something that I setup incorrectly?

Re: Date field

I was not able to replicate your problem, so it can be hosting environment issue. Do you get this problem when logged in as admin, user, or both? All other fields are functioning ok?

Any ideas of what I can look

Any ideas of what I can look at?

Re: Date field

I get it as both users. What type of hosting issues should I start looking at?
I started looking at some of the code on my end and this is what I found,

I then went to your demo site and found the code but its totally different.

Re:Date Field

I sent you a email through the contact us link...

Great work!!

A very good program. When will 2.0 come out? Thanks

Thank you!!!!

This was just the thing for our paper inventory. We don't need prices just quantities to know if we need to order or not. Thank you so much for providing this. Looking forward to 2.0.

php-inventory NOT able to login

Unable to login. index.php just refreshes. Currently on a linux server. Error log says 'sesssion.save.path' is NOT correct. Actual directory is /v/w/php-inventory/lib but the path set incorrectly shows /v/lib/php/session with the referer #http://localhost/index.php

Your online demo does not work with either ID or password, in CAPS or lower case.

'Busy' is not an excuse for poor performance.

I think the same problem to

I think the same problem to be troubling of many people
Chicken dog treats

Fatal error: Cannot redeclare fputcsv() in

Really good job and thanks for sharing.
However I got a problem when entering 'index.php', the message is

Fatal error: Cannot redeclare fputcsv() in /var/www/inventory/lib/common.php on line 935

OS: Ubuntu server 9.04
Apache 2, PHP 5. and MySQL 5.
Database tables were correctly created.

Please advise any idea. Thanks.

.htaccess Problems

It says to insert the code so that the .xml config files don't show. Well i don't know where to place the .htaccess file in order to prevent this since there isn't already a .htaccess file in my directory. Any help would be appreciated.

Thanks in advance

rwilson16@my.devry.edu

When will PHP Inventory 2.0 be ready?

Please be informed. Thanks,

awesome

Great job on this program. It works great and I'm sure 2.0 will be even better. Keep up the awesome work. Thnks