How to create table in mysql db using php

CREATE TABLE

This command is used to create table in mysql

Synatx

CREATE TABLE TABLENAME (filedname1 datatype(length),fieldname2 datatype(length),...)

<?php
$servername = "localhost";
$username = "root";
$password = "";
$db="db";


$conn =  mysqli_connect($servername, $username, $password,$db);


if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}


$sql = "CREATE TABLE udetails (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    umail VARCHAR(30) NOT NULL,
    upass VARCHAR(50) NOT NULL,vcode INT(10),verified INT(1),attempts INT(6)
    )";
   
    if ($conn->query($sql) === TRUE) {
        echo "Table udetails created successfully";
    } else {
        echo "Error creating table: " . $conn->error;
    }
   
    $conn->close();
?>