/hphp/test/zend/bad/ext/mysql/tests/mysql_max_persistent.php
PHP | 60 lines | 43 code | 13 blank | 4 comment | 7 complexity | 44347add15315692001f845855a03d9f MD5 | raw file
Possible License(s): LGPL-2.1, BSD-2-Clause, BSD-3-Clause, MPL-2.0-no-copyleft-exception, MIT, LGPL-2.0, Apache-2.0
- <?php
- require_once('connect.inc');
- function my_connect($offset, $host, $user, $passwd, $db, $port, $socket) {
- if ($socket)
- $host = sprintf("%s:%s", $host, $socket);
- else if ($port)
- $host = sprintf("%s:%s", $host, $port);
- $link = mysql_pconnect($host, $user, $passwd);
- if (!$link) {
- printf("[%03d] Cannot connect using host '%s', user '%s', password '****', [%d] %s\n",
- $offset, $host, $user, $passwd,
- mysql_errno(), mysql_error());
- return false;
- }
- if (!mysql_select_db($db, $link))
- return false;
- return $link;
- }
- $links = array();
- // try to open 2 links
- $links[0] = my_connect(10, $host, $user, $passwd, $db, $port, $socket);
- $links[1] = my_connect(20, $host, 'pcontest', 'pcontest', $db, $port, $socket);
- if (false !== $links[1])
- printf("[030] Last connection should not have been allowed!\n");
- // free some links but let index 1 remain
- unset($links[1]);
- mysql_close($links[0]);
- unset($links[0]);
- // should be allowed -> only open connection
- $links[0] = my_connect(40, $host, $user, $passwd, $db, $port, $socket);
- var_dump($links);
- mysql_query('REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest', $links[0]);
- mysql_query('DROP USER pcontest', $links[0]);
- mysql_close($links[0]);
- print "done!\n";
- ?>
- <?php
- // connect + select_db
- require_once("connect.inc");
- if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) {
- printf("[c001] Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
- $host, $myhost, $user, $db, $port, $socket);
- }
- @mysql_query('REVOKE ALL PRIVILEGES, GRANT OPTION FROM pcontest', $link);
- @mysql_query('DROP USER pcontest', $link);
- mysql_close($link);
- ?>