How can PHP developers ensure that a table is successfully created in a database?

To ensure that a table is successfully created in a database using PHP, developers can use the "CREATE TABLE" SQL statement along with the "mysqli_query" function to execute the query. It is important to establish a database connection using mysqli_connect before executing the query. Additionally, developers should handle any potential errors that may occur during the table creation process. 

<?php
// Establishing a connection to the database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Creating a table named "users" with columns
$query = "CREATE TABLE users (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    firstname VARCHAR(30) NOT NULL,
    lastname VARCHAR(30) NOT NULL,
    email VARCHAR(50),
    reg_date TIMESTAMP
)";

// Executing the query to create the table
if (mysqli_query($connection, $query)) {
    echo "Table created successfully.";
} else {
    echo "Error creating table: " . mysqli_error($connection);
}

// Closing the database connection
mysqli_close($connection);
?>

Keywords

PHP MySQL database create table error handling

Related Questions