Leads and Contacts Database is a PHP and Mysql system for keeping track of contacts and leads, it was setup for a Real Estate professional but can be used for anything.
With this PHP interface you can Add, Edit, Search, Delete, Sort, and flag individual entries. This tool is opensource, meaning you can add to or change anything you want with it. If you add a feature or make an improvement please post it here for others as well, since this is a functional version but could be built upon to add features. I started with this because a lot of the other ones I came across had too much extra junk for my purposes, so I tried to make a more streamlined version.
Here is a screenshot of the main interface with individual’s information blocked out.
Here is a screenshot of the Add an entry interface
And a screenshot of the View entry interface
*Instructions for Leads and Contacts Management*
This interface is meant for your typical LAMP system (Linux Apache Mysql and PHP), if you want to install it on something
else have fun, but you might have to do things a little different.
1. Download the contact_management.zip file from scripthat.com
2. uncompress it in a directory of your choice, making sure apache is aware of it (ex /var/www/html/)
3. Make sure php and mysql are installed, preferably more recent versions, you can check with commands:
php -v
PHP 5.2.8 (cli) (built: Dec 15 2008 19:32:14)
Copyright (c) 1997-2008 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
with the ionCube PHP Loader v3.1.32, Copyright (c) 2002-2007, by ionCube Ltd., and
with Zend Extension Manager v1.2.2, Copyright (c) 2003-2007, by Zend Technologies
with Zend Optimizer v3.3.3, Copyright (c) 1998-2007, by Zend Technologies
mysql –version
mysql Ver 14.12 Distrib 5.0.51a, for redhat-linux-gnu (i686) using readline 5.0
and should get results similar to the above (that’s what my system is running).
4. Change the variables to suit your system in the contact_db.pl file for accessing mysql.
5. Load the table fields for contacts into your database using phpmyadmin or commandline with the table_contacts.txt.
6. Point your webbrowser to the location of the contact_management.php script, if you wanted you could also rename it to
index.php.
7. You can also import some fields from outlook using the import.pl file if you’d like, you might want to modify the perl
script to your needs. Since everyone uses outlook contacts differently I didn’t spend much time to make the database like it and tried to make it just import important things like names, address, city state, phone #’s, emails etc.
8. At this point you should be able to add, edit, delete and view new entries in the database from the web interface.
If you have any questions, improvements, suggestions please post them.