How can the "or die()" function in PHP be used effectively to handle errors in database queries?

When executing database queries in PHP, it's important to handle potential errors that may occur during the query execution. One way to do this is by using the "or die()" function in PHP, which allows you to display an error message and terminate the script if the query fails. This can help in debugging and identifying issues with database queries. 

// Establish a connection to the database
$connection = mysqli_connect("localhost", "username", "password", "database");

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

// Execute a query and handle potential errors
$query = "SELECT * FROM table";
$result = mysqli_query($connection, $query) or die("Query failed: " . mysqli_error($connection));

// Process the query result
while ($row = mysqli_fetch_assoc($result)) {
    // Process each row
}

// Close the database connection
mysqli_close($connection);

Keywords

PHP or die() database queries error handling MySQL

Related Questions