php pdo fetchAll is empty but rowCount show

Asked Oct 24 '18 at 15:37

Active Oct 24 '18 at 17:24

Viewed 150 times

this is my code:

$pdo = new PDO($dsn, $user, $pass);
$q = "SELECT C1,C2,C3 FROM table";
$stmt = $pdo->query($q);
$nums = $stmt->rowCount();

echo "Count: ".$nums."<br>";
$erg = $stmt->fetchAll();
print_r($erg)

And the result is:

Count: 972<br>
Array()

And I have absolutly no idea what's wrong. RowCount is correct. I use same in an other project where it works as expected, and I can't see any difference.

Any idea what an how to check?

Thanks

edited Oct 24 '18 at 17:24

RiggsFolly

93,638
21
103
149

asked Oct 24 '18 at 15:37

Fabian Knauf

1

Why not just get the row count from `count($erg);` – RiggsFolly Oct 24 '18 at 15:40
1

Also: Read the first section of [The PDO Manual](http://php.net/manual/en/pdostatement.rowcount.php) Where it says `rowCount()` is not guaranteed to work on a SELECT – RiggsFolly Oct 24 '18 at 15:43
What database are you using? @RiggsFolly I believe it does work with MySQL, for instance. – Barmar Oct 24 '18 at 16:06
Is that really the whole script? If you have any other `fetch` or `fetchAll()` calls between `rowCount()` and `fetchAll()` the rows that they fetch will not be returned by the later `fetchAll()`. – Barmar Oct 24 '18 at 16:09
@RiggsFolly Also, he says that `rowCount` *is* returning the correct value, it's `fetchAll()` that's wrong. – Barmar Oct 24 '18 at 16:11
Yes that's the whole script. – Fabian Knauf Oct 24 '18 at 16:28
Database is a Sybase Anywhere 9 and doing the select on the database returns excatly the same number of records as rowCount shows. But neither fetch or fetchAll returns any line. – Fabian Knauf Oct 24 '18 at 16:30
So have you tried the query from the command line or whatever tool you use for sybase similiar to `phpMyAdmin` And if so how many rows does that return in the resultset – RiggsFolly Oct 24 '18 at 17:26
Have you tried passing obj param? $erg = $stmt->fetchAll(PDO::FETCH_OBJ); – Niall Lonergan Oct 25 '18 at 08:02
@Niall: yes - no change – Fabian Knauf Oct 26 '18 at 07:44
And I tried $pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false); No option as Sybase PDO driver does not support this – Fabian Knauf Oct 26 '18 at 07:45
@Riggs: yes I tried with Sybase isql-Tool. It returns same number of rows and the dataset – Fabian Knauf Oct 26 '18 at 07:46
Try wrapping it in execute? if($stmt->execute()){ if($stmt->rowCount() > 0){ $erg = $stmt->fetchAll(PDO::FETCH_OBJ); } } – Niall Lonergan Oct 26 '18 at 08:07

php pdo fetchAll is empty but rowCount show

0 Answers0