123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475 |
- --TEST--
- mysql_pconnect() - disabling feature
- --SKIPIF--
- <?php
- require_once('skipif.inc');
- require_once('skipifconnectfailure.inc');
- ?>
- --INI--
- mysql.allow_persistent=1
- mysql.max_persistent=1
- mysql.max_links=2
- --FILE--
- <?php
- require_once("connect.inc");
- require_once("table.inc");
- mysql_close($link);
- if ($socket)
- $myhost = sprintf("%s:%s", $host, $socket);
- else if ($port)
- $myhost = sprintf("%s:%s", $host, $port);
- else
- $myhost = $host;
- if (($plink = mysql_pconnect($myhost, $user, $passwd)))
- printf("[001] Can connect to the server.\n");
- if ((mysql_select_db($db, $plink)) &&
- ($res = mysql_query('SELECT id FROM test', $plink)) &&
- ($row = mysql_fetch_assoc($res)) &&
- (mysql_free_result($res))) {
- printf("[002] Can fetch data using persistent connection! Data = '%s'\n",
- $row['id']);
- } else {
- printf("[002] [%d] %s\n", mysql_errno($plink), mysql_error($plink));
- }
- $thread_id = mysql_thread_id($plink);
- mysql_close($plink);
- if (!($plink = mysql_pconnect($myhost, $user, $passwd)))
- printf("[003] Cannot connect, [%d] %s\n", mysql_errno(), mysql_error());
- if (mysql_thread_id($plink) != $thread_id)
- printf("[004] Looks like the second call to pconnect() did not give us the same connection.\n");
- $thread_id = mysql_thread_id($plink);
- mysql_close($plink);
- if (!($plink = mysql_connect($myhost, $user, $passwd, true)))
- printf("[005] Cannot connect, [%d] %s\n", mysql_errno(), mysql_error());
- if (mysql_thread_id($plink) == $thread_id)
- printf("[006] Looks like connect() did not return a new connection.\n");
- if (($link = mysql_connect($myhost, $user, $passwd, true)))
- printf("[007] Can connect although limit has been reached, [%d] %s\n", mysql_errno(), mysql_error());
- print "done!";
- ?>
- --EXPECTF--
- Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
- Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
- [001] Can connect to the server.
- [002] Can fetch data using persistent connection! Data = '1'
- Deprecated: mysql_pconnect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
- Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
- Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d
- Warning: mysql_connect(): Too many open links (2) in %s on line %d
- done!
|