066.phpt 1.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. --TEST--
  2. function test: mysqli_warning object
  3. --SKIPIF--
  4. <?php
  5. require_once('skipif.inc');
  6. require_once('skipifconnectfailure.inc');
  7. ?>
  8. --FILE--
  9. <?php
  10. require_once("connect.inc");
  11. /*** test mysqli_connect 127.0.0.1 ***/
  12. $mysql = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
  13. if (!mysqli_query($mysql, "SET sql_mode=''"))
  14. printf("[002] Cannot set SQL-Mode, [%d] %s\n", mysqli_errno($mysql), mysqli_error($mysql));
  15. $mysql->query("DROP TABLE IF EXISTS test_warnings");
  16. $mysql->query("CREATE TABLE test_warnings (a int not null) ENGINE=myisam");
  17. $mysql->query("INSERT INTO test_warnings VALUES (1),(2),(NULL)");
  18. if (($warning = $mysql->get_warnings())) {
  19. do {
  20. printf("Warning\n");
  21. } while ($warning->next());
  22. }
  23. $mysql->close();
  24. print "done!";
  25. ?>
  26. --CLEAN--
  27. <?php
  28. require_once("connect.inc");
  29. if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
  30. printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
  31. if (!mysqli_query($link, "DROP TABLE IF EXISTS test_warnings"))
  32. printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
  33. mysqli_close($link);
  34. ?>
  35. --EXPECT--
  36. Warning
  37. done!