Is it necessary to check the count of results against the specified limit in PHP?

When querying a database in PHP and specifying a limit on the number of results to retrieve, it is important to check the count of the actual results returned against the specified limit. This is necessary to ensure that the query is working as expected and not returning more results than intended. By comparing the count of results to the specified limit, you can handle cases where the query may have returned more results than expected and take appropriate action.

// Perform a database query with a specified limit
$query = "SELECT * FROM table LIMIT 10";
$result = mysqli_query($connection, $query);

// Check the count of actual results against the specified limit
if(mysqli_num_rows($result) > 10) {
    // Handle case where more results were returned than expected
    echo "Query returned more results than the specified limit";
} else {
    // Process the results as normal
    while($row = mysqli_fetch_assoc($result)) {
        // Handle each row of results
    }
}