Php > Code Snippets

Creating a table in a MySQL database

Creating 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 (); 
?>