|
Posted by Steve Buehler on 03/16/05 02:31
http://dev.mysql.com/doc/mysql/en/create-table.html
At 03:29 PM 3/15/2005, John Taylor-Johnston wrote:
>How do I get PHP to create a table, if one does not already exist?
>
>I have to do something with:
>
>$news = mysql_query($sql) or die(print mysql_error());
>
>What can I also add something to $sql?
>
>$sql = "if not exists CREATE TABLE `demo_assignment1` ...
>
>John
>
>
>--------snip--------
>
> $server = "localhost";
> $user = "myname";
> $pass = "mypass";
> $db = "mydb";
> $table = "demo_assignment1";
>
>############################################
>## What do I add here?
>############################################
>
>$sql = "CREATE TABLE `demo_assignment1` (
> `StudentNumber` varchar(8) NOT NULL default '',
> `Exercise1` varchar(100) NOT NULL default '',
> `Exercise2` varchar(100) NOT NULL default '',
> `TimeStamp` timestamp(14) NOT NULL,
> PRIMARY KEY (`TimeStamp`)
>) TYPE=MyISAM COMMENT='place something here';";
>
>$myconnection = mysql_connect($server,$user,$pass);
>
>mysql_select_db($db,$myconnection);
>
>############################################
>## What do I do here?
>$news = mysql_query($sql) or die(print mysql_error());
>############################################
>
>
>#if table exists, I will now
>
> $sql = "INSERT INTO $table (StudentNumber,Exercise1,Exercise2)
> values ('$StudentNumber','$Exercise1','$Exercise2')";
> mysql_select_db($db,$myconnection);
> mysql_query($sql) or die(print mysql_error());
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
[Back to original message]
|