xref: /PHP-7.3/ext/sqlite3/tests/bug70628.phpt (revision 57940605)
1--TEST--
2Bug #70628 (Clearing bindings on an SQLite3 statement doesn't work)
3--SKIPIF--
4<?php
5if (!extension_loaded('sqlite3')) die('skip'); ?>
6--FILE--
7<?php
8$db = new SQLite3(':memory:');
9
10$db->exec("CREATE TABLE Dogs (Id INTEGER PRIMARY KEY, Breed TEXT, Name TEXT, Age INTEGER)");
11
12$sth = $db->prepare("INSERT INTO Dogs (Breed, Name, Age)  VALUES (:breed,:name,:age)");
13
14$sth->bindValue(':breed', 'canis', SQLITE3_TEXT);
15$sth->bindValue(':name', 'jack', SQLITE3_TEXT);
16$sth->bindValue(':age', 7, SQLITE3_INTEGER);
17$sth->execute();
18
19$sth->clear();
20$sth->reset();
21
22$sth->bindValue(':breed', 'russel', SQLITE3_TEXT);
23$sth->bindValue(':age', 3, SQLITE3_INTEGER);
24$sth->execute();
25
26$res = $db->query('SELECT * FROM Dogs');
27while (($row = $res->fetchArray(SQLITE3_ASSOC))) {
28    var_dump($row);
29}
30$res->finalize();
31
32$sth->close();
33$db->close();
34?>
35--EXPECT--
36array(4) {
37  ["Id"]=>
38  int(1)
39  ["Breed"]=>
40  string(5) "canis"
41  ["Name"]=>
42  string(4) "jack"
43  ["Age"]=>
44  int(7)
45}
46array(4) {
47  ["Id"]=>
48  int(2)
49  ["Breed"]=>
50  string(6) "russel"
51  ["Name"]=>
52  NULL
53  ["Age"]=>
54  int(3)
55}
56