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
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
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
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);
4 matches
Mail list logo