What are common issues with MySQL connections in PHP scripts?

One common issue with MySQL connections in PHP scripts is not closing the connection after the query is executed. This can lead to resource leaks and potentially slow down the server. To solve this issue, always remember to close the MySQL connection using the `mysqli_close()` function after executing your queries.

// Establish connection
$mysqli = mysqli_connect("localhost", "username", "password", "database");

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

// Execute query
$sql = "SELECT * FROM table";
$result = mysqli_query($mysqli, $sql);

// Close connection
mysqli_close($mysqli);