PDO fetch and fetchAll with conditional statement not working

Question

his is not working can anyone help please?

(count($stmt->fetchAll()) > 1) ? $result = $stmt->fetchAll() : $result = $stmt->fetch();

print_r($result);

this is more proper way. `$result = (count($stmt->fetchAll()) > 1) ? ($stmt->fetchAll()) : ($stmt->fetch());` — jagad89, Jun 20 '15 at 13:32
Thanks for the suggestion, but this doesn't solves my problem. — Abdul Moiz, Jun 20 '15 at 13:36
See the answer by Mureinik below. it has reason for why its not working. — jagad89, Jun 20 '15 at 13:38

score 2 · Accepted Answer · answered Jun 20 '15 at 13:32

2

All the fetchXYZ methods advance the underlying cursor, so once you've called them, you cannot "go back" and get the same rows again.

You could redo your condition in-memory, after calling fetchAll() only once:

$result = $statement->fetchAll();
if (count($result) == 1) {
    $result = $result[0];
}

answered Jun 20 '15 at 13:32

Mureinik

1 Answers1