RE: [PHP] mysqli sql question

2011-08-31 Thread Jen Rasmussen
--- 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 s

Re: [PHP] mysqli sql question

2011-08-31 Thread Peet Grobler
On 8/31/2011 1:38 PM, John Black wrote: > Hi Peet, > > not sure if there is a method to echo the sql but you can set your > development MySQL server to log all queries to a log file. > Use the log file with tail and you'll get a live view of all queries the > server attempts to process. > I alre

Re: [PHP] mysqli sql question

2011-08-31 Thread James Yerge
On 08/31/2011 05:23 AM, Peet Grobler wrote: > 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(); > > S

Re: [PHP] mysqli sql question

2011-08-31 Thread John Black
On 31.08.2011 11:23, Peet Grobler wrote: 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 $st

[PHP] mysqli sql question

2011-08-31 Thread Peet Grobler
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 "updat