What are the best practices for handling MySQL connection errors and displaying error messages in PHP scripts?

Handling MySQL connection errors in PHP scripts involves using try-catch blocks to catch exceptions thrown by the database connection. It is important to display meaningful error messages to the user to help troubleshoot any issues. Using the mysqli_connect_errno() and mysqli_connect_error() functions can provide detailed information about the error. 

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

try {
    $conn = new mysqli($servername, $username, $password, $dbname);
    if ($conn->connect_error) {
        throw new Exception("Connection failed: " . $conn->connect_error);
    }
    // Continue with database operations
} catch (Exception $e) {
    echo "Error: " . $e->getMessage();
}
?>

Keywords

MySQL connection errors error messages PHP scripts handling

Related Questions