Creating a mysql table with php

[big-dog1965]

How do I make a PHP file creat this table in mysql. If I put this directly into sql it creats the table but I want a php file to do it by running it in the browser.

<?php
CREATE TABLE `wichita_frgn1`.`Registrations` ( `id` int( 10 ) unsigned NOT NULL auto_increment ,
`First_Name` text NOT NULL ,
`Last_Name` text NOT NULL ,
`Address` text NOT NULL ,
`City` text NOT NULL ,
`State` text NOT NULL ,
`Zip_Code` text NOT NULL ,
`Home_Phone` text NOT NULL ,
`Cell_Phone` text NOT NULL ,
`E_Mail` text NOT NULL ,
`Membership_No` text NOT NULL ,
`Roar_No` text NOT NULL ,
`First_Class` text NOT NULL ,
`Transmitter_Frequency` text NOT NULL ,
`Transponder_No` text NOT NULL ,
`Track_Transponder` text NOT NULL ,
`Second_Class` text NOT NULL ,
`Transmitter_Frequency2` text NOT NULL ,
`Transponder_No2` text NOT NULL ,
`Track_Transponder2` text NOT NULL ,
`Ability_Skill_Level` text NOT NULL ,
`Race_Date` date NOT NULL default '0000-00-00',
`Track` text NOT NULL ,
`IP_Address` text NOT NULL ,
`Date_Posted` text NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `id_2` ( `id` ) ,
KEY `id` ( `id` ) ) ENGINE = MyISAM DEFAULT CHARSET = latin1 COMMENT = 'Created by Big-Dog;
?>

[djr33]

<?php
$host = 'localhost'; //or url
$user = 'me';
$pass = 'pass'; //note this is secure on your server in the php file
$conn = mysql_connect($host,$user,$pass);
$query = 'CREATE TABLE .... STUFF';
mysql_query($query);
?>http://www.php.net/manual/en/function.mysql-connect.php

[big-dog1965]

I get this error
Parse error: syntax error, unexpected T_LNUMBER in /home/public_html/Registration/creattable.php on line 28
which is `Race_Date` date NOT NULL default '0000-00-00',

<?php
$username="MYUSER";
$password="MYPASS";
$database="MYDB";

$conn = mysql_connect(localhost,$username,$password);
$query = 'CREATE TABLE `wichita_frgn`.`Registrations` ( `id` int( 10 ) unsigned NOT NULL auto_increment ,
`First_Name` text NOT NULL ,
`Last_Name` text NOT NULL ,
`Address` text NOT NULL ,
`City` text NOT NULL ,
`State` text NOT NULL ,
`Zip_Code` text NOT NULL ,
`Home_Phone` text NOT NULL ,
`Cell_Phone` text NOT NULL ,
`E_Mail` text NOT NULL ,
`Membership_No` text NOT NULL ,
`Roar_No` text NOT NULL ,
`First_Class` text NOT NULL ,
`Transmitter_Frequency` text NOT NULL ,
`Transponder_No` text NOT NULL ,
`Track_Transponder` text NOT NULL ,
`Second_Class` text NOT NULL ,
`Transmitter_Frequency2` text NOT NULL ,
`Transponder_No2` text NOT NULL ,
`Track_Transponder2` text NOT NULL ,
`Ability_Skill_Level` text NOT NULL ,
`Race_Date` date NOT NULL default '0000-00-00',
`Track` text NOT NULL ,
`IP_Address` text NOT NULL ,
`Date_Posted` text NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `id_2` ( `id` ) ,
KEY `id` ( `id` ) ) ENGINE = MyISAM DEFAULT CHARSET = latin1 COMMENT = 'Created by big dog'
';
mysql_query($query);
?>


[MOD EDIT: DO NOT POST SENSITIVE DATA!! Removed. We don't need the exact password, etc. to help you and it is a HUGE security risk...]

[tech_support]

You need to escape the quotes first.


<?php
$username="*****************"; //Replace the asterisks with your username.
$password="*****************"; //Replace the asterisks with your password.
$database="*****************"; //Replace the asterisks with your database.

$conn = mysql_connect(localhost,$username,$password);
$query = 'CREATE TABLE `wichita_frgn`.`Registrations` ( `id` int( 10 ) unsigned NOT NULL auto_increment ,
`First_Name` text NOT NULL ,
`Last_Name` text NOT NULL ,
`Address` text NOT NULL ,
`City` text NOT NULL ,
`State` text NOT NULL ,
`Zip_Code` text NOT NULL ,
`Home_Phone` text NOT NULL ,
`Cell_Phone` text NOT NULL ,
`E_Mail` text NOT NULL ,
`Membership_No` text NOT NULL ,
`Roar_No` text NOT NULL ,
`First_Class` text NOT NULL ,
`Transmitter_Frequency` text NOT NULL ,
`Transponder_No` text NOT NULL ,
`Track_Transponder` text NOT NULL ,
`Second_Class` text NOT NULL ,
`Transmitter_Frequency2` text NOT NULL ,
`Transponder_No2` text NOT NULL ,
`Track_Transponder2` text NOT NULL ,
`Ability_Skill_Level` text NOT NULL ,
`Race_Date` date NOT NULL default \'0000-00-00\',
`Track` text NOT NULL ,
`IP_Address` text NOT NULL ,
`Date_Posted` text NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE KEY `id_2` ( `id` ) ,
KEY `id` ( `id` ) ) ENGINE = MyISAM DEFAULT CHARSET = latin1 COMMENT = 'Created by big dog'
';
mysql_query($query);
?>

[djr33]

You must escape quotes of the same type as those surrounding the string, ie:

'don\'t';

Add a backslash before those offending quotes around the 00-000-00 thing.

[big-dog1965]

now I get
Parse error: syntax error, unexpected T_STRING in /home/public_html/Registration/creattable.php on line 34
which is
KEY `id` ( `id` ) ) ENGINE = MyISAM DEFAULT CHARSET = latin1 COMMENT = 'Created by big dog'

[djr33]

That line needs to be escaped as well.

[Twey]

Perfect for a heredoc:
$query = <<<EOQ
CREATE TABLE
`wichita_frgn1`.`Registrations` (
`id` int( 10 ) unsigned NOT NULL auto_increment,
`First_Name` text NOT NULL,
`Last_Name` text NOT NULL,
`Address` text NOT NULL,
`City` text NOT NULL,
`State` text NOT NULL,
`Zip_Code` text NOT NULL,
`Home_Phone` text NOT NULL,
`Cell_Phone` text NOT NULL,
`E_Mail` text NOT NULL,
`Membership_No` text NOT NULL,
`Roar_No` text NOT NULL,
`First_Class` text NOT NULL,
`Transmitter_Frequency` text NOT NULL,
`Transponder_No` text NOT NULL,
`Track_Transponder` text NOT NULL,
`Second_Class` text NOT NULL,
`Transmitter_Frequency2` text NOT NULL,
`Transponder_No2` text NOT NULL,
`Track_Transponder2` text NOT NULL,
`Ability_Skill_Level` text NOT NULL,
`Race_Date` date NOT NULL default '0000-00-00',
`Track` text NOT NULL,
`IP_Address` text NOT NULL,
`Date_Posted` text NOT NULL,
PRIMARY KEY ( `id` ),
UNIQUE KEY `id_2` ( `id` ),
KEY `id` ( `id` )
)
ENGINE = MyISAM
DEFAULT CHARSET = latin1
COMMENT = 'Created by Big-Dog'
EOQ;
?>

[big-dog1965]

THANKS
I got it to work