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     ! 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!