How can error reporting in PHP be utilized to troubleshoot database connection issues?

When troubleshooting database connection issues in PHP, error reporting can be utilized to provide detailed information about any errors that occur during the connection process. By enabling error reporting and displaying error messages, developers can identify the specific issue that is preventing the database connection from being established. This information can then be used to make the necessary adjustments to the database configuration or connection settings to resolve the problem.

<?php
// Enable error reporting to display any connection errors
error_reporting(E_ALL);
ini_set('display_errors', 1);

// Database connection settings
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";

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

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