To create a table in a MySQL database using MySQLi in PHP, you need to follow these steps:

1. Connect to the MySQL database.

2. Write the SQL query to create a table.

3. Execute the query.

4. Check if the table creation was successful.

Here’s an example demonstrating how to create a table in PHP using MySQLi.

1. Create a Table Using MySQLi (Procedural Approach)

<?php// Database connection parameters$host = "localhost";$username = "root";$password = "";$dbname = "test"; // Database where the table will be created// Create connection$conn = mysqli_connect($host, $username, $password, $dbname);// Check connectionif (!$conn) {    die("Connection failed: " . mysqli_connect_error());}// SQL query to create a new table$sql = "CREATE TABLE users (    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,    name VARCHAR(100) NOT NULL,    email VARCHAR(100) NOT NULL,    reg_date TIMESTAMP)";// Execute the queryif (mysqli_query($conn, $sql)) {    echo "Table 'users' created successfully";} else {    echo "Error creating table: " . mysqli_error($conn);}// Close the connectionmysqli_close($conn);?>

2. Create a Table Using MySQLi (Object-Oriented Approach)

<?php// Database connection parameters$host = "localhost";$username = "root";$password = "";$dbname = "test"; // Database where the table will be created// Create connection$conn = new mysqli($host, $username, $password, $dbname);// Check connectionif ($conn->connect_error) {    die("Connection failed: " . $conn->connect_error);}// SQL query to create a new table$sql = "CREATE TABLE users (    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,    name VARCHAR(100) NOT NULL,    email VARCHAR(100) NOT NULL,    reg_date TIMESTAMP)";// Execute the queryif ($conn->query($sql) === TRUE) {    echo "Table 'users' created successfully";} else {    echo "Error creating table: " . $conn->error;}// Close the connection$conn->close();?>

Explanation:

1. Database Connection:

   • You connect to your MySQL database using either the procedural function mysqli_connect() or the object-oriented class new mysqli().

   • The parameters are: hostname, username, password, and dbname.

2. SQL Query:

   • The SQL query "CREATE TABLE users (...)" creates a table named users with the following columns:

     • id: An auto-increment integer that serves as the primary key.

     • name: A string column for storing user names.

     • email: A string column for storing email addresses.

     • reg_date: A timestamp column that records the time when the record was created.

3. Executing the Query:

   • The query is executed using either mysqli_query() (procedural) or $conn->query() (object-oriented).

   • If the table is created successfully, a success message is displayed. If there's an error (e.g., if the table already exists), the error message is shown.

4. Closing the Connection:

   • After the query is executed, it’s good practice to close the database connection using mysqli_close() (procedural) or $conn->close() (object-oriented).

Important Notes:

• If the table already exists and you run the same CREATE TABLE query again, it will throw an error. To avoid this, you can use the IF NOT EXISTS clause in the query:

CREATE TABLE IF NOT EXISTS users (    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,    name VARCHAR(100) NOT NULL,    email VARCHAR(100) NOT NULL,    reg_date TIMESTAMP)

• You should ensure that you have the necessary privileges to create tables in the database.

Let me know if you need further details or adjustments!