Re: PDO Error
| From: | Holografix | Date: | Fri, 15 Jul 2005 10:31:02 +0000 |
| Subject: | Re: PDO Error | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-218732@lists.php.net to get a copy of this message | ||
Hi Marek
It's print_r($row), not print_r($stmt) ;)
"Marek Kilimajer" <lists@kilimajer.net> escreveu na mensagem
news:42D75E0F.8020203@kilimajer.net...
> Holografix wrote:
>> 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
>>
>>
>> $dbh = new PDO('mysql:host=localhost;dbname=dbtest', 'user',
>> 'pass');
>> $stmt = $dbh->query("SELECT * FROM foo");
>
> what does print_r($stmt); print here?
>
>> $rows = $stmt->fetchAll();
>> $count = count($rows);
>> foreach ($rows as $row) {
>> print_r($row);
>> }
>> $stmt = null;
>>
>> Wht's wrong with the example?
>>
>> Greetings
>> holografix
>>