mysqli_pconn_twice.phpt 2.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677
  1. --TEST--
  2. Calling connect() on an open persistent connection to create a new persistent connection
  3. --EXTENSIONS--
  4. mysqli
  5. --SKIPIF--
  6. <?php
  7. require_once('skipifconnectfailure.inc');
  8. ?>
  9. --INI--
  10. mysqli.allow_persistent=1
  11. mysqli.max_persistent=-1
  12. mysqli.max_links=-1
  13. --FILE--
  14. <?php
  15. require_once("connect.inc");
  16. $host = 'p:' . $host;
  17. if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
  18. printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
  19. $host, $user, $db, $port, $socket);
  20. if (true !== ($tmp = my_mysqli_real_connect($link, $host, $user, $passwd, $db, $port, $socket)))
  21. printf("[003] Expecting boolean/true got %s/%s\n", gettype($tmp), $tmp);
  22. /* it is undefined which pooled connection we get - thread ids may differ */
  23. if (!($res = mysqli_query($link, "SELECT 'ok' AS it_works")) ||
  24. !($row = mysqli_fetch_assoc($res)))
  25. printf("[006] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
  26. var_dump($row);
  27. mysqli_free_result($res);
  28. mysqli_close($link);
  29. if (!$link = new my_mysqli($host, $user, $passwd, $db, $port, $socket))
  30. printf("[007] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
  31. $host, $user, $db, $port, $socket);
  32. if (true !== ($tmp = $link->real_connect($host, $user, $passwd, $db, $port, $socket)))
  33. printf("[009] Expecting boolean/true got %s/%s\n", gettype($tmp), $tmp);
  34. /* it is undefined which pooled connection we get - thread ids may differ */
  35. if (!($res = $link->query("SELECT 'works also with oo' AS syntax")) ||
  36. !($row = $res->fetch_assoc()))
  37. printf("[012] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
  38. var_dump($row);
  39. mysqli_free_result($res);
  40. mysqli_close($link);
  41. if (true !== ($tmp = $link->connect($host, $user, $passwd, $db, $port, $socket)))
  42. printf("[013] Expecting true got %s/%s\n", gettype($tmp), $tmp);
  43. if (!$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket))
  44. printf("[014] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
  45. $host, $user, $db, $port, $socket);
  46. if (true !== ($tmp = $link->connect($host, $user, $passwd, $db, $port, $socket)))
  47. printf("[015] Expecting true got %s/%s\n", gettype($tmp), $tmp);
  48. print "done!";
  49. ?>
  50. --EXPECT--
  51. array(1) {
  52. ["it_works"]=>
  53. string(2) "ok"
  54. }
  55. array(1) {
  56. ["syntax"]=>
  57. string(18) "works also with oo"
  58. }
  59. done!