What are the best practices for structuring if-else statements in PHP when dealing with query results?

When dealing with query results in PHP, it is important to properly structure if-else statements to handle different scenarios such as no results, single result, or multiple results. One common practice is to check if the query returned any results using functions like mysqli_num_rows() and then use if-else statements to handle each case accordingly. 

// Assuming $result is the variable holding the query result

if(mysqli_num_rows($result) == 0) {
    // Handle case when no results are returned
    echo "No results found";
} elseif(mysqli_num_rows($result) == 1) {
    // Handle case when a single result is returned
    $row = mysqli_fetch_assoc($result);
    echo "Result: " . $row['column_name'];
} else {
    // Handle case when multiple results are returned
    while($row = mysqli_fetch_assoc($result)) {
        echo "Result: " . $row['column_name'] . "<br>";
    }
}

Keywords

if-else structuring query results PHP best practices

Related Questions