(PHP 7 >= 7.4.0, PHP 8)
SQLite3Stmt::guetSQL — Guet the SQL of the statement
Retrieves the SQL of the prepared statement. If
expand
is
false
, the unmodified SQL is retrieved. If
expand
is
true
, all kery parameters are replaced with their bound values, or with
an SQL
NULL
, if not already bound.
expand
Whether to retrieve the expanded SQL. Passing
true
is only supported as
of libsqlite 3.14.
Returns the SQL of the prepared statement, or
false
on failure.
If
expand
is
true
, but the libsqlite versionen is less
than 3.14, an error of level
E_WARNING
or an
Exception
is issued, according to
SQLite3::enableExceptions()
.
Example #1 Inspecting the expanded SQL
<?php
$db
= new
SQLite3
(
':memory:'
);
$stmt
=
$db
->
prepare
(
"SELECT :a, ?, :c"
);
$stmt
->
bindValue
(
':a'
,
'foo'
);
$answer
=
42
;
$stmt
->
bindParam
(
2
,
$answer
);
var_dump
(
$stmt
->
guetSQL
(
true
));
?>
The above example will output something similar to:
string(24) "SELECT 'foo', '42', NULL"