It's rudimentary, but is a stable and very basic data collection framework.

First you start with WAMP. I assume you're going to be running this under a Windows platform.

For 32 bit:
http://www.wampserver.com/en/#wampserver-32-bits-php5-3
Patch: http://www.microsoft.com/download/en/details.aspx?id=8328

For 64 bit:
http://www.wampserver.com/en/#wampserver-64-bits-php-5-3
Patch: http://www.microsoft.com/download/en/details.aspx?id=13523

The patch is needed because if you don't have certain frameworks already installed, it throws errors. The wampserver.com site has an extensive forum that explains nearly everything.

Once you've got that up and running... :D

You'll make a database (mine was named brands, so those code references will need to be changed to yours) and then a table within your database (mine is called test). I called my database user test as well, but you don't need to.

You'll open up the SQL window in phpMyAdmin and copy the text in from the sql_dump.txt file. This will create a test database. Before you modify anything to the way you want it, install everything as given so it's easier to troubleshoot. WAMP set up can be a bit titchy. (Note that I've changed all the file names to preface with dcf_ and end with .txt. You should change them once you download them.)

Then copy the index_test.php and zzzz.php files into the root of the www directory. Once everything's running well, you can rename both the file and the link within that file (at the end of the page) to just plain index.php. It will be OK to remove any other test files at that point. The zzzz.php page is your connection string. It's set up for test and for the local data connection. Once everything's working, then you can change it from test.

Navigating to http://localhost/ or http:/127.0.0.1/ at this point should show you the default page from the WAMP set up. (This will change once you're done.) Make sure to set the server to be "online".

From the system tray icon, you'll want to navigate to your php.ini file. I've included the php.ini.txt file - this is the configuration file from a 64 bit installation. If you want to use a merge tool like kdiff3 to compare the differences that makes it easier.

However, there are some settings that need to be activated from the menu. These are documented in the php_settings.jpg file.

Now you'll open the MySQL command window. Log in with whatever default password you've set. It's a development environment, so you can configure it to be no password at all (this was configured during initial set up). Depends on the security levels you need to enforce in your environment. Dev set ups tend to be low on passwords so as to speed up the delivery of code... You'll have set a password and user name within phpMyAdmin for the database you've created, but due to some quirks within WAMP you'll need to go into the console and run these statements (one line at at time):

SET PASSWORD FOR 'brands'@'localhost' = PASSWORD('brands');
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('');
GRANT ALL PRIVILEGES ON *.* TO 'brands'@'localhost' IDENTIFIED BY 'brands' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '' WITH GRANT OPTION;

Change wherever it says brands to be the name of your database. I named my database brands and also made the user name and password be brands as well, so if you have a different password, where the first statement says PASSWORD ('brands') then you'll want to change that to be the password you selected.

At this point, you'll restart WAMP - very easy to do from the tray icon. Once it turns green again, you can select localhost from the top of the menu, and test the code to ensure it works without errors. Once it does, save a copy of your settings and code off to the side, then make any modifications you need to.

Once you acquire the data you want, then it's relatively easy to go into phpMyAdmin and using the Export tab, export your accumulated data in a variety of formats to be imported into your main database.