I want to print PHP query with parameters

Question

I have the following code

$name = 'myname';
$mail = 'my@mail.it';
$qwt = "INSERT INTO `agenz` (`name`, `email`) VALUES (?,?)";
$result = $connessione->prepare($qwt);
$result->bind_param('ss', $name, $mail); 
$result->execute();

I want print the query

"INSERT INTO `agenz` (`name`, `email`) VALUES ('myname','my@mail.it')"

for creating a log.So how to do that?

thanx.

Possible duplicate of [How can I get the SQL of a PreparedStatement?](https://stackoverflow.com/questions/2382532/how-can-i-get-the-sql-of-a-preparedstatement) — CBroe, Jun 07 '17 at 10:19
May be [this](http://www.dummies.com/programming/php/how-to-display-php-variable-values/) will be helpfull — Sharad Gautam, Jun 07 '17 at 10:22
***If it's `mysqli` then you can't do it***. why? check below links:-[How can I get the SQL of a PreparedStatement?](https://stackoverflow.com/a/2382561/4248328)AND [Is there any way to print the actual query that mysqli->execute() makes?](https://stackoverflow.com/questions/2691707/is-there-any-way-to-print-the-actual-query-that-mysqli-execute-makes)AND[How to echo a MySQLi prepared statement?](https://stackoverflow.com/questions/962986/how-to-echo-a-mysqli-prepared-statement) — Alive to die - Anant, Jun 07 '17 at 14:49

lalithkumar · Answer 1 · 2017-06-07T10:49:51.157

2

Try fullQuery like below:

$name = 'myname';
$mail = 'my@mail.it';
$qwt = "INSERT INTO `agenz` (`name`, `email`) VALUES (?,?)";
$result = $connessione->prepare($qwt);
$result->bind_param('ss', $name, $mail); 
$result->execute(); 

echo $result->fullQuery;

or

$result->debugQuery();
var_dump($result->debugBindedVariables());

if you want to get the error

var_dump($result->errno);

edited Jun 07 '17 at 10:49

answered Jun 07 '17 at 10:23

lalithkumar

3,480
4
24
40

Tnx! If i use echo $result->fullQuery; i have an error Notice: Undefined property: mysqli_stmt::$fullQuery – Sonia Ghizzoni Jun 07 '17 at 10:40
$result->errorCode(); if you use this will get the statement error details – lalithkumar Jun 07 '17 at 10:54
tnx Fatal error: Call to undefined method mysqli_stmt::errorCode() I want print the exact query! – Sonia Ghizzoni Jun 07 '17 at 10:59
did you come out from this problem? @Sonia Ghizzoni – lalithkumar Jun 07 '17 at 12:17
@lalithkumar i think no. he didn't – Alive to die - Anant Jun 07 '17 at 12:22
Yes $connessione is correct! The code work fine! I have the error on echo $result->fullQuery; – Sonia Ghizzoni Jun 07 '17 at 12:22
welcome...you can accept the answer if solved your problem@Sonia Ghizzoni – lalithkumar Jun 07 '17 at 12:23
Fatal error: Call to undefined method PDOStatement::debugQuery() – Jhonattan Feb 04 '20 at 22:36

score 1 · Answer 2 · answered Jun 08 '17 at 08:26

I have solved!

  $qwt = "INSERT INTO `age` (`name`,`email`) VALUES (?,?)";
  $par = array($name, $mail);

  $result = $connessione->prepare($qwt);
  $result->bind_param('ss', $par[0], $par[1]); 
  $result->execute();

  echo "contenuto: " .SqlDebug($qwt, $par); 

  function SqlDebug($raw_sql, $params=array())
  {
  $keys = array();
  $values = $params;  
  foreach ($params as $key => $value)
  {
    // check if named parameters (':param') or anonymous parameters ('?') are    used
    if (is_string($key)) { $keys[] = '/:'.$key.'/'; }
    else                 { $keys[] = '/[?]/'; }
    // bring parameter into human-readable format
    if (is_string($value))    { $values[$key] = "'" . $value . "'"; }
    elseif (is_array($value)) { $values[$key] = implode(',', $value); }
    elseif (is_null($value))  { $values[$key] = 'NULL'; }
  }
  $raw_sql = preg_replace($keys, $values, $raw_sql, 1, $count);
  return $raw_sql;
  }

score 0 · Answer 3 · answered Jun 07 '17 at 10:33

0

You can use variable directly in the statement like following

$name="ABC";
$mail="me@someone.com";
$value= "I am $name mail id $mail";

answered Jun 07 '17 at 10:33

Sharad Gautam

91
5
11

I want to print PHP query with parameters

3 Answers3