What are the best practices for handling single or multiple search results in PHP scripts?

When handling single or multiple search results in PHP scripts, it is important to check if any results were returned before attempting to access them. For single results, you can directly access the elements of the result. For multiple results, you should loop through each result and process them accordingly. 

// Check if any results were returned
if ($result) {
    // For single result
    if (count($result) == 1) {
        $singleResult = $result[0];
        // Process single result
    } else {
        // For multiple results
        foreach ($result as $row) {
            // Process each result
        }
    }
} else {
    echo "No results found.";
}

Keywords

SQL MySQL PDO fetch result set

Related Questions