Return to mysql_field_seek.phpt CVS log

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

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

1.1     ! misho       1: --TEST--
        !             2: mysql_field_seek()
        !             3: --SKIPIF--
        !             4: <?php
        !             5: require_once('skipif.inc');
        !             6: require_once('skipifconnectfailure.inc');
        !             7: ?>
        !             8: --FILE--
        !             9: <?php
        !            10: include "connect.inc";
        !            11: 
        !            12: $tmp    = NULL;
        !            13: $link   = NULL;
        !            14: 
        !            15: if (!is_null($tmp = @mysql_field_seek()))
        !            16:        printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
        !            17: 
        !            18: if (!is_null($tmp = @mysql_field_seek($link)))
        !            19:        printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
        !            20: 
        !            21: require('table.inc');
        !            22: if (!$res = mysql_query("SELECT id, label FROM test ORDER BY id LIMIT 1", $link)) {
        !            23:        printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link));
        !            24: }
        !            25: 
        !            26: var_dump(mysql_field_seek($res, -1));
        !            27: var_dump(mysql_fetch_field($res));
        !            28: var_dump(mysql_field_seek($res, 0));
        !            29: var_dump(mysql_fetch_field($res));
        !            30: var_dump(mysql_field_seek($res, 1));
        !            31: var_dump(mysql_fetch_field($res));
        !            32: var_dump(mysql_field_seek($res, 2));
        !            33: var_dump(mysql_fetch_field($res));
        !            34: 
        !            35: mysql_free_result($res);
        !            36: 
        !            37: var_dump(mysql_field_seek($res, 0));
        !            38: 
        !            39: mysql_close($link);
        !            40: print "done!";
        !            41: ?>
        !            42: --CLEAN--
        !            43: <?php
        !            44: require_once("clean_table.inc");
        !            45: ?>
        !            46: --EXPECTF--
        !            47: Warning: mysql_field_seek(): Field -1 is invalid for MySQL result index %d in %s on line %d
        !            48: bool(false)
        !            49: object(stdClass)#%d (13) {
        !            50:   [%u|b%"name"]=>
        !            51:   %unicode|string%(2) "id"
        !            52:   [%u|b%"table"]=>
        !            53:   %unicode|string%(4) "test"
        !            54:   [%u|b%"def"]=>
        !            55:   %unicode|string%(0) ""
        !            56:   [%u|b%"max_length"]=>
        !            57:   int(1)
        !            58:   [%u|b%"not_null"]=>
        !            59:   int(1)
        !            60:   [%u|b%"primary_key"]=>
        !            61:   int(1)
        !            62:   [%u|b%"multiple_key"]=>
        !            63:   int(0)
        !            64:   [%u|b%"unique_key"]=>
        !            65:   int(0)
        !            66:   [%u|b%"numeric"]=>
        !            67:   int(1)
        !            68:   [%u|b%"blob"]=>
        !            69:   int(0)
        !            70:   [%u|b%"type"]=>
        !            71:   %unicode|string%(3) "int"
        !            72:   [%u|b%"unsigned"]=>
        !            73:   int(0)
        !            74:   [%u|b%"zerofill"]=>
        !            75:   int(0)
        !            76: }
        !            77: bool(true)
        !            78: object(stdClass)#%d (13) {
        !            79:   [%u|b%"name"]=>
        !            80:   %unicode|string%(2) "id"
        !            81:   [%u|b%"table"]=>
        !            82:   %unicode|string%(4) "test"
        !            83:   [%u|b%"def"]=>
        !            84:   %unicode|string%(0) ""
        !            85:   [%u|b%"max_length"]=>
        !            86:   int(1)
        !            87:   [%u|b%"not_null"]=>
        !            88:   int(1)
        !            89:   [%u|b%"primary_key"]=>
        !            90:   int(1)
        !            91:   [%u|b%"multiple_key"]=>
        !            92:   int(0)
        !            93:   [%u|b%"unique_key"]=>
        !            94:   int(0)
        !            95:   [%u|b%"numeric"]=>
        !            96:   int(1)
        !            97:   [%u|b%"blob"]=>
        !            98:   int(0)
        !            99:   [%u|b%"type"]=>
        !           100:   %unicode|string%(3) "int"
        !           101:   [%u|b%"unsigned"]=>
        !           102:   int(0)
        !           103:   [%u|b%"zerofill"]=>
        !           104:   int(0)
        !           105: }
        !           106: bool(true)
        !           107: object(stdClass)#%d (13) {
        !           108:   [%u|b%"name"]=>
        !           109:   %unicode|string%(5) "label"
        !           110:   [%u|b%"table"]=>
        !           111:   %unicode|string%(4) "test"
        !           112:   [%u|b%"def"]=>
        !           113:   %unicode|string%(0) ""
        !           114:   [%u|b%"max_length"]=>
        !           115:   int(1)
        !           116:   [%u|b%"not_null"]=>
        !           117:   int(0)
        !           118:   [%u|b%"primary_key"]=>
        !           119:   int(0)
        !           120:   [%u|b%"multiple_key"]=>
        !           121:   int(0)
        !           122:   [%u|b%"unique_key"]=>
        !           123:   int(0)
        !           124:   [%u|b%"numeric"]=>
        !           125:   int(0)
        !           126:   [%u|b%"blob"]=>
        !           127:   int(0)
        !           128:   [%u|b%"type"]=>
        !           129:   %unicode|string%(6) "string"
        !           130:   [%u|b%"unsigned"]=>
        !           131:   int(0)
        !           132:   [%u|b%"zerofill"]=>
        !           133:   int(0)
        !           134: }
        !           135: 
        !           136: Warning: mysql_field_seek(): Field %d is invalid for MySQL result index %d in %s on line %d
        !           137: bool(false)
        !           138: bool(false)
        !           139: 
        !           140: Warning: mysql_field_seek(): %d is not a valid MySQL result resource in %s on line %d
        !           141: bool(false)
        !           142: done!