Return to mysql_fetch_assoc.phpt CVS log

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

Annotation of embedaddon/php/ext/mysql/tests/mysql_fetch_assoc.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: mysql_fetch_assoc()
                      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: // Note: no SQL type tests, internally the same function gets used as for mysql_fetch_array() which does a lot of SQL type test
                     16: 
                     17: if (!is_null($tmp = @mysql_fetch_assoc()))
                     18:        printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
                     19: 
                     20: if (NULL !== ($tmp = @mysql_fetch_assoc($link)))
                     21:        printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
                     22: 
                     23: require('table.inc');
                     24: if (!$res = mysql_query("SELECT id, label FROM test ORDER BY id LIMIT 1", $link)) {
                     25:        printf("[004] [%d] %s\n", mysql_errno($link), mysql_error($link));
                     26: }
                     27: 
                     28: print "[005]\n";
                     29: var_dump(mysql_fetch_assoc($res));
                     30: 
                     31: print "[006]\n";
                     32: var_dump(mysql_fetch_assoc($res));
                     33: 
                     34: mysql_free_result($res);
                     35: 
                     36: if (!$res = mysql_query("SELECT 1 AS a, 2 AS a, 3 AS c, 4 AS C, NULL AS d, true AS e", $link)) {
                     37:        printf("[007] Cannot run query, [%d] %s\n", mysql_errno($link), $mysql_error($link));
                     38: }
                     39: print "[008]\n";
                     40: var_dump(mysql_fetch_assoc($res));
                     41: 
                     42: mysql_free_result($res);
                     43: 
                     44: if (false !== ($tmp = mysql_fetch_assoc($res)))
                     45:        printf("[008] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
                     46: 
                     47: mysql_close($link);
                     48: 
                     49: include('table.inc');
                     50: 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)) {
                     51:        printf("[009] [%d] %s\n", mysql_errno($link), $mysql_error($link));
                     52: }
                     53: print "[010]\n";
                     54: var_dump(mysql_fetch_assoc($res));
                     55: mysql_free_result($res);
                     56: 
                     57: mysql_close($link);
                     58: 
                     59: print "done!";
                     60: ?>
                     61: --CLEAN--
                     62: <?php
                     63: require_once("clean_table.inc");
                     64: ?>
                     65: --EXPECTF--
                     66: [005]
                     67: array(2) {
                     68:   [%u|b%"id"]=>
                     69:   %unicode|string%(1) "1"
                     70:   [%u|b%"label"]=>
                     71:   %unicode|string%(1) "a"
                     72: }
                     73: [006]
                     74: bool(false)
                     75: [008]
                     76: array(5) {
                     77:   [%u|b%"a"]=>
                     78:   %unicode|string%(1) "2"
                     79:   [%u|b%"c"]=>
                     80:   %unicode|string%(1) "3"
                     81:   [%u|b%"C"]=>
                     82:   %unicode|string%(1) "4"
                     83:   [%u|b%"d"]=>
                     84:   NULL
                     85:   [%u|b%"e"]=>
                     86:   %unicode|string%(1) "1"
                     87: }
                     88: 
                     89: Warning: mysql_fetch_assoc(): %d is not a valid MySQL result resource in %s on line %d
                     90: [010]
                     91: array(5) {
                     92:   [%u|b%"id"]=>
                     93:   %unicode|string%(1) "1"
                     94:   [%u|b%"label"]=>
                     95:   %unicode|string%(1) "a"
                     96:   [%u|b%"_id"]=>
                     97:   %unicode|string%(1) "1"
                     98:   [%u|b%"_label"]=>
                     99:   %unicode|string%(2) "aa"
                    100:   [%u|b%"_foo"]=>
                    101:   NULL
                    102: }
                    103: done!