1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
|
--TEST--
SQLite3Stmt::getSQL expanded test
--EXTENSIONS--
sqlite3
--SKIPIF--
<?php
if (SQLite3::version()['versionNumber'] < 3014000) {
die('skip SQLite < 3.14 installed, requires SQLite >= 3.14');
}
?>
--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 expanded SQL statement\n";
var_dump($stmt->getSQL(true));
echo "Execute statement\n";
var_dump($res = $stmt->execute());
echo "Statement result\n";
var_dump($res->fetchArray(SQLITE3_NUM));
$stmt->reset();
echo "Change binded values\n";
$stmt->bindValue(':a', 'TEST');
$stmt->bindValue(':b', '!!!');
$stmt->bindValue(3, 40);
echo "Getting expanded SQL statement\n";
var_dump($stmt->getSQL(true));
echo "Closing DB\n";
var_dump($db->close());
echo "Done\n";
?>
--EXPECT--
Getting expanded SQL statement
string(21) "SELECT 42, 'php', 43;"
Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(3) {
[0]=>
int(42)
[1]=>
string(3) "php"
[2]=>
int(43)
}
Change binded values
Getting expanded SQL statement
string(25) "SELECT 'TEST', '!!!', 40;"
Closing DB
bool(true)
Done
|
