Re: PDO Error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux