This is the install information for DataTrack Contact database available at:

http://www.crockerwebdesign.com

------------------------------------------------------------


DataTrack Install Information

Required software:

Follow the included instructions to install these programs on your platform.

A valid installation of PHP 4.0.0 or higher
Download from - : http://www.php.net/

A valid installation of MySQL 3.22.34 or higher
Download from - http://www.mysql.com/

Apache or IIS server running
Download HTTP Server Apache from - http://www.apache.org/


DataTrack Installation

Place all of the DataTrack files in the folder you are using for your web pages.

Make sure your installation of Apache or IIS is running

Make sure MySQL has been started.

If you have a new install of PHP make sure it is working correctly by accessing the phpinfo.php file using your web browser. This file is included in the DataTrack file bundle. If your installation is valid, a screen will appear with the version number of PHP you have along with more information.

Look in the list of PHP core settings if "register_globals is set to off you will need to change it.

In your "php.ini" file make sure "register_globals = on" by default this will be set to "off" simply change it to the word "on" and save your changes.  It is turned off for security reasons which are of lesser concern for an Intranet situation.

If PHP is running correctly we can then take the next step and configure the MySQL database.

Create a new database

Use the text file “structure_for_contact.sql" to create the table “imagetrack”

PHP MyAdmin is a good way to do this.


Add a user to the newly created database

Make sure you reload / restart MySQL

Open the mysql_connect.php file with a text editor.

Make the required changes to these lines:


DEFINE ('DB_USER', 'username');
DEFINE ('DB_PASSWORD', 'password');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'contact');


Change the text between the apostrophes to whatever you used.

Change the password in authen.php to whatever you wish.

You can make a bunch of other changes here as well, do that later though after you get it working.

Access the folder in your web browser; hopefully it will display the page.  If you get a connect error check your changes again.


If you are using PHP MyAdmin use the includued file "structure_for_contact.sql"

Or you can cut and paste this text into a query.



The following text will create the needed table:

------------------------------------------------------

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Apr 16, 2006 at 01:18 PM
-- Server version: 4.0.25
-- PHP Version: 4.3.11
-- 
-- Database: `username_contact`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `imagetrack`
-- 

CREATE TABLE `imagetrack` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `subject` text,
  `event` text,
  `location` text,
  `rating` text,
  `description` text,
  `path` text,
  `link` text,
  `date` timestamp(14) NOT NULL,
  `cell` text,
  `notes` text,
  `fax` text,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=24 ;