RE: [PHP] mysqli sql question

[Jen Rasmussen]

Peet,

Could you do something like this instead? This is using named placeholders
and a separate line for your statement
but I was able to get it to echo the statement in this manner. 

$sql = "UPDATE table SET field1=:field1, field2=:field2 WHERE id=:id";
                $sth = $dbh->prepare($sql);
                $sth->execute(array(":field1"=>$field1,
                                           ": field2"=>$ field2,
                                           ": id"=>$id));

echo $sql; 

Hope that helps,
Jen

-----Original Message-----
From: Peet Grobler [mailto:p...@hivemind.net] 
Sent: Wednesday, August 31, 2011 4:24 AM
To: php-general@lists.php.net
Subject: [PHP] mysqli sql question

Is it possible to get the actual sql that is being used to query or
update the database?

E.g
$sth = $dbh->prepare ("update table set field=?, field2=? where id=?);
mysqli_bind_param ($sth, 'ssi', 'text1', 'text2', 10);
$sth->execute();

Something like $sth->sql? Or $dbh->sql?

I want to see "update table set field='text1', field2='text2' where id=10;


Thanks in advance,
Peet

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




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