Get query back from MYSQLi prepared statement

Question

My prepared statement looks like this:

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
echo "Connected successfully";

// prepare and bind
$stmt = $conn->prepare("INSERT INTO `devices` (`deviceName`, `type`, `deviceToken`) VALUES (?, ?, ?)");
$stmt->bind_param("sss", $deviceName, $deviceToken, $type);
$stmt->execute();
echo "executed";
$result = $stmt->get_result();
$conn->close();

And I want to echo the query. I know the PDO method:

$binded_query = $stmt->queryString

But I need to use MYSQLi.
So how can I do that?

What does the output look like if you do a print_r($result); ? — Brogan, May 16 '16 at 07:20
http://stackoverflow.com/questions/962986/how-to-echo-a-mysqli-prepared-statement — Alan Tan, May 16 '16 at 07:23
@AlanTan I did it once but I can't find that code anywhere... — Ace, May 16 '16 at 07:24
Can you try this statement instead? "INSERT INTO devices (deviceName, type, deviceToken) VALUES ('?', '?', '?')" — Brogan, May 16 '16 at 07:27

score -2 · Answer 1 · answered May 16 '16 at 07:38

-2

$sql = "INSERT INTO `devices` (`deviceName`, `type`, `deviceToken`) VALUES (?, ?, ?)"
$stmt = $conn->prepare($sql);
echo $sql; // here you go

answered May 16 '16 at 07:38

Your Common Sense

156,878
40
214
345

1

But, in this way, you can't see binded values – Sergio Gandrus Jan 23 '20 at 10:47
The Original Poster didn't ask that. But if you need values you can output them as well: var_dump($deviceName, $deviceToken, $type) – Your Common Sense Jan 23 '20 at 11:18

Get query back from MYSQLi prepared statement

1 Answers1