PHP MySQL based Product Management System.

• PHP based system to manage data product
• Records updates to keep track of data products
• Lightweight client designed in HTML and PHP

Beta 0.1.0

For Windows / Linux users

• MySQL
• PHP
• Apache

For Windows users package of all called XAMPP

• XAMPP

1. Folder: database_architecture

   • csredataproducts.sql

2. Folder: toposheet

   • Folder: protection (From: http://www.zubrag.com/) folder to manage login roles.
   • Folder style

1. Easy to configure.
2. Suitable for small / medium workload.

1. File based authentication (not advisible for very sensitive information).
2. Passwords stored in plain text.

Install and configure MySQL, PHP and Apache web server (PHPMyAdmin will help).

After successful installation proceed with following.

A. Database configuration

• Create MySQL database by using csredataproducts.sql

> mysql -u your_user - p < csredataproducts.sql

• Check the database

> mysql -u your_user -p 
> show databases;

It will list all databases.
Now check for "csredataproducts". If available proceed.

• Check tables

> use csredataproducts;
> show tables;

It will list all tables from csredataproducts.
If  dataproduct and user table are listed. 
Database configuration complete

• Optional (Create new user in MySQL with read write permissions).

B. Web configuration

• Copy toposheet folder into web folder (WAMPP: htdocs/, LAMPP: var/www/)
• Modify login.php to add database configurations

C. System check

In browser type URL

http://localhost/toposheet
or 
your_web_host:port/toposheet

D. Modifications

• Add pages (HTML / PHP) scripts to modify the system
• Change styles.css to change webpage colors, etc.
• Change images from styles folder

• Add product remove capability.
• Modify display according to date.

CC