Creating a table in a MySQL database

This shows how to create a table in a MySQL database

<?php
//connect to your MySQL server using your servername , username
//and password
$conn = mysql_connect(“localhost” , “username” , “password”);
//if you cannot connect display an error message and exit
if ($conn == false)
{
echo mysql_errno().”: “.mysql_error().”<BR>”;
exit;
}
//create a table called contact , this will contain 2 fields .
//fullname to store a name and email to store an email address
$query = “create table contact” .
“(fullname varchar(255), email varchar(255))”;
//store this in $result variable
$result = mysql_db_query (“mydb”, $query);
//if successful display this message
if ($result)
echo “Table ‘mydb’ was successfully created!”;
//if unsuuccessful display the error message
else
echo mysql_errno().”: “.mysql_error().”<BR>”;
mysql_close ();
?>

LEAVE A REPLY

Please enter your comment!
Please enter your name here

*