How can one display any potential errors when executing a MySQL query in PHP?

When executing a MySQL query in PHP, it is important to display any potential errors that may occur during the query execution. This can help in debugging and troubleshooting issues with the query. To display errors, you can use the mysqli_error() function in PHP, which returns the error message from the last MySQL operation. 

// Connect to MySQL database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Check connection
if (!$connection) {
    die("Connection failed: " . mysqli_connect_error());
}

// Execute MySQL query
$query = "SELECT * FROM table_name";
$result = mysqli_query($connection, $query);

// Check for errors
if (!$result) {
    die("Error executing query: " . mysqli_error($connection));
}

// Process the query result
while ($row = mysqli_fetch_assoc($result)) {
    // Do something with the data
}

// Close connection
mysqli_close($connection);

Keywords

PHP MySQL error handling mysqli_error mysqli_connect_error

Related Questions