Web based PHP and MySQL Asset Management database for fast easy access, updates and CSV generated reports. The application is designed to manage IT assets from a Desktop Services perspective: computers and associated hardware, printers and software. The software is free here to anyone who has a use for it.
View the demo here
username: eam
password: eam123
Requirements
- PHP 5.6 or lower (does not work with PHP 7)
- Apache, MySQL, PHP – WAMP on Windows or LAMP on Linux.
- SQL Management tool like phpMyAdmin
- Follow the ten step setup guide – Create a database, use supplied SQL dump file to populate.
- Dreamweaver – Needed only if you wish to modify the application as it was written.
Updated – Version 3.0 – 04/13/2013
- PHP 5.3+ support – addresses “Function session_register() is deprecated” error
- Added – Asset Tag field
- Added – Purchase Order field
- Fixed and updated – Search and Search Results pages
- Fixed – Login and Logout pages
- Existing install upgrades – download package and follow Upgrade Steps in the Readme. Quick and easy: import SQL update, replace 8 files.
Download source code and all assets
- Application files for version 3.0
- SQL code, logo file and assets in the Assets folder
- 10 step setup doc in the root of the site 1-README.txt
110 thoughts on “Asset Management Database – Free Download”
Kindly assist to resolved the error message Asset management Database
Fatal error: Uncaught Error: Call to undefined function mysql_pconnect() in C:\xampp\htdocs\eam\Connections\eam.php:10 Stack trace: #0 C:\xampp\htdocs\eam\index.php(1): require_once() #1 {main} thrown in C:\xampp\htdocs\eam\Connections\eam.php on line 10
It always shows a message that Access denied for user ‘eam’@’localhost’ (using password: YES).
How can i Solve it.
Thanks in advance ….
Fatal error: Uncaught Error: Call to undefined function mysql_pconnect() in C:\xampp\htdocs\eam\Connections\eam.php:10 Stack trace: #0 C:\xampp\htdocs\eam\index.php(1): require_once() #1 {main} thrown in C:\xampp\htdocs\eam\Connections\eam.php on line 10
M so sorry, i was working on other project, hope i will finish on this month. You can message on my YouTube video or here.
HI,
I checked the video, it looks nice, very clean interface.
If you are done, can you put up the application for download?
Thanks
have you released the latest version of EAM, as shown in above youtube video?
please advise!
Thanks.
hi i uploaded this video you much check out, thx
link:-https://youtu.be/etYJklAPFd8
i am working on and added latest php code like OOP (Object Oriented Programming), jquery, bootstrap, font awesome and many more. Fix all bug you will love to see it. i will upload picture soon. just keep in touch.
sorry guys am here to help you guys please feel free to message here
@ekor Works with PHP v5 :)
Unable to login to the demo
Many thanks for the apps. Btw I try to login your demo and nothing appears, could you help with that ?
I’m sure the user name and the password is correct.
Thanks
@Max Oinam: This is good design! How do I download this? Thank’s!
Great effort and really good for IT Asset Management. I was hoping for something a little more configurable from a server point of view that has CPU/RAM/Disk capacity options so I can assign a cost to each.
Easy to setup though I did have to chown -R apache /var/www/html/eam/ and a couple of subfolders as
the message database could not be found.
I may just have to pull out the stops and get some Dreamweaver/PHP skills under my belt. I did have a look at your code but don’t want to mess about with it without knowing what I will screw up.
Thanks
Thank you for uploading this system. It really hopeful.
How are you there. I managed to update to mysqli. However, I get an error saying unexpected if(IF_IT). Please help.
Please I need your help. I’m using php and MySQL 5.1 and I get an error MySQL deprecated. How can I update to mysqli. Regards, Ken
SAM is pretty critical. This would be immensely helpful to be able to assign software to users and/or devices. Tracking transfer of licenses between user/device also critical. License compliance reporting is very helpful.
I have been trying to get this running but I have not had any luck. I installed LAMP and tested it. I did everything up to Step 6 on the README file that was included.
I do not know where these files are supposed to go.
I put the EAM folder in var/www/html/ because the test files that I used to test apache, php, mysql are there. I assumed that this is where the folder should go but when I try to log in through my browser I get the following message:
“You do not have permission to access /eam/login.php on this server.”
Thanks in advance!
Hi Team,
Everything is working fine. Please help me to achieve the access based on the “admin or editor” . I have tried but unable to do the changes please help me this is my final page . my need is need the code that the access for admin is full and editor is only view. I am very much helpful to get that . Thanks in advance.
Regards
ameerjai
Hi Guys,
The site is awesome and everything is working, facing some issues in retrieving reports. i replaced all mysql to mysqli commands in Reports page. for mysql_mysql_field_name($result, $i)) has been replaced like mysqli_fetch_field_direct($result, $i)).. I am getting below error. Please help me out to resolve this issue…
I am newer to this development, sorry if i anything questioned silly.
( ! ) Warning: stripslashes() expects parameter 1 to be string, object given in C:\wamp\www\eam\ReportsAllInventory.php on line 21
Call Stack
# Time Memory Function Location
1 0.0000 253072 {main}( ) ..\ReportsAllInventory.php:0
2 0.0000 263056 exportMysqlToCsv( ) ..\ReportsAllInventory.php:5
3 0.0000 280360 stripslashes ( ) ..\ReportsAllInventory.php:21
( ! ) Warning: Cannot modify header information – headers already sent by (output started at C:\wamp\www\eam\ReportsAllInventory.php:21) in C:\wamp\www\eam\ReportsAllInventory.php on line 59
Call Stack
# Time Memory Function Location
1 0.0000 253072 {main}( ) ..\ReportsAllInventory.php:0
2 0.0000 263056 exportMysqlToCsv( ) ..\ReportsAllInventory.php:5
3 0.0281 279400 header ( ) ..\ReportsAllInventory.php:59
Thanks
ameerjai
Thanks for the eam is working
However updating may be required to make sure there are no error messages which you fixed with turning errors OFF. (mysql to mysqli) to fix this issue, I have used @MySQL in the connections
Hi Gfisk,
I am getting error while login into the db and clicking Admin page.. Please guide me…..
( ! ) Notice: Undefined index: data in C:\wamp\www\eam\access.php on line 39
Call Stack
# Time Memory Function Location
1 0.0000 254400 {main}( ) ..\access.php:0
– Enterprise Asset Management
Whoops!
Thanks
ameer
i will not able to download the project …please provide me another link or please send it my mail id : satishlangeh@gmail.com
Apologies for the download issue – it’s fixed and good to go.
Is there any fix for the “( ! ) Deprecated: mysql_pconnect()” message? I would rather not suppress PHP errors, as I would like to make some tweaks to the app and want to see any errors that might appear.
I love the app! Thanks!
Dominic George —- you have to find www folder inside WAMP folder and inside www folder make another folder…..you can name whatever you want……like eam or asset. Inside eam or asset folder put all php file including folder also.
http://localhost/eam
or
http://localhost/asset
something like that.
Thank —— Fast Eddie —— i m still working on this project —- some nice layout and adding latest framework, anyway i am trying to convert into mysqli version so that it will support latest php v5 or v6 —–php v7 is coming.
if like my support pls post.
I have installed WAMP 2.5 on my windows 7 64 bit operating system and created the database and admin user but dont know where to place the php files as per the setup guide. Could you please help me…
@Max Oinam your interface design (http://postimg.org/gallery/1lvej5wb8/) looks awesome! I look forward to seeing more of your work. Great job!
download link not working
Can you upload/send a attached photograph code to use.
sorry link not work
try this link (latest update)
http://postimg.org/gallery/1lvej5wb8/
http://postimg.org/gallery/2plcdx3xu/
i am working with new style
here is link—-http://postimg.org/gallery/2plcdx3xu/
Undefined variable and Undefined index——used this code—–error_reporting(E_ALL ^ E_NOTICE);
error_reporting(E_ALL ^ E_DEPRECATED);
used this code——–
Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\xampp\htdocs\eam\config.php———used this code——–
A session had already been started—–if(!isset($_SESSION)){session_start();}
Add this at the top of each php file in your folder.
This will work fine for you as it’s works for me
i keep getting the same error message after i have pasted this code and named my database “eam”, i am now not sure what is the error now,, i am using XAMMP Server
please help guys urgently
where can I find the password to download?
How to download ur IT Asset Management Database? Plz send the link. Can i use it for asset tracking for other items also ? requesting U plz send the link to my mail
Hi I love your tool and installed and i started to using it, the only thing i am missing is that you cannot allocate sofware against multiple users ( e.g. i have have 10 seats for autocad i want to see which user has this software) also i would like to have a table where you can insert (end)users who are using the hard and software is still possible??
Notice: A session had already been started – ignoring session_start() in C:\wamp\www\Asset_management_version1\Asset_management\includes\header.php on line 38
please fixed this error…ty
Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /public_html/Connections/eam.php on line 10
Warning: session_start(): Cannot send session cache limiter – headers already sent (output started at /home/maennerdingorg/public_html/Connections/eam.php:10) in /home/maennerdingorg/public_html/includes/header.php on line 38
Warning: Cannot modify header information – headers already sent by (output started at /home/maennerdingorg/public_html/Connections/eam.php:10) in /home/maennerdingorg/public_html/includes/header.php on line 40
i would pay for a solution!
What a cool stuff! :)
It is possible to Add “costumer” and search into this costumer for specified assets?
Is there any copyright issue if we would like to rename it our company name
Notice: Undefined variable: row_Recordset1 in C:\wamp\www\eam_v3.040313\eam\HardwareAdd.php on line 117
Any chance for a check-in/check-out feature with checkout log?
Thanks for this!
here the screen shot…….
http://postimg.org/gallery/2laz8gka0/
Hellooo……… guys!!
i m working with new style ………. using bootstrap 3.0 , Jquery and must more…..
so guys please make alive this project once again with nice and awesome.
i will update screen shot ….. soon
download link not working
Hi! When I try to download it gives me a “link has expired” file. Is there another download link?
Thank you!
Great job making this free!
on top of Syed_Jahanzaib suggestions could you please add Qty Column also in Add Hardware.
Nice efforts bro, Very good. keep it up.
Some suggestion as mentioned by other use
– Search for Status (Inventory/Deployed/Retired)
– Possibility to add License Keys
– Edit/Add Licensce Type
– Delete Multiple entries
– Sort Lists
– Create a Userlist
– Assign User to Hardware via dropdown menu
– Import User/Hardware
working fine, please update the product for product management.
Download link is fixed, apologies for the issue
Download ling is not working Please guide to me where i can get this software
Thanks Mushrif – another issue with the download software after their major upgrade.
* Until resolved – Download or dismiss the link expired text file then wait aprox 2-3+ minutes and you will be able to download by clicking the download button again.
link is expired
// Enterprise Asset Management – Graham Fisk – BigSmallweb.com – 2012 //
# FileName=”Connection_php_mysql.htm”
# Type=”MYSQL”
# HTTP=”true”
error_reporting(0); // Turn off all error reporting
$hostname_eam = “localhost”; // MYSQL database host adress – do not Change!
$database_eam = “eam”; // MYSQL database name
$username_eam = “eam”; // Mysql Datbase user
$password_eam = “”; // Mysql Datbase password
$eam = mysql_pconnect($hostname_eam, $username_eam, $password_eam) or trigger_error(mysql_error(),E_USER_ERROR);
Thanks for reply. I did it and the error is solved. But when I run, index.php, I get this error “No database Selected”.
eam.php content like below.
Thanks in advance.
@Ziko, it looks like the mysql_pconnect(): extension isn’t fully compatible with MySQL 5.5.0 and higher. https://dev.mysql.com/doc/apis-php/en/apis-php-function.mysql-pconnect.html
I have a quick fix which disables PHP Error Reporting on screen, meanwhile I’ll work for a fix and post an update when I have it.
Quick fix – add this code to line #1 of /Connections/eam.php
< ?php error_reporting(0); // Turn off all error reporting ?>Hi gfisk,
It’s good work. I use the 1-README.txt for configuration but when I start it gives below error.
Thanks in advance.
( ! ) Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\wamp\www\eam\Connections\eam.php on line 10
Call Stack
# Time Memory Function Location
1 0.0025 274936 {main}( ) ..\index.php:0
2 0.0029 277776 require_once( ‘C:\wamp\www\eam\Connections\eam.php’ ) ..\index.php:1
3 0.0030 278528 mysql_pconnect ( ) ..\eam.php:10
No database selected
Thanks Will, a recent update to the file manager broke downloads. Should be good now.
I would love to give this a spin but there is no download link.
Hi gfisk,
Thanks for making a fantastic and useful application. Great work.
I have one quick question if you get a minute. When I export to CSV file, the files are blank when I open them. No information in them at all even though I have lots of records. Not getting any errors, so I’m not sure where to start.
Thanks
Hi,
Thanks for taking the time and making such a useful tool with a very simple interface.
Question I have is that, can we import an existing inventory sheets made in excel into the database and have them show up on the interface.
It’s very tedious to have to manually enter 100+ items one-by-one.
I can tweak the excel sheet to match the fields available but how do I import it?
Thanks.
Looks great! How can we add a “computer name” to an asset? Also, can we assign a user to a computer? What about assigning software to a computer? Its good to know I have 5 seats, but where are they installed?
Will this work on SQL Server Express or Just MYSQL
Can the report export be changed to a different format?
Is there a way to have a data field archived like under computers, (assigned to) so when I have change that data another table has the history so I know who has had it in the past?
Does the downloadable version work with XAMPP?
The app works with PHP and MySQL
PS thanks for the awesome product and your time!!
Hi Mr. Fisk
I have been playing with your code to see if it would be adaptable for my needs. So far it looks pretty good except for the searchResults.php page. I was running into a problem with the pagination that I just couldn’t figure out. I then set up a new subdomain and database and then installed the source again fresh. Rather than change the page row limits, I left everything alone and added more laptop records to bring it over 50. The pagination doesn’t work there but it is perfect in the HardwareList.php. Is there an updated version of searchResults.php?
Hi..
One more suggestion that can we add asset assign and unassigned functionality and also should generate track record of all asset until it disposed in this application than it would be great because normally Laptop’s, Desktop and printers will assign so some of the user’s and now a day’s it’s necessary to know which asset is assigned to whom as a IT Responsible.
it would have been lovely if you can add an image field or space for each asset submited
When I run , login.php , I get this error “No database Selected”
Hi does it come in a different version for not being an it business. I really like this database but I am into electronics, mechanical and marine equipment.
Hi your database would really work for me but infortunatley I am not in It but electronic, mechanical and marine equipment. Would it be possible to change the entering and search fields for our use. I like it because its simple and easy to use for my operators. If possible please contact me urgently. Thank you
@Leo – thank you for the feedback and apologies to all as the Search results page pagination is indeed broken. Sorry I missed that, I’ll work to get an update.
Hi Chris – Thanks for the feedback, if you can add any detail per missing links and pages I can check it out! I’ll look to add column sort capability in any future update. For now you can use the search views to filter by type or export your data and sort in Excel.
is there an updated version of this? it seems like there are some broken links/missing pages?
any way to sort the data on the hardware and software lists.. only showing 50 at a time on those lists, i’d like to sort the individual columns if possible.
Hi, Please ignore my last comment. Figured out how to do most of it now.
The only problem I could not sort yet is:
HardwareList.php Works the way it was designed. List my 399 devices in few pages.
50 item on each page.
javascipt:getsupport(‘Desktop’) This does not work properly
Records 1 to 50 of 117
But I can see only the first page = 50 itens
Page two shows Records 51 to 100 of 117 but no items are displayed.
Page Three shows Records 101 to 117 of 117 but no items are displayed.
Would appreciate any pointers.
Thanks,
Leo
Hi
Would be really great to have a way to modify the Php fields inside of the web front end.
I want to change Serial number to something else…
Any tips would highly appreciated.
Thanks
Leo
Hello Dear,
I think your tutorial save lots my time and it’s easy to understand. Please keep it alwys up . great work done by you. :) :)
Thanks
Rajdip
I’m not sure if I am doing something wrong.
I got my installation running, however there are a heap of tables missing from the database.
Mainly the software tables.
if you could help, that would be fantastic
the project looks great though, good job :)
Thanks
Aidan
Hi Aidan, if you haven’t added any data I would suggested “dropping” all the tables in the database and importing “/Assets/eam.sql” again. If it’s a fresh install make sure you’re not importing the database update file “DatabaseUpdate2-3.sql”
Hi gfisk,
found your script a few days ago.
Looks very good so far.
A few suggestions:
– Search for Status (Inventory/Deployed/Retired)
– Possibility to add License Keys
– Edit/Add Licensce Type
– Delete Multiple entries
– Sort Lists
– Create a Userlist
– Assign User to Hardware via dropdown menu
– Import User/Hardware
regards
Thanks for the feedback IT Guy, all good stuff that time allowing I will look to add in the future.
how to upload csv data
HI Anwar, at this time the only way to import would be via phpMyAdmin or similar database tool. If you’re comfortable with that you can create a CSV file that matches the database tables, populate the file with data and use the import function. You can find many good articles such as this: http://www.group3solutions.com/blog/tips-on-phpmyadmin-csv-importing/
My CSV-reports showing htmal tags. please help
Hi Pemin, not sure what would cause that to happen. Review step 6 in the setup instructions and perhaps try a different browser.
Hi Draco, 1-README.txt in the root of the site. Thanks for highlighting that, I’ve added the information to this page.
I don’t see the 10 step setup document. Where is that to download?
Hi Brijesh – If there’s a compelling reason to create PDFs I can look into it. Exporting to PDF requires additional components such as TCPDF or FPDF and configuration. CSV can be opened by any application, works with Google Docs, MS Excel, Open Office Calc and can be converted to PDF using those apps or free PDF print software such as PDFCreator, BullZip, PDF995 or CutePDF.
It would be great if someone can Generate Report’s in PDF Format instead of csv.
Updated to version 3.0 – bug fixes, PHP 5.3 support, added Asset Tag and Purchase Order fields. Simple upgrade for existing installs.
Hi gfisk,
Can you look at following error and how to overcome it, please reply its is very great project for me, you great support and effort appreciated.
! ) Deprecated: Function session_is_registered() is deprecated in C:\wamp\www\eam\includes\header.php on line 39
Call Stack
# Time Memory Function Location
1 0.0008 417224 {main}( ) ..\index.php:0
2 0.0034 450384 include( ‘C:\wamp\www\eam\includes\header.php’ ) ..\index.php:98
Hi, i use xampp for the webserver and I don’t why i still got an error in the beginning: Fatal error: Call to undefined function session_is_registered() in C:\xampp\htdocs\eam\includes\header.php on line 39
would you please help me? Thank’s
Id like to download this program file using ssh, where do I find the link?
I really like what you have done here. Nice simple interface and out of the box usability. Like some of the other before me have mentioned so updated features would be really nice to see implemented as well.
The HTML reports would be a big one, and the ability to create and generate reports dynamically would be great. I have done this kind of thing more times than I want to count in MS Access, but everybody want their databases web accessible now a days so you are doing well.
& also try to release new version with report printing option & instead of csv please try to fetch report in PDF…
Hi Brijesh – I’ll work to add ‘Asset Tag’ in the next release.
I like to use this application but can we implement to Add some unique no to each asset & we can Print Bar coded Asset Label with unique Asset No,content Make,Model,User,Division & Location , this will help to identifiy the asset easily….
Hi, I keep getting an error when running this script:
Notice: A session had already been started – ignoring session_start() in C:\wamp\www\eam\includes\header.php on line 38
Call Stack
# Time Memory Function Location
1 0.0007 362480 {main}( ) ..\Admin.php:0
2 0.0037 390400 include( ‘C:\wamp\www\eam\includes\header.php’ ) ..\Admin.php:82
3 0.0039 390440 session_start ( ) ..\header.php:38
if you can spare time to help I’d be very grateful.
Regards
Graham