Return to mysql_pconn_reuse.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / mysql / tests

Annotation of embedaddon/php/ext/mysql/tests/mysql_pconn_reuse.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: mysql_pconnect() - disabling feature
                      3: --SKIPIF--
                      4: <?php
                      5: require_once('skipif.inc');
                      6: require_once('skipifconnectfailure.inc');
                      7: ?>
                      8: --INI--
                      9: mysql.allow_persistent=1
                     10: mysql.max_persistent=1
                     11: mysql.max_links=2
                     12: --FILE--
                     13: <?php
                     14:        require_once("connect.inc");
                     15:        require_once("table.inc");
                     16:        mysql_close($link);
                     17: 
                     18:        if ($socket)
                     19:                $myhost = sprintf("%s:%s", $host, $socket);
                     20:        else if ($port)
                     21:                $myhost = sprintf("%s:%s", $host, $port);
                     22:        else
                     23:        $myhost = $host;
                     24: 
                     25:        if (($plink = mysql_pconnect($myhost, $user, $passwd)))
                     26:                printf("[001] Can connect to the server.\n");
                     27: 
                     28:        if ((mysql_select_db($db, $plink)) &&
                     29:                        ($res = mysql_query('SELECT id FROM test', $plink)) &&
                     30:                        ($row = mysql_fetch_assoc($res)) &&
                     31:                        (mysql_free_result($res))) {
                     32:                printf("[002] Can fetch data using persistent connection! Data = '%s'\n",
                     33:                        $row['id']);
                     34:        } else {
                     35:                printf("[002] [%d] %s\n", mysql_errno($plink), mysql_error($plink));
                     36:        }
                     37: 
                     38:        $thread_id = mysql_thread_id($plink);
                     39:        mysql_close($plink);
                     40: 
                     41:        if (!($plink = mysql_pconnect($myhost, $user, $passwd)))
                     42:                printf("[003] Cannot connect, [%d] %s\n", mysql_errno(), mysql_error());
                     43: 
                     44:        if (mysql_thread_id($plink) != $thread_id)
                     45:                printf("[004] Looks like the second call to pconnect() did not give us the same connection.\n");
                     46: 
                     47:        $thread_id = mysql_thread_id($plink);
                     48:        mysql_close($plink);
                     49: 
                     50:        if (!($plink = mysql_connect($myhost, $user, $passwd, true)))
                     51:                printf("[005] Cannot connect, [%d] %s\n", mysql_errno(), mysql_error());
                     52: 
                     53:        if (mysql_thread_id($plink) == $thread_id)
                     54:                printf("[006] Looks like connect() did not return a new connection.\n");
                     55: 
                     56:        if (($link = mysql_connect($myhost, $user, $passwd, true)))
                     57:                printf("[007] Can connect although limit has been reached, [%d] %s\n", mysql_errno(), mysql_error());
                     58: 
                     59:        print "done!";
                     60: ?>
                     61: --EXPECTF--
                     62: [001] Can connect to the server.
                     63: [002] Can fetch data using persistent connection! Data = '1'
                     64: 
                     65: Warning: mysql_connect(): Too many open links (2) in %s on line %d
                     66: done!