sqlite3stmt_paramCount_error.phpt 1.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. --TEST--
  2. SQLite3Stmt::paramCount error test
  3. --SKIPIF--
  4. <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?>
  5. --FILE--
  6. <?php
  7. require_once(dirname(__FILE__) . '/new_db.inc');
  8. echo "Creating Table\n";
  9. var_dump($db->exec('CREATE TABLE foobar (id INTEGER, name STRING, city STRING)'));
  10. echo "INSERT into table\n";
  11. var_dump($db->exec("INSERT INTO foobar (id, name, city) VALUES (1, 'john', 'LA')"));
  12. var_dump($db->exec("INSERT INTO foobar (id, name, city) VALUES (2, 'doe', 'SF')"));
  13. $query = "SELECT * FROM foobar WHERE id = ? ORDER BY id ASC";
  14. echo "SELECTING results\n";
  15. $stmt = $db->prepare($query);
  16. echo "paramCount with wrong number of arguments\n";
  17. var_dump($stmt->paramCount('foobar'));
  18. $result = $stmt->execute();
  19. echo "Closing database\n";
  20. $stmt = null;
  21. $result = null;
  22. var_dump($db->close());
  23. echo "Done\n";
  24. ?>
  25. --EXPECTF--
  26. Creating Table
  27. bool(true)
  28. INSERT into table
  29. bool(true)
  30. bool(true)
  31. SELECTING results
  32. paramCount with wrong number of arguments
  33. Warning: SQLite3Stmt::paramCount() expects exactly 0 parameters, 1 given in %s on line %d
  34. NULL
  35. Closing database
  36. bool(true)
  37. Done