// 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);
?>