//Connnection propertis
session_start();
session_destroy();
$host = "localhost";
$user = "--";
$sqlpw = "--";
$db = "--";
$table = "shop";
$username = $_POST['username'];
$password = $_POST['password'];
$password_md5 = md5($password);
$connection = mysql_connect($host, $user, $sqlpw) or die ("Database is currently offline");
mysql_select_db($db, $connection) or die ("Cannot establish connection with the database");
$createTableProduct =
"CREATE TABLE shopProduct
(
pid int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(pid),
name text,
description text,
dateDay int(2),
dateMonth int(2),
dateYear int(2),
price int(20),
category int(2)
)";
$createTableCategory =
"CREATE TABLE shopCategory
(
cid int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(cid),
name tinytext
)";
mysql_query($createTableProduct);
mysql_query($createTableCategory);
?>