Friday, 16 August 2013

Creating multiple tables in php

Creating multiple tables in php

So I put together this functions to create everything I need to run my
stuff, and it doesn't work. Doesn't throw an error, just doesn't work.
Each query was tested, and they all work, but when combined they don't.
Here's the entire code I'm trying to run
<?php
$dbloc = "localhost";
$dbname = "databasename";
$dbuser = "databaseuser";
$dbpass = "databasepass";
$create = mysql_connect($dbloc, $dbuser, $dbpass);
mysql_select_db($dbname,$create);
function buildDB() {
$sql1 = "CREATE TABLE IF NOT EXISTS company (
ID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(ID),
CompanyName VARCHAR(256),
HomePage VARCHAR(1024),
AboutUs VARCHAR(2048),
Facebook VARCHAR(256),
Twitter VARCHAR(256),
CompanyMail VARCHAR(128),
Feedback1Provider VARCHAR(128),
Feedback1 VARCHAR(1024),
Feedback2Provider VARCHAR(128),
Feedback2 VARCHAR(1024),
Feedback3Provider VARCHAR(128),
Feedback3 VARCHAR(1024),
Color VARCHAR(32))";
$sql2 = "CREATE TABLE IF NOT EXISTS data (
ID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(ID),
FirstName VARCHAR(64),
LastName VARCHAR(64),
Email VARCHAR(128),
ProductName VARCHAR(128),
ProductPriceUSD DECIMAL(20,0),
ProductPriceEUR DECIMAL(20,0),
ProductLink VARCHAR(128),
CustomerUser VARCHAR(128),
CustomerPass VARCHAR(36),
CustomerPrice INT(10),
Status VARCHAR(64),
Contacted DATE,
SevenDays DATE,
ToDo VARCHAR(32),
Agent VARCHAR(64),
Added DATETIME,
Modified DATETIME,
ProductsSold VARCHAR(20))";
$sql3 = "CREATE TABLE IF NOT EXISTS earning (
ID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(ID),
User VARCHAR(32),
Month VARCHAR(16),
Cash VARCHAR(50))";
$sql4 = "CREATE TABLE IF NOT EXISTS emails (
ID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(ID),
Subject VARCHAR(256),
Content VARCHAR(1024),
Type VARCHAR(32))";
$sql5 = "CREATE TABLE IF NOT EXISTS exchange (
ID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(ID),
Exchange VARCHAR(10))";
$sql6 = "CREATE TABLE IF NOT EXISTS links (
ID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(ID),
ClientEmail VARCHAR(128),
Links VARCHAR(256),
LinkStatus VARCHAR(64) DEFAULT 'Online')";
$sql7 = "CREATE TABLE IF NOT EXISTS users (
ID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(ID),
mail VARCHAR(128),
fullname VARCHAR(128),
phone VARCHAR(128),
username VARCHAR(60),
password VARCHAR(60),
type VARCHAR(32))";
MySQL_QUERY;
return mysql_query($sql1) && mysql_query($sql2) && mysql_query($sql3)
&& mysql_query($sql4) && mysql_query($sql5) && mysql_query($sql6) &&
mysql_query($sql7);
}
?>
What's wrong with it? When I put private before the function it was
throwing an error, so I removed it. No errors, but doesn't do anything.

No comments:

Post a Comment