What are best practices for handling MySQL result resources in PHP?

When working with MySQL result resources in PHP, it is important to properly free up the resources after you are done using them to prevent memory leaks and improve performance. The best practice is to always free the result resource using the mysqli_free_result() function after you have finished fetching the data from the result set. 

// Connect to MySQL database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Query the database
$result = mysqli_query($connection, "SELECT * FROM table");

// Fetch data from the result set
while ($row = mysqli_fetch_assoc($result)) {
    // Process the data
}

// Free the result resource
mysqli_free_result($result);

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

Keywords

MySQL result resources PHP memory management error handling

Related Questions