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

When working with MySQL result resources in PHP, it is important to properly handle them to avoid memory leaks and improve performance. It is best practice to free up the result resources after you are done using them by using the mysqli_free_result() function. This will release the memory associated with the result set and improve the overall efficiency of your application.

// Execute a query and store the result in a variable
$result = mysqli_query($conn, "SELECT * FROM table");

// Process the result set

// Free up the result set
mysqli_free_result($result);