PHP MySQL Create Tables

In this tutorial, we will show you how to use PHP to create MySQL database table.

The following are the steps to show you how to create a new table in a database:

• Open a database connection to the MySQL database server.
• Execute the CREATE TABLE statement to create new tables.

<?php

/* Attempt MySQL server connection. Assuming you are running MySQL

server with default setting (user 'root' with no password) */

$link = mysqli_connect("localhost", "sa", "", "demo");

 

// Check connection

if($link === false){

    die("ERROR: Could not connect. " . mysqli_connect_error());

}

 

// Attempt create table query execution

$sql = "CREATE TABLE persons(

    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,

    first_name VARCHAR(30) NOT NULL,

    last_name VARCHAR(30) NOT NULL,

    email VARCHAR(70) NOT NULL UNIQUE

)";

if(mysqli_query($link, $sql)){

    echo "Table created successfully.";

} else{

    echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);

}

 

// Close connection

mysqli_close($link);

?>