What are the recommended error handling techniques in PHP when dealing with database queries to provide meaningful feedback to the user?

When dealing with database queries in PHP, it is important to implement error handling techniques to provide meaningful feedback to the user in case of any issues. One common technique is to use try-catch blocks to catch any exceptions that may occur during the query execution and display a user-friendly error message. Additionally, utilizing functions like mysqli_error() or PDOException->getMessage() can provide more detailed information about the error.

try {
    // Perform database query
    $result = mysqli_query($conn, "SELECT * FROM users");
    
    if (!$result) {
        throw new Exception(mysqli_error($conn));
    }
    
    // Process query results
    while ($row = mysqli_fetch_assoc($result)) {
        // Display data to the user
    }
} catch (Exception $e) {
    echo "An error occurred: " . $e->getMessage();
}