Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
--TEST-- SQLite3Stmt::getSQL test --EXTENSIONS-- sqlite3 --FILE-- <?php require_once(__DI..
Decoded Output download
--TEST--
SQLite3Stmt::getSQL test
--EXTENSIONS--
sqlite3
--FILE--
<?php
require_once(__DIR__ . '/new_db.inc');
$db->enableExceptions(true);
$stmt = $db->prepare('SELECT :a, :b, ?;');
$stmt->bindValue(':a', 42);
$stmt->bindValue(':b', 'php');
$stmt->bindValue(3, 43);
echo "Getting non-expanded SQL statement
";
var_dump($stmt->getSQL(false));
echo "Execute statement
";
var_dump($res = $stmt->execute());
echo "Statement result
";
var_dump($res->fetchArray(SQLITE3_NUM));
echo "Closing DB
";
var_dump($db->close());
echo "Done
";
?>
--EXPECT--
Getting non-expanded SQL statement
string(17) "SELECT :a, :b, ?;"
Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(3) {
[0]=>
int(42)
[1]=>
string(3) "php"
[2]=>
int(43)
}
Closing DB
bool(true)
Done
Did this file decode correctly?
Original Code
--TEST--
SQLite3Stmt::getSQL test
--EXTENSIONS--
sqlite3
--FILE--
<?php
require_once(__DIR__ . '/new_db.inc');
$db->enableExceptions(true);
$stmt = $db->prepare('SELECT :a, :b, ?;');
$stmt->bindValue(':a', 42);
$stmt->bindValue(':b', 'php');
$stmt->bindValue(3, 43);
echo "Getting non-expanded SQL statement\n";
var_dump($stmt->getSQL(false));
echo "Execute statement\n";
var_dump($res = $stmt->execute());
echo "Statement result\n";
var_dump($res->fetchArray(SQLITE3_NUM));
echo "Closing DB\n";
var_dump($db->close());
echo "Done\n";
?>
--EXPECT--
Getting non-expanded SQL statement
string(17) "SELECT :a, :b, ?;"
Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(3) {
[0]=>
int(42)
[1]=>
string(3) "php"
[2]=>
int(43)
}
Closing DB
bool(true)
Done
Function Calls
None |
Stats
MD5 | 14458a37d5335a1cd3ea75e2b39fa560 |
Eval Count | 0 |
Decode Time | 107 ms |