1--TEST--
2SQLite3Stmt::reset with parameter test
3--CREDITS--
4Jelle Lampaert
5#Belgian Testfest 2009
6--SKIPIF--
7<?php require_once(dirname(__FILE__) . '/skipif.inc'); ?>
8--FILE--
9<?php
10$db = new SQLite3(':memory:');
11echo "Creating Table\n";
12var_dump($db->exec('CREATE TABLE foobar (id INTEGER, name STRING)'));
13
14echo "INSERT into table\n";
15var_dump($db->exec("INSERT INTO foobar (id, name) VALUES (1, 'john')"));
16
17
18$query = "SELECT name FROM foobar WHERE id = 1";
19
20echo "Prepare query\n";
21$stmt = $db->prepare($query);
22
23echo "Reset query\n";
24try {
25  $stmt->reset("foo");
26} catch (Exception $ex) {
27  var_dump($ex->getMessage());
28}
29
30echo "Closing database\n";
31$stmt = null;
32$result = null;
33var_dump($db->close());
34echo "Done\n";
35?>
36--EXPECTF--
37Creating Table
38bool(true)
39INSERT into table
40bool(true)
41Prepare query
42Reset query
43
44Warning: SQLite3Stmt::reset() expects exactly 0 parameters, %d given in %s on line %d
45Closing database
46bool(true)
47Done
48