Question

How to create a MySQL Table Using MySQLi in PHP

Answer 1

$db_host        = 'localhost';
$db_user        = 'root';
$db_password    = '';
$db_name        = 'allonpage';

$con = new mysqli("localhost", $db_user, $db_password , $db_name);

if (mysqli_connect_errno()) 
{
    printf("Connection Error: %s\n", mysqli_connect_error());
    exit();
}

$con->query("CREATE TABLE Worker
             (
                WorkerID int,
                LastName varchar(255),
                FirstName varchar(255)
             );");

echo "Affected rows : " . $con->affected_rows;

$con->close();


/*
run: 

Affected rows : 0 

*/

 

70+ SQL courses for beginners and professionals

Answer 2

$db_host        = 'localhost';
$db_user        = 'root';
$db_password    = '';
$db_name        = 'allonpage';

$con = new mysqli("localhost", $db_user, $db_password , $db_name);

if (mysqli_connect_errno()) 
    die("Connection Error: " . mysqli_connect_error() . "<br />");

$sql = "CREATE TABLE Worker
        (
           WorkerID int,
           LastName varchar(255),
           FirstName varchar(255)
        );";

if ($con->query($sql) === TRUE)
    echo "Table created successfully";
else 
    echo "Error creating table: " . mysqli_error($con);

$con->close();


/*
run: 

Table created successfully

*/

 

70+ SQL courses for beginners and professionals