040.phpt 1.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647
  1. --TEST--
  2. function test: mysqli_num_rows()
  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. $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
  13. mysqli_select_db($link, $db);
  14. mysqli_query($link, "DROP TABLE IF EXISTS test_result");
  15. mysqli_query($link, "CREATE TABLE test_result (a int, b varchar(10)) ENGINE=" . $engine);
  16. mysqli_query($link, "INSERT INTO test_result VALUES (1, 'foo')");
  17. mysqli_real_query($link, "SELECT * FROM test_result");
  18. if (mysqli_field_count($link)) {
  19. $result = mysqli_store_result($link);
  20. $num = mysqli_num_rows($result);
  21. mysqli_free_result($result);
  22. }
  23. var_dump($num);
  24. mysqli_query($link, "DROP TABLE IF EXISTS test_result");
  25. mysqli_close($link);
  26. print "done!";
  27. ?>
  28. --CLEAN--
  29. <?php
  30. require_once("connect.inc");
  31. if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
  32. printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
  33. if (!mysqli_query($link, "DROP TABLE IF EXISTS test_result"))
  34. printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
  35. mysqli_close($link);
  36. ?>
  37. --EXPECT--
  38. int(1)
  39. done!