sqlite3_33_reset.phpt 489 B

12345678910111213141516171819202122232425
  1. --TEST--
  2. SQLite3:: reset
  3. --CREDITS--
  4. Ward Hus & James Cauwelier
  5. #@ PHP TESTFEST 2009 (BELGIUM)
  6. --EXTENSIONS--
  7. sqlite3
  8. --FILE--
  9. <?php
  10. $db = new SQLite3(':memory:');
  11. $db->exec('CREATE TABLE foo (id INTEGER, bar STRING)');
  12. $db->exec("INSERT INTO foo (id, bar) VALUES (1, 'This is a test')");
  13. $stmt = $db->prepare('SELECT bar FROM foo WHERE id=:id');
  14. $stmt->bindValue(':id', 1, SQLITE3_INTEGER);
  15. $stmt->reset();
  16. //var_dump($db);
  17. //var_dump($db->close());
  18. echo "Done\n";
  19. ?>
  20. --EXPECT--
  21. Done