mysqli_set_opt.phpt 2.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
  1. --TEST--
  2. mysqli_set_opt()
  3. --SKIPIF--
  4. <?php
  5. require_once('skipif.inc');
  6. require_once('skipifemb.inc');
  7. require_once('skipifconnectfailure.inc');
  8. ?>
  9. --FILE--
  10. <?php
  11. require_once("connect.inc");
  12. $tmp = NULL;
  13. $link = NULL;
  14. if (!is_null($tmp = @mysqli_set_opt()))
  15. printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
  16. if (!is_null($tmp = @mysqli_set_opt($link)))
  17. printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
  18. $link = mysqli_init();
  19. if (!is_null($tmp = @mysqli_set_opt($link, MYSQLI_OPT_CONNECT_TIMEOUT)))
  20. printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
  21. if (!is_null($tmp = @mysqli_set_opt($link, "s", 'extra_my.cnf')))
  22. printf("[004] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
  23. if (!is_null($tmp = @mysqli_set_opt($link, MYSQLI_INIT_COMMAND, 'SET AUTOCOMMIT=0', 'foo')))
  24. printf("[005] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
  25. // print "run_tests.php don't fool me with your 'ungreedy' expression '.+?'!\n";
  26. var_dump(mysqli_set_opt($link, MYSQLI_READ_DEFAULT_GROUP, 'extra_my.cnf'));
  27. var_dump(mysqli_set_opt($link, MYSQLI_READ_DEFAULT_FILE, 'extra_my.cnf'));
  28. var_dump(mysqli_set_opt($link, MYSQLI_OPT_CONNECT_TIMEOUT, 10));
  29. var_dump(mysqli_set_opt($link, MYSQLI_OPT_LOCAL_INFILE, 1));
  30. var_dump(mysqli_set_opt($link, MYSQLI_INIT_COMMAND, 'SET AUTOCOMMIT=0'));
  31. var_dump(my_mysqli_real_connect($link, $host, $user, $passwd, $db, $port, $socket));
  32. var_dump(mysqli_set_opt($link, MYSQLI_READ_DEFAULT_GROUP, 'extra_my.cnf'));
  33. var_dump(mysqli_set_opt($link, MYSQLI_READ_DEFAULT_FILE, 'extra_my.cnf'));
  34. var_dump(mysqli_set_opt($link, MYSQLI_OPT_CONNECT_TIMEOUT, 10));
  35. var_dump(mysqli_set_opt($link, MYSQLI_OPT_LOCAL_INFILE, 1));
  36. var_dump(mysqli_set_opt($link, MYSQLI_INIT_COMMAND, 'SET AUTOCOMMIT=0'));
  37. var_dump(mysqli_set_opt($link, MYSQLI_CLIENT_SSL, 'not an mysqli_option'));
  38. mysqli_close($link);
  39. var_dump(mysqli_set_opt($link, MYSQLI_INIT_COMMAND, 'SET AUTOCOMMIT=1'));
  40. print "done!";
  41. ?>
  42. --EXPECTF--
  43. bool(true)
  44. bool(true)
  45. bool(true)
  46. bool(true)
  47. bool(true)
  48. bool(true)
  49. bool(true)
  50. bool(true)
  51. bool(true)
  52. bool(true)
  53. bool(true)
  54. bool(false)
  55. Warning: mysqli_set_opt(): Couldn't fetch mysqli in %s on line %d
  56. NULL
  57. done!