What is the recommended way to handle empty result sets in PHP when using mysql_fetch_array?

When using mysql_fetch_array in PHP to fetch results from a MySQL database, it is important to handle empty result sets properly to avoid errors. One recommended way to handle empty result sets is to check if there are any rows returned before trying to fetch data. This can be done by using mysql_num_rows to determine the number of rows in the result set. 

// Connect to the database
$conn = mysqli_connect("localhost", "username", "password", "dbname");

// Perform a query
$result = mysqli_query($conn, "SELECT * FROM table");

// Check if there are any rows returned
if (mysqli_num_rows($result) > 0) {
    // Fetch data from the result set
    while ($row = mysqli_fetch_array($result)) {
        // Process the data
    }
} else {
    // Handle empty result set
    echo "No results found.";
}

// Close the connection
mysqli_close($conn);

Keywords

PHP mysql_fetch_array empty result sets error handling data retrieval

Related Questions