How to obtain the SQL statement after prepare

{Code...} Then {code ...}

$ Db = new PDO (); $… = $ db-> prepare ('SQL'); // you can obtain the execution SQL using a method similar to getSql =

Then

$ Db = new PDO (); $… = $ db-> prepare ('select * from 'table' where p1 =: p1 limit: limit '); $ something-> bindValue (': p1', $ var_p1, PDO: PARAM_INT); $ something-> bindValue (': limit ', $ var_limit, PDO: PARAM_INT ); # ^ This is correct. $……> execute (array (intval ($ var_p1), intval ($ var_limit); # ^ indicates a gross error ?, In execute, can it be converted to int? Must I specify a binding type?

Reply content:

$ Db = new PDO (); $… = $ db-> prepare ('SQL'); // you can obtain the execution SQL using a method similar to getSql =

Then

$ Db = new PDO (); $… = $ db-> prepare ('select * from 'table' where p1 =: p1 limit: limit '); $ something-> bindValue (': p1', $ var_p1, PDO: PARAM_INT); $ something-> bindValue (': limit ', $ var_limit, PDO: PARAM_INT ); # ^ This is correct. $……> execute (array (intval ($ var_p1), intval ($ var_limit); # ^ indicates a gross error ?, In execute, can it be converted to int? Must I specify a binding type?

Not the type of problem, take a closer look at the document: http://cn2.php.net/manual/zh/pdostatement.execute.php

You must use the question mark placeholder when calling the prepare method like execute. Since the "colon parameter name" method is used, the array passed during execute must also use the colon parameter name as the array subscript.

In addition, do you want to obtain the SQL statement that replaces the placeholder with the actual parameter value? PDO cannot be implemented because prepared statement is essentially a temporary stored procedure.