mysqli_fetch_array_assoc.phpt

来自「linux下安装不上mysql5与php5的可用此关联」· PHPT 代码 · 共 59 行

--TEST--
mysqli_fetch_array()
--SKIPIF--
<?php require_once('skipif.inc'); ?>
<?php require_once('skipifemb.inc'); ?>
--FILE--
<?php
    include "connect.inc";
    require('table.inc');    
    if (!$res = mysqli_query($link, "SELECT * FROM test ORDER BY id LIMIT 5")) {
        printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
    }    
    print "[002]\n";
    var_dump(mysqli_fetch_array($res, MYSQLI_ASSOC));
    mysqli_free_result($res);
    
    if (!$res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id LIMIT 5")) {
        printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
    }    
    print "[004]\n";
    var_dump(mysqli_fetch_array($res, MYSQLI_ASSOC));
    mysqli_free_result($res);
    
    mysqli_close($link);
    print "done!";
?>
--EXPECTF--
[002]
array(2) {
  ["id"]=>
  string(1) "1"
  ["label"]=>
  string(1) "a"
}
[004]
array(2) {
  ["id"]=>
  string(1) "1"
  ["label"]=>
  string(1) "a"
}
done! 
--UEXPECTF--
[002]
array(2) {
  [u"id"]=>
  unicode(1) "1"
  [u"label"]=>
  unicode(1) "a"
}
[004]
array(2) {
  [u"id"]=>
  unicode(1) "1"
  [u"label"]=>
  unicode(1) "a"
}
done!