|
|
Posted by "Holografix" on 10/21/80 11:21
Hi Georgi
From php manual:
PDO::query
Executes an SQL statement, returning a result set as a PDOStatement object
()
object PDO::query ( string statement )
So, $stmt shoul be an object.
Thanks four your answers.
I will post a more detailed message in php-db where this problem belongs. My
fault posted it in php-general.
Greetings
"Georgi Ivanov" <joro@abacustrade.com> escreveu na mensagem
news:200507151222.16331.joro@abacustrade.com...
>> 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]
|