063.phpt 819 B

12345678910111213141516171819202122232425262728293031323334
  1. --TEST--
  2. resultset constructor
  3. --EXTENSIONS--
  4. mysqli
  5. --SKIPIF--
  6. <?php
  7. require_once('skipifconnectfailure.inc');
  8. ?>
  9. --FILE--
  10. <?php
  11. require_once("connect.inc");
  12. $mysql = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
  13. $stmt = new mysqli_stmt($mysql, "SELECT 'foo' FROM DUAL");
  14. $stmt->execute();
  15. $stmt->bind_result($foo);
  16. $stmt->fetch();
  17. $stmt->close();
  18. var_dump($foo);
  19. mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
  20. try {
  21. // an exception should be thrown from prepare (i.e. constructor) not from execute
  22. $stmt = new mysqli_stmt($mysql, "SELECT invalid FROM DUAL");
  23. } catch(mysqli_sql_exception $e) {
  24. echo $e->getMessage()."\n";
  25. }
  26. $mysql->close();
  27. ?>
  28. --EXPECT--
  29. string(3) "foo"
  30. Unknown column 'invalid' in 'field list'