Holografix wrote:
Hi. When using this example from
http://netevil.org/talks/index.php?t=pdos=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
Hi. When using this example from
http://netevil.org/talks/index.php?t=pdos=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
Hi Marek
It's print_r($row), not print_r($stmt) ;)
Marek Kilimajer [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
Holografix wrote:
Hi. When using this example from
http://netevil.org/talks/index.php?t=pdos=20, the site of pdo's author I
have this error:
Fatal error:
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
Holografix wrote:
Hi Marek
It's print_r($row), not print_r($stmt) ;)
That's what I'm asking - If you put print_r($stmt) in that line, what
does it print?
Marek Kilimajer [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
Holografix wrote:
Hi. When using this example
print_r($stmt) prints nothing. print($stmt) print nothing too.
I checked errorCode() and it prints .
Marek Kilimajer [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
Holografix wrote:
Hi Marek
It's print_r($row), not print_r($stmt) ;)
That's what I'm asking - If you put
Holografix wrote:
print_r($stmt) prints nothing. print($stmt) print nothing too.
I checked errorCode() and it prints .
Then it seems $stmt is false. var_dump() is more verbose about it.
Marek Kilimajer [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
Holografix wrote:
Yes, you're right. It's false
This dont't work too.
foreach ($dbh-query('SELECT * FROM words') as $row) {
echo $row['word'] . br;
}
But this works
$stmt = $dbh-prepare('select * from words');
$stmt-execute();
$rows = $stmt-fetchAll();
echo count($rows) . brbr;
Marek Kilimajer [EMAIL
Hi. When using this example from
http://netevil.org/talks/index.php?t=pdos=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',
9 matches
Mail list logo