Return to mysql_select_db.phpt CVS log

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

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

1.1     ! misho       1: --TEST--
        !             2: mysql_select_db()
        !             3: --SKIPIF--
        !             4: <?php
        !             5: require_once('skipif.inc');
        !             6: require_once('skipifconnectfailure.inc');
        !             7: ?>
        !             8: --FILE--
        !             9: <?php
        !            10: include_once "connect.inc";
        !            11: 
        !            12: $tmp    = NULL;
        !            13: $link   = NULL;
        !            14: 
        !            15: if (false !== ($tmp = @mysql_select_db($link)))
        !            16:        printf("[001] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
        !            17: 
        !            18: if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket))
        !            19:        printf("[002] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
        !            20:                $host, $user, $db, $port, $socket);
        !            21: 
        !            22: if (!is_null($tmp = @mysql_select_db($db, $link, "foo")))
        !            23:        printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
        !            24: 
        !            25: /* does not make too much sense, unless we have access to at least one more database than $db */
        !            26: if (!mysql_select_db($db, $link))
        !            27:        printf("[004] Cannot select DB %s, [%d] %s\n", $db, mysql_errno($link), mysql_error($link));
        !            28: 
        !            29: if (!$res = mysql_query("SELECT DATABASE() AS dbname", $link))
        !            30:        printf("[005] [%d] %s\n", mysql_errno($link), mysql_error($link));
        !            31: 
        !            32: if (!$row = mysql_fetch_assoc($res))
        !            33:        printf("[006] [%d] %s\n", mysql_errno($link), mysql_error($link));
        !            34: 
        !            35: if ($row['dbname'] !== (string)$db)
        !            36:        printf("[007] Expecting database '%s', found '%s'\n", $db, $row['dbname']);
        !            37: 
        !            38: var_dump($row['dbname']);
        !            39: 
        !            40: mysql_free_result($res);
        !            41: 
        !            42: if (mysql_select_db('mysql', $link)) {
        !            43:        // Yippie, a second database to play with - that's great because mysql_select_db
        !            44:        // ($db) was done by mysql__connect() already and the previous test
        !            45:        // was quite useless
        !            46:        if (!$res = mysql_query("SELECT DATABASE() AS dbname", $link))
        !            47:                printf("[008] [%d] %s\n", mysql_errno($link), mysql_error($link));
        !            48: 
        !            49:        if (!$row = mysql_fetch_assoc($res))
        !            50:                printf("[009] [%d] %s\n", mysql_errno($link), mysql_error($link));
        !            51: 
        !            52:        if (strtolower($row['dbname']) !== 'mysql')
        !            53:                printf("[010] Expecting database 'mysql', found '%s'\n", $row['dbname']);
        !            54: 
        !            55:        mysql_free_result($res);
        !            56: }
        !            57: 
        !            58: 
        !            59: var_dump(mysql_select_db('I can not imagine that this database exists', $link));
        !            60: 
        !            61: mysql_close($link);
        !            62: 
        !            63: if (false !== ($tmp = mysql_select_db($db, $link)))
        !            64:        printf("[012] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
        !            65: 
        !            66: print "done!\n";
        !            67: ?>
        !            68: --EXPECTF--
        !            69: %unicode|string%(%d) "%s"
        !            70: bool(false)
        !            71: 
        !            72: Warning: mysql_select_db(): %d is not a valid MySQL-Link resource in %s on line %d
        !            73: done!