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

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(); Something

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 already

RE: [PHP] mysqli sql question

2011-08-31 Thread 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);