|
Posted by Georgi Ivanov on 10/21/36 11:21
> Hi. When using this example from
> http://netevil.org/talks/index.php?t=pdo&s=20, the site of pdo's author I
> have this error:
>
> Fatal error: Call to a member function fetchAll() on a non-object in
> /www/home/testes/pdo_my1.php on line 17
>
>
Object creation :
> $dbh = new PDO('mysql:host=localhost;dbname=dbtest', 'user', 'pass');
> $stmt = $dbh->query("SELECT * FROM foo");
Here I think $stmt is NOT an object.
$stmp should be RESOURCE or boolean value most likely.
So it should be $rows=$dbh->fetchAll();
> $rows = $stmt->fetchAll();
> $count = count($rows);
> foreach ($rows as $row) {
> print_r($row);
> }
> $stmt = null;
>
> Wht's wrong with the example?
>
> Greetings
> holografix
--
Regards
Georgi Ivanov
Navigation:
[Reply to this message]
|