xref: /PHP-8.3/ext/sqlite3/tests/bug77051.phpt (revision 7f2f0c00)
1--TEST--
2Bug #77051 SQLite3::bindParam memory bug when missing ::reset call
3--EXTENSIONS--
4sqlite3
5--FILE--
6<?php
7
8$db = new SQLite3(':memory:');
9$db->enableExceptions(true);
10
11$stmt = $db->prepare('SELECT :a, :b, ?;');
12
13$a = 42;
14$stmt->bindParam(':a', $a, SQLITE3_INTEGER);
15$stmt->bindValue(':b', 'php');
16$stmt->bindValue(':b', 'PHP');
17$stmt->bindValue(3, 424242);
18
19echo "Execute statement\n";
20var_dump($res = $stmt->execute());
21
22echo "Statement result\n";
23var_dump($res->fetchArray(SQLITE3_NUM));
24
25echo "Change binded param to wrong type\n";
26$a = 'TEST';
27
28echo "Execute statement\n";
29var_dump($res = $stmt->execute());
30
31echo "Statement result\n";
32var_dump($res->fetchArray(SQLITE3_NUM));
33
34echo "Change binded values\n";
35$a = 5252552;
36$stmt->bindValue(':b', 'TEST');
37$stmt->bindValue(3, '!!!');
38
39echo "Execute statement\n";
40var_dump($res = $stmt->execute());
41
42echo "Statement result\n";
43var_dump($res->fetchArray(SQLITE3_NUM));
44
45?>
46--EXPECT--
47Execute statement
48object(SQLite3Result)#3 (0) {
49}
50Statement result
51array(3) {
52  [0]=>
53  int(42)
54  [1]=>
55  string(3) "PHP"
56  [2]=>
57  int(424242)
58}
59Change binded param to wrong type
60Execute statement
61object(SQLite3Result)#4 (0) {
62}
63Statement result
64array(3) {
65  [0]=>
66  int(0)
67  [1]=>
68  string(3) "PHP"
69  [2]=>
70  int(424242)
71}
72Change binded values
73Execute statement
74object(SQLite3Result)#3 (0) {
75}
76Statement result
77array(3) {
78  [0]=>
79  int(5252552)
80  [1]=>
81  string(4) "TEST"
82  [2]=>
83  string(3) "!!!"
84}