[RESOLVED] Creating a php file to creat tables in a DB

[big-dog]

How do I get this to creat tables in mysql. If I goto phpMyAdmin I can use import and Import the .sql file and work fime, but I need to use a php file instead.
I got the table code from phpMyAdmin by doing a sql command then it had a link to make php code to me both codes look the same, but any way how do I creat a php file from this.

<?php // Install table

include('settings.php');

CREATE TABLE IF NOT EXISTS `Class_Alias_Cla` (
  `Cla_Act` tinyint(1) NOT NULL,
  `Cla_PK` int(4) NOT NULL,
  `Cla_Cl_PK` int(4) NOT NULL,
  `Cla_F_Name` char(50) NOT NULL,
  KEY `Cls_Key` (`Cla_PK`),
  KEY `ClsA_Cls_Key` (`Cla_Cl_PK`),
  KEY `ClsA_Ful_Name` (`Cla_F_Name`),
  KEY `PrimaryKey` (`Cla_PK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `DB_Dir_Loc` (
  `DirLoc_Act` tinyint(1) NOT NULL,
  `DirLoc_Key` int(4) NOT NULL,
  `DirLoc_ID` char(15) NOT NULL,
  `DirLoc_Dir` char(255) NOT NULL,
  `DirLoc_Desc` char(255) NOT NULL,
  KEY `DirLoc_ID` (`DirLoc_ID`),
  KEY `DirLoc_Key` (`DirLoc_Key`),
  KEY `PrimaryKey` (`DirLoc_Key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `DB_REMINDER` (
  `Reminder_ID` int(4) NOT NULL,
  `Reminder_Note` char(255) NOT NULL,
  `Reminder_Expires` datetime NOT NULL,
  `Reminder_Database` char(15) NOT NULL,
  `Reminder_Run_Sched` char(15) NOT NULL,
  `Reminder_Run_Day` char(15) NOT NULL,
  KEY `ID` (`Reminder_ID`),
  KEY `PrimaryKey` (`Reminder_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `Driver_Alias_Da` (
  `Da_Act` tinyint(1) NOT NULL,
  `Da_PK` int(4) NOT NULL,
  `Da_D_PK` int(4) NOT NULL,
  `Da_Alias` char(25) NOT NULL,
  `Da_First` char(25) NOT NULL,
  `Da_Mid` char(25) NOT NULL,
  `Da_Last` char(25) NOT NULL,
  `Da_Nick` char(25) NOT NULL,
  `Da_Gen_By` char(20) NOT NULL,
  KEY `DrvA_Alias` (`Da_Alias`),
  KEY `DrvA_Drv_ID` (`Da_D_PK`),
  KEY `DrvA_First` (`Da_First`),
  KEY `DrvA_ID` (`Da_PK`),
  KEY `DrvA_Last` (`Da_Last`),
  KEY `DrvA_Mid` (`Da_Mid`),
  KEY `DrvA_Nick` (`Da_Nick`),
  KEY `PrimaryKey` (`Da_PK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `Driver_Classes_Dcl` (
  `Dcl_Act` tinyint(1) NOT NULL,
  `Dcl_PK` int(4) NOT NULL,
  `Dcl_D_PK` int(4) NOT NULL,
  `Dcl_Cl_PK` int(4) NOT NULL,
  `Dcl_Frq_PK` int(4) NOT NULL,
  `Dcl_Vhl_PK` int(4) NOT NULL,
  `Dcl_TrnsPond` char(7) NOT NULL,
  `Dcl_Car_No` int(4) NOT NULL,
  KEY `Drv_Cls_Key` (`Dcl_PK`),
  KEY `Drv_Key` (`Dcl_D_PK`),
  KEY `PrimaryKey` (`Dcl_PK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `Driver_D` (
  `D_Act` tinyint(1) NOT NULL,
  `D_PK` int(4) NOT NULL,
  `D_Pcft_PK` int(4) NOT NULL,
  `D_Dg_PK` int(4) NOT NULL,
  `D_Last` char(20) NOT NULL,
  `D_Mid` char(20) NOT NULL,
  `D_First` char(20) NOT NULL,
  `D_Nick` char(20) NOT NULL,
  `D_Street` char(50) NOT NULL,
  `D_Street2` char(50) NOT NULL,
  `D_Box` char(4) NOT NULL,
  `D_City` char(20) NOT NULL,
  `D_State` char(3) NOT NULL,
  `D_Zip` char(5) NOT NULL,
  `D_Home` char(11) NOT NULL,
  `D_Cell` char(11) NOT NULL,
  `D_Work` char(11) NOT NULL,
  `D_Email` char(60) NOT NULL,
  `D_Bday` datetime NOT NULL,
  `D_Roar_Mbr` tinyint(1) NOT NULL,
  `D_Roar` char(15) NOT NULL,
  `D_Club_Mbr` tinyint(1) NOT NULL,
  `D_Club` char(15) NOT NULL,
  `D_Club_Expire` datetime NOT NULL,
  `D_First_Race` datetime NOT NULL,
  `D_Last_Race` datetime NOT NULL,
  `D_Opt_In` tinyint(1) NOT NULL,
  `D_Gate` tinyint(1) NOT NULL,
  `D_Created` datetime NOT NULL,
  `D_Comment` char(200) NOT NULL,
  KEY `Drv_Key` (`D_PK`),
  KEY `Drv_Mid` (`D_Mid`),
  KEY `PrimaryKey` (`D_PK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `Driver_Group_Dg` (
  `D_Act` tinyint(1) NOT NULL,
  `Dg_PK` int(4) NOT NULL,
  `Dg_F_Name` char(25) NOT NULL,
  `Dg_S_Name` char(10) NOT NULL,
  `Dg_Sub_Group` char(10) NOT NULL,
  KEY `Dg_S_Name` (`Dg_S_Name`),
  KEY `Dg_Sub_Group` (`Dg_Sub_Group`),
  KEY `DrvGrp_Key` (`Dg_PK`),
  KEY `DrvGrp_Name` (`Dg_F_Name`),
  KEY `PrimaryKey` (`Dg_PK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `Driver_History_Dh` (
  `Dh_Act` tinyint(1) NOT NULL,
  `Dh_PK` int(4) NOT NULL,
  `Dh_D_PK` int(4) NOT NULL,
  `Dh_Pc_PK` int(4) NOT NULL,
  `Dh_Cl_PK` int(4) NOT NULL,
  `Dh_Type` char(1) NOT NULL,
  `Dh_Place` int(4) NOT NULL,
  `Dh_Avg_Time` char(50) NOT NULL,
  `Dh_Best_Time` char(50) NOT NULL,
  `Dh_Laps` int(4) NOT NULL,
  `Dh_Cash_Won` int(4) NOT NULL,
  `Dh_Trophy` char(50) NOT NULL,
  `Dh_Points` int(4) NOT NULL,
  `Dh_TQ_Points` int(4) NOT NULL,
  `Dh_Part_Points` int(4) NOT NULL,
  `Dh_Heats_Cmplt` int(4) NOT NULL,
  `Dh_Heats_Top_Place` int(4) NOT NULL,
  `Dh_Heats_Avg_Time` char(50) NOT NULL,
  `Dh_Heats_Best_Time` char(50) NOT NULL,
  `Dh_Comments` char(255) NOT NULL,
  KEY `Rslt_Drv_Key` (`Dh_D_PK`),
  KEY `Rslt_Pnt_Ctl_Key` (`Dh_Pc_PK`),
  KEY `PrimaryKey` (`Dh_PK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `Driver_Relationships_Dr` (
  `Dr_Act` tinyint(1) NOT NULL,
  `Dr_PK` int(4) NOT NULL,
  `Dr_D_PK` int(4) NOT NULL,
  `Dr_R_D_PK` int(4) NOT NULL,
  `Dr_Rt_PK` int(4) NOT NULL,
  KEY `DriverDriver_Relationships` (`Dr_D_PK`),
  KEY `DrvRel_Drv_Key` (`Dr_D_PK`),
  KEY `DrvRel_Drv_Key1` (`Dr_R_D_PK`),
  KEY `DrvRel_Key` (`Dr_PK`),
  KEY `PrimaryKey` (`Dr_PK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `Driver_Relationships_Type_Drt` (
  `Drt_Act` tinyint(1) NOT NULL,
  `Drt_PK` int(4) NOT NULL,
  `Drt_Desc` char(25) NOT NULL,
  KEY `RelType_Key` (`Drt_PK`),
  KEY `PrimaryKey` (`Drt_PK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `Freq_Frq` (
  `Frq_PK` int(4) NOT NULL,
  `Frq_Chan` char(4) NOT NULL,
  `Frq_MHz` char(8) NOT NULL,
  `Frq_MHZ_Rg` char(3) NOT NULL,
  `Frq_Type` char(15) NOT NULL,
  `Frq_Color` char(15) NOT NULL,
  `Frq_License` char(3) NOT NULL,
  `Frq_Comment` char(255) NOT NULL,
  KEY `Frequency MHz` (`Frq_MHz`),
  KEY `PrimaryKey` (`Frq_PK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
TRUNCATE TABLE `Freq_Frq`;
REPLACE `Freq_Frq` (`Frq_PK`, `Frq_Chan`, `Frq_MHz`, `Frq_MHZ_Rg`, `Frq_Type`, `Frq_Color`, `Frq_License`, `Frq_Comment`) VALUES
(1, 'A1', '26.995', '27', 'All', 'Brown', 'No', ''),
(2, 'A2', '27.045', '27', 'All', 'Red', 'No', ''),
(3, 'A3', '27.095', '27', 'All', 'Orange', 'No', ''),
(4, 'A4', '27.145', '27', 'All', 'Yellow', 'No', ''),
(5, 'A5', '27.195', '27', 'All', 'Green', 'No', ''),
(6, 'A6', '27.255', '27', 'All', 'Blue', 'No', ''),
(7, '00', '50.800', '50', 'AirCraft', NULL, 'No', ''),
(8, '01', '50.820', '50', 'AirCraft', NULL, 'No', ''),
(9, '02', '50.840', '50', 'AirCraft', NULL, 'No', ''),
(10, '2.4G', 'DSM', 'All', 'Any', NULL, 'No', '2.4g Manual select frequancy');

CREATE TABLE IF NOT EXISTS `Import_LapFree` (
  `RecID` int(4) NOT NULL,
  `F1` char(255) NOT NULL,
  `F2` char(255) NOT NULL,
  `F3` char(255) NOT NULL,
  `F4` char(255) NOT NULL,
  `F5` char(255) NOT NULL,
  `F6` char(255) NOT NULL,
  `F7` char(255) NOT NULL,
  KEY `RecID` (`RecID`),
  KEY `PrimaryKey` (`RecID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `Models_Vhl` (
  `Vhl_Act` tinyint(1) NOT NULL,
  `Vhl_PK` int(4) NOT NULL,
  `Vhl_Cl_PK` int(4) NOT NULL,
  `Vhl_Mfg` char(50) NOT NULL,
  `Vhl_Model` char(50) NOT NULL,
  `Vhl_Eng` char(50) NOT NULL,
  `Vhl_Style` char(50) NOT NULL,
  `Dh_Heats_Avg_Time` char(50) NOT NULL,
  KEY `Vhl_Mfg` (`Vhl_Mfg`),
  KEY `PrimaryKey` (`Vhl_PK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `Name AutoCorrect Log` (
  `Object Type` char(255) NOT NULL,
  `Object Name` char(255) NOT NULL,
  `Control Name` char(255) NOT NULL,
  `Property Name` char(255) NOT NULL,
  `Old Value` char(255) NOT NULL,
  `New Value` char(255) NOT NULL,
  `Time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

echo "Tables installed correctly";

?>

[Weedpacket]

Put each statement in a separate mysql_query() command.

[big-dog]

Worked ok till it got to the REPLACE partUnable to complete table installation" You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REPLACE Freq_Frq (Frq_PK, Frq_Chan, Frq_MHz, Frq_MHZ_Rg, Frq_Type, `' at line 13

$create_table = mysql_query("CREATE TABLE IF NOT EXISTS `Freq_Frq` (
  `Frq_PK` int(4) NOT NULL,
  `Frq_Chan` char(4) NOT NULL,
  `Frq_MHz` int(6) NOT NULL,
  `Frq_MHZ_Rg` char(3) NOT NULL,
  `Frq_Type` char(15) NOT NULL,
  `Frq_Color` char(15) NOT NULL,
  `Frq_License` char(3) NOT NULL,
  `Frq_Comment` char(255) NOT NULL,
  KEY `Frequency MHz` (`Frq_MHz`),
  KEY `PrimaryKey` (`Frq_PK`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
REPLACE `Freq_Frq` (`Frq_PK`, `Frq_Chan`, `Frq_MHz`, `Frq_MHZ_Rg`, `Frq_Type`, `Frq_Color`, `Frq_License`, `Frq_Comment`) VALUES
(1, 'A1', '26.995', '27', 'All', 'Brown', 'No', ''),
(2, 'A2', '27.045', '27', 'All', 'Red', 'No', ''),
(3, 'A3', '27.095', '27', 'All', 'Orange', 'No', ''),
(4, 'A4', '27.145', '27', 'All', 'Yellow', 'No', ''),
(5, 'A5', '27.195', '27', 'All', 'Green', 'No', ''),
(6, 'A6', '27.255', '27', 'All', 'Blue', 'No', ''),

[djjjozsi]

Hi!
if you truncate that table Freq_Frq in the previous query, i think you sould only use a normal INSERT statement instead of REPLACE.

Hello, jjozsi

[Weedpacket]

big-dog wrote:

Worked ok till it got to the REPLACE part

But notice that there's still one CREATE TABLE statement in there.

[big-dog]

THANKS FOR THE HELP

 echo '<p>Creating table Driver_Relationships_Type_Drt';
if(!$result = mysql_query('CREATE TABLE IF NOT Exists Driver_Relationships_Type_Drt ( Drt_Act  TINYINT(1) NOT NULL  DEFAULT 1 , Drt_PK  INT NOT NULL  AUTO_INCREMENT  , Drt_Desc VARCHAR(25), PRIMARY KEY (Drt_PK) )')) { echo ' Error creating Table ' . mysql_error(); }

 echo '<p>Creating table Freq_Frq';
if(!$result = mysql_query('CREATE TABLE IF NOT Exists Freq_Frq ( Frq_PK  INT NOT NULL  AUTO_INCREMENT  , Frq_Chan VARCHAR(5) , Frq_MHz VARCHAR(15) , Frq_MHZ_Rg VARCHAR(5) , Frq_Type VARCHAR(15) , Frq_Color VARCHAR(15) , Frq_License VARCHAR(5) , Frq_Comment VARCHAR(255), PRIMARY KEY (Frq_PK) )')) { echo ' Error creating Table ' . mysql_error(); }

 echo '<p>Inserting data into table Freq_Frq';
 mysql_query('INSERT INTO Freq_Frq VALUES ( 
"", NULL,"SPECTRUM","","All", NULL,"No","Automaticly seeks an open channel")');
mysql_query('INSERT INTO Freq_Frq VALUES ( 
"", NULL,"DSM","75","Surface", NULL,"No","Manual select frequancy")');
mysql_query('INSERT INTO Freq_Frq VALUES ( 
"","A1","26.995","27","All","Brown","No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES ( 
"","A2","27.045","27","All","Red","No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES ( 
"","A3","27.095","27","All","Orange","No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES ( 
"","A4","27.145","27","All","Yellow","No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES ( 
"","A5","27.195","27","All","Green","No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES ( 
"","A6","27.255","27","All","Blue","No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","00","50.800","50","AirCraft", NULL,"No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","01","50.820","50","AirCraft", NULL,"No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","02","50.840","50","AirCraft", NULL,"No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","03","50.860","50","AirCraft", NULL,"No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","04","50.880","50","AirCraft", NULL,"No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","05","50.900","50","AirCraft", NULL,"No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","06","50.920","50","AirCraft", NULL,"No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","07","50.940","50","AirCraft", NULL,"No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","08","50.960","50","AirCraft", NULL,"No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","09","50.980","50","AirCraft", NULL,"No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","11","72.010","72","AirCraft", NULL,"No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","12","72.030","72","AirCraft", NULL,"No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","13","72.050","72","AirCraft", NULL,"No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","14","72.070","72","AirCraft", NULL,"No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","15","72.090","72","AirCraft", NULL,"No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","16","72.110","72","AirCraft", NULL,"No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","17","72.130","72","AirCraft", NULL,"No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","18","72.150","72","AirCraft", NULL,"No",NULL )');
mysql_query('INSERT INTO Freq_Frq VALUES (
"","19","72.170","72","AirCraft", NULL,"No",NULL )');
 echo '<p>Creating table Sponsor_Sup_Spns';
if(!$result = mysql_query('CREATE TABLE IF NOT Exists Sponsor_Sup_Spns ( SpnS_Act  TINYINT(1) NOT NULL  , SpnS_PK  INT NOT NULL  AUTO_INCREMENT  , SpnS_Spn_PK  INT DEFAULT 0 , SpnS_Trk_PK  INT DEFAULT 0 , SpnS_Tm_PK  INT DEFAULT 0 , SpnS_Rating  INT DEFAULT 0 , SpnS_Created DATETIME , SpnS_Last_Donate DATETIME , SpnS_Amount  FLOAT DEFAULT 0 , SpnS_Amt_Desc VARCHAR(200), PRIMARY KEY (SpnS_PK) )')) { echo ' Error creating Table ' . mysql_error(); }

 echo '<p>Creating table State';
if(!$result = mysql_query('CREATE TABLE IF NOT Exists State ( State VARCHAR(25) , Abbr VARCHAR(5),KEY State(State) )')) { echo ' Error creating Table ' . mysql_error(); }

echo '<p>Inserting data into table State';
mysql_query('INSERT INTO State VALUES (
"ALABAMA","AL" )');
mysql_query('INSERT INTO State VALUES (
"ALASKA","AK" )');
mysql_query('INSERT INTO State VALUES (
"ARIZONA","AZ" )');
mysql_query('INSERT INTO State VALUES (
"ARKANSAS","AR" )');
mysql_query('INSERT INTO State VALUES (
"CALIFORNIA","CA" )');
mysql_query('INSERT INTO State VALUES (
"COLORADO","CO" )');

[/SIZE]