how to check, if there are still rows left from fetch_assoc loop?

Question

I loop trough the rows with this code:

while ($row = $result->fetch_assoc()) {
    //...
}

But how is it possible before the mysqli_fetch_assoc to check if there will be a next record, or not? I mean, like: $result->hasNext()

Answer 1

Check the total number of returned rows using $mysqli->num_rows, then compare it to a counter in your loop that you increment with each loop iteration.

$row_cnt = $result->num_rows;
$loop_ct = 0;
while($row = $result->fetch_assoc()) {
    if(++$loop_ct < $row_cnt) {
        //do something
    }
} 

Answer 2

I prefer working efficiently and don't write extra code if it isn't needed. The following will work just fine:

$cnt = $result->num_rows;
while($row = $result->fetch_assoc()){
    //....
    $cnt--;
    if($cnt == x){ //Where x is the number you want
        //....
    }
}