array ( 0 => 'index.php', 1 => 'PHP Manual', ), 'head' => array ( 0 => 'UTF-8', 1 => 'es', ), 'this' => array ( 0 => 'sqlite3stmt.getsql.php', 1 => 'SQLite3Stmt::getSQL', ), 'up' => array ( 0 => 'class.sqlite3stmt.php', 1 => 'SQLite3Stmt', ), 'prev' => array ( 0 => 'sqlite3stmt.execute.php', 1 => 'SQLite3Stmt::execute', ), 'next' => array ( 0 => 'sqlite3stmt.paramcount.php', 1 => 'SQLite3Stmt::paramCount', ), 'alternatives' => array ( ), 'source' => array ( 'lang' => 'en', 'path' => 'reference/sqlite3/sqlite3stmt/getsql.xml', ), ); $setup["toc"] = $TOC; $setup["toc_deprecated"] = $TOC_DEPRECATED; $setup["parents"] = $PARENTS; manual_setup($setup); ?>
(PHP 7 >= 7.4.0, PHP 8)
SQLite3Stmt::getSQL — Get 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 query 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, o false
en caso de error.
If expand
is true
, but the libsqlite version is less
than 3.14, an error of level E_WARNING
or an Exception
is issued, according to SQLite3::enableExceptions().
Ejemplo #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->getSQL(true));
?>
El resultado del ejemplo sería algo similar a:
string(24) "SELECT 'foo', '42', NULL"