Return to mysql_max_links.phpt CVS log

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

Annotation of embedaddon/php/ext/mysql/tests/mysql_max_links.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: mysql_[p]connect() - max_links/max_persistent
        !             3: --SKIPIF--
        !             4: <?php
        !             5: require_once('skipif.inc');
        !             6: require_once('skipifconnectfailure.inc');
        !             7: ?>
        !             8: --INI--
        !             9: mysql.max_links=2
        !            10: --FILE--
        !            11: <?php
        !            12: require_once('connect.inc');
        !            13: 
        !            14: function my_connect($offset, $host, $user, $passwd, $db, $port, $socket) {
        !            15:        if ($socket)
        !            16:                $host = sprintf("%s:%s", $host, $socket);
        !            17:        else if ($port)
        !            18:                $host = sprintf("%s:%s", $host, $port);
        !            19: 
        !            20:        $link = mysql_connect($host, $user, $passwd, true);
        !            21: 
        !            22:        if (!$link) {
        !            23:                printf("[%03d] Cannot connect using host '%s', user '%s', password '****', [%d] %s\n",
        !            24:                        $offset, $host, $user, $passwd,
        !            25:                        mysql_errno(), mysql_error());
        !            26:                return false;
        !            27:        }
        !            28: 
        !            29:        return $link;
        !            30: }
        !            31: 
        !            32: $links = array();
        !            33: 
        !            34: // try to open 3 links
        !            35: $links[0] = my_connect(10, $host, $user, $passwd, $db, $port, $socket);
        !            36: $links[1] = my_connect(20, $host, $user, $passwd, $db, $port, $socket);
        !            37: $links[2] = my_connect(30, $host, $user, $passwd, $db, $port, $socket);
        !            38: if (false !== $links[2])
        !            39:        printf("[040] Last connection should not have been allowed!\n");
        !            40: 
        !            41: // free some links but let index 1 remain
        !            42: unset($links[2]);
        !            43: mysql_close($links[0]);
        !            44: unset($links[0]);
        !            45: 
        !            46: // should be allowed -> second open connection
        !            47: $links[0] = my_connect(50, $host, $user, $passwd, $db, $port, $socket);
        !            48: $links[2] = my_connect(60, $host, $user, $passwd, $db, $port, $socket);
        !            49: ksort($links);
        !            50: var_dump($links);
        !            51: 
        !            52: mysql_close($links[0]);
        !            53: mysql_close($links[1]);
        !            54: print "done!\n";
        !            55: ?>
        !            56: --EXPECTF--
        !            57: Warning: mysql_connect(): Too many open links (2) in %s on line %s
        !            58: [030] Cannot connect using host '%s', user '%s', password '****', [0] 0
        !            59: 
        !            60: Warning: mysql_connect(): Too many open links (2) in %s on line %s
        !            61: [060] Cannot connect using host '%s', user '%s', password '****', [0] 0
        !            62: array(3) {
        !            63:   [0]=>
        !            64:   resource(%d) of type (mysql link)
        !            65:   [1]=>
        !            66:   resource(%d) of type (mysql link)
        !            67:   [2]=>
        !            68:   bool(false)
        !            69: }
        !            70: done!