How can errors related to mysqli_num_rows() and mysqli_fetch_assoc() be resolved in PHP?

The issue with mysqli_num_rows() and mysqli_fetch_assoc() typically arises when the query result is not properly checked before attempting to fetch data. To resolve this, you should first check if the query was successful using mysqli_num_rows() and then fetch the data using mysqli_fetch_assoc() only if there are rows returned. 

// Check if the query was successful
if ($result = mysqli_query($connection, $query)) {
    // Check if there are rows returned
    if (mysqli_num_rows($result) > 0) {
        // Fetch and display the data
        while ($row = mysqli_fetch_assoc($result)) {
            // Process the data here
        }
    } else {
        echo "No results found.";
    }
} else {
    echo "Error executing query: " . mysqli_error($connection);
}

Keywords

mysqli_num_rows mysqli_fetch_assoc PHP error handling troubleshooting

Related Questions