How can the PHP code be modified to ensure successful creation of the "News" table in MySQL?

The issue can be solved by ensuring that the SQL query for creating the "News" table is executed successfully. This can be achieved by checking if the query execution was successful and displaying any errors that may occur during the process. Additionally, it is important to establish a connection to the MySQL database before running the query. 

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "dbname";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

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

// SQL query to create "News" table
$sql = "CREATE TABLE News (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(100) NOT NULL,
    content TEXT NOT NULL,
    published_at TIMESTAMP
)";

// Execute SQL query
if ($conn->query($sql) === TRUE) {
    echo "Table News created successfully";
} else {
    echo "Error creating table: " . $conn->error;
}

// Close connection
$conn->close();
?>

Keywords

PHP MySQL table creation SQL query error handling

Related Questions