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

Variables

None

Stats

MD5 14458a37d5335a1cd3ea75e2b39fa560
Eval Count 0
Decode Time 107 ms