检查while循环输出查询中的任何数据

Question

$query=$db->prepare("SELECT *...
while($data=$query->fetch(PDO::FETCH_ASSOC)){...}

I have a query use while loop print out the data.

How can I check if while loop didn't fetch out any data(0 row from db), so I can print "0 result" on screen.

I don't want to make extra query for COUNT(*), is any way do check from while loop?

Answer 1

Just put a flag inside the loop to ensure you entered at least once.

Something like:

$flag = false;
$query=$db->prepare("SELECT *...");
while($data=$query->fetch(PDO::FETCH_ASSOC)){
    $flag = true;
}
if ($flag) {} //entered

Added semicolon, thanks @Fred -ii