DB Creation using PHP mysqli

<?php
$con=mysqli_connect("localhost","root","");
if(!$con){
    die("connection failed".mysqli_connect_error());
   
}
$sql="create database lidiya";
if(mysqli_query($con,$sql)){
    echo "db created";
    }
   
    else{
       
        echo"db not created";
    }

mysqli_close($con);
?>

 // Creating table using php mysqli:

<?php
$con=mysqli_connect("localhost","root","","lidiya");
if(!$con){
    die("db connection failed".mysqli_connect_error());
    }
    $sql="CREATE TABLE MyGuests (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date TIMESTAMP
)";
    if(mysqli_query($con,$sql)){
        echo "table created";
    }
    else{
        echo "table not created";
    }
    mysqli_close($con);
?>