Return to mysql_result.phpt CVS log

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

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

1.1     ! misho       1: --TEST--
        !             2: mysql_result()
        !             3: --SKIPIF--
        !             4: <?php
        !             5: require_once('skipif.inc');
        !             6: require_once('skipifconnectfailure.inc');
        !             7: ?>
        !             8: --FILE--
        !             9: <?php
        !            10: require_once("connect.inc");
        !            11: 
        !            12: $tmp    = NULL;
        !            13: $link   = NULL;
        !            14: 
        !            15: // string mysql_result ( resource result, int row [, mixed field] )
        !            16: 
        !            17: if (!is_null($tmp = @mysql_result()))
        !            18:        printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
        !            19: 
        !            20: if (!is_null($tmp = @mysql_result($link)))
        !            21:        printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
        !            22: 
        !            23: require_once('table.inc');
        !            24: if (!$res = mysql_query("SELECT id, label, id AS _id, CONCAT(label, 'a') _label, NULL as _foo FROM test _test ORDER BY id ASC LIMIT 1", $link)) {
        !            25:        printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link));
        !            26: }
        !            27: 
        !            28: var_dump(mysql_result($res, -1));
        !            29: var_dump(mysql_result($res, 2));
        !            30: 
        !            31: var_dump(mysql_result($res, 0, -1));
        !            32: var_dump(mysql_result($res, 0, 500));
        !            33: 
        !            34: print "valid fields\n";
        !            35: var_dump(mysql_result($res, 0));
        !            36: var_dump(mysql_result($res, 0, 1));
        !            37: 
        !            38: var_dump(mysql_result($res, 0, 'id'));
        !            39: var_dump(mysql_result($res, 0, '_test.id'));
        !            40: var_dump(mysql_result($res, 0, 'label'));
        !            41: var_dump(mysql_result($res, 0, '_test.label'));
        !            42: print "some invalid fields\n";
        !            43: var_dump(mysql_result($res, 0, 'unknown'));
        !            44: var_dump(mysql_result($res, 0, '_test.'));
        !            45: var_dump(mysql_result($res, 0, chr(0)));
        !            46: var_dump(mysql_result($res, 0, '_test.' . chr(0)));
        !            47: print "_id\n";
        !            48: var_dump(mysql_result($res, 0, '_id'));
        !            49: print "_label\n";
        !            50: var_dump(mysql_result($res, 0, '_label'));
        !            51: print "_foo\n";
        !            52: var_dump(mysql_result($res, 0, '_foo'));
        !            53: var_dump(mysql_result($res, 0, 'test.id'));
        !            54: var_dump(mysql_result($res, 0, 'test.label'));
        !            55: 
        !            56: mysql_free_result($res);
        !            57: 
        !            58: var_dump(mysql_result($res, 0));
        !            59: 
        !            60: mysql_close($link);
        !            61: print "done!";
        !            62: ?>
        !            63: --CLEAN--
        !            64: <?php
        !            65: require_once("clean_table.inc");
        !            66: ?>
        !            67: --EXPECTF--
        !            68: Warning: mysql_result(): Unable to jump to row -1 on MySQL result index %d in %s on line %d
        !            69: bool(false)
        !            70: 
        !            71: Warning: mysql_result(): Unable to jump to row 2 on MySQL result index %d in %s on line %d
        !            72: bool(false)
        !            73: 
        !            74: Warning: mysql_result(): Bad column offset specified in %s on line %d
        !            75: bool(false)
        !            76: 
        !            77: Warning: mysql_result(): Bad column offset specified in %s on line %d
        !            78: bool(false)
        !            79: valid fields
        !            80: %unicode|string%(1) "1"
        !            81: %unicode|string%(1) "a"
        !            82: %unicode|string%(1) "1"
        !            83: %unicode|string%(1) "1"
        !            84: %unicode|string%(1) "a"
        !            85: %unicode|string%(1) "a"
        !            86: some invalid fields
        !            87: 
        !            88: Warning: mysql_result(): unknown not found in MySQL result index %d in %s on line %d
        !            89: bool(false)
        !            90: 
        !            91: Warning: mysql_result(): _test. not found in MySQL result index %d in %s on line %d
        !            92: bool(false)
        !            93: 
        !            94: Warning: mysql_result():  not found in MySQL result index %d in %s on line %d
        !            95: bool(false)
        !            96: 
        !            97: Warning: mysql_result(): _test. not found in MySQL result index %d in %s on line %d
        !            98: bool(false)
        !            99: _id
        !           100: %unicode|string%(1) "1"
        !           101: _label
        !           102: string(2) "aa"
        !           103: _foo
        !           104: NULL
        !           105: 
        !           106: Warning: mysql_result(): test.id not found in MySQL result index %d in %s on line %d
        !           107: bool(false)
        !           108: 
        !           109: Warning: mysql_result(): test.label not found in MySQL result index %d in %s on line %d
        !           110: bool(false)
        !           111: 
        !           112: Warning: mysql_result(): %d is not a valid MySQL result resource in %s on line %d
        !           113: bool(false)
        !           114: done!