Example how to create MySQLi table with PHP

<?php
    // create connection
    $server = "server IP address";
    $uname = "username";
    $passw = "password";
    $conn = mysqli_connect($server, $uname, $passw); 
    if (!$conn) die ("Connection failed:" . mysqli_connect_error()); // error if not connected

    // create table
    $sql = "CREATE TABLE table_name (
    id INT(6) UNSIGNED AUTOINCREMENT PRIMARY KEY,
    firstname VARCHAR(64) NOT NULL,
    lastname VARCHAR(64) NOT NULL";
    if (mySQLi_query($conn, $sql)) {
        echo "Table created successfully...";
    }
    else {
        echo "Problems creating the table!";
    }
?>