mysqli_fetch_all.phpt

linux下安装不上mysql5与php5的可用此关联

    func_mysqli_fetch_all($link, $engine, "MEDIUMTEXT", chr(0) . "a", chr(0) . "a", 870);
    func_mysqli_fetch_all($link, $engine, "MEDIUMTEXT", NULL, NULL, 880);
    
    func_mysqli_fetch_all($link, $engine, "LONGBLOB", "a", "a", 890);
    func_mysqli_fetch_all($link, $engine, "LONGTEXT", chr(0) . "a", chr(0) . "a", 900);
    func_mysqli_fetch_all($link, $engine, "LONGBLOB", NULL, NULL, 910);
    
    func_mysqli_fetch_all($link, $engine, "ENUM('a', 'b')", "a", "a", 920);
    func_mysqli_fetch_all($link, $engine, "ENUM('a', 'b')", NULL, NULL, 930);
    
    func_mysqli_fetch_all($link, $engine, "SET('a', 'b')", "a", "a", 940);  
    func_mysqli_fetch_all($link, $engine, "SET('a', 'b')", NULL, NULL, 950);
        
    mysqli_close($link);
    
    if (null !== ($tmp = mysqli_fetch_array($res, MYSQLI_ASSOC)))
        printf("[015] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
        
    print "done!";
?>
--EXPECTF--
[005]
array(2) {
  [0]=>
  array(2) {
    [0]=>
    string(1) "1"
    [1]=>
    string(1) "a"
  }
  [1]=>
  array(2) {
    [0]=>
    string(1) "2"
    [1]=>
    string(1) "b"
  }
}
[007]
array(2) {
  [0]=>
  array(2) {
    [0]=>
    string(1) "1"
    [1]=>
    string(1) "a"
  }
  [1]=>
  array(2) {
    [0]=>
    string(1) "2"
    [1]=>
    string(1) "b"
  }
}
[008]
array(2) {
  [0]=>
  array(4) {
    [0]=>
    string(1) "1"
    ["id"]=>
    string(1) "1"
    [1]=>
    string(1) "a"
    ["label"]=>
    string(1) "a"
  }
  [1]=>
  array(4) {
    [0]=>
    string(1) "2"
    ["id"]=>
    string(1) "2"
    [1]=>
    string(1) "b"
    ["label"]=>
    string(1) "b"
  }
}
[010]
array(2) {
  [0]=>
  array(2) {
    ["id"]=>
    string(1) "1"
    ["label"]=>
    string(1) "a"
  }
  [1]=>
  array(2) {
    ["id"]=>
    string(1) "2"
    ["label"]=>
    string(1) "b"
  }
}
[011]
NULL
[013]
array(2) {
  [0]=>
  array(2) {
    ["id"]=>
    string(1) "1"
    ["label"]=>
    string(1) "a"
  }
  [1]=>
  array(2) {
    ["id"]=>
    string(1) "2"
    ["label"]=>
    string(1) "b"
  }
}
[016]
NULL
[017]
array(1) {
  [0]=>
  array(11) {
    [0]=>
    string(1) "1"
    ["a"]=>
    string(1) "2"
    [1]=>
    string(1) "2"
    [2]=>
    string(1) "3"
    ["c"]=>
    string(1) "3"
    [3]=>
    string(1) "4"
    ["C"]=>
    string(1) "4"
    [4]=>
    NULL
    ["d"]=>
    NULL
    [5]=>
    string(1) "1"
    ["e"]=>
    string(1) "1"
  }
}

Warning: mysqli_fetch_all(): Mode can be only MYSQLI_FETCH_NUM, MYSQLI_FETCH_ASSOC or MYSQLI_FETCH_BOTH in %s on line %d

Warning: mysqli_fetch_array(): Couldn't fetch mysqli_result in %s on line %d
done!
--UEXPECTF--
[005]
array(2) {
  [0]=>
  array(2) {
    [0]=>
    unicode(1) "1"
    [1]=>
    unicode(1) "a"
  }
  [1]=>
  array(2) {
    [0]=>
    unicode(1) "2"
    [1]=>
    unicode(1) "b"
  }
}
[007]
array(2) {
  [0]=>
  array(2) {
    [0]=>
    unicode(1) "1"
    [1]=>
    unicode(1) "a"
  }
  [1]=>
  array(2) {
    [0]=>
    unicode(1) "2"
    [1]=>
    unicode(1) "b"
  }
}
[008]
array(2) {
  [0]=>
  array(4) {
    [0]=>
    unicode(1) "1"
    [u"id"]=>
    unicode(1) "1"
    [1]=>
    unicode(1) "a"
    [u"label"]=>
    unicode(1) "a"
  }
  [1]=>
  array(4) {
    [0]=>
    unicode(1) "2"
    [u"id"]=>
    unicode(1) "2"
    [1]=>
    unicode(1) "b"
    [u"label"]=>
    unicode(1) "b"
  }
}
[010]
array(2) {
  [0]=>
  array(2) {
    [u"id"]=>
    unicode(1) "1"
    [u"label"]=>
    unicode(1) "a"
  }
  [1]=>
  array(2) {
    [u"id"]=>
    unicode(1) "2"
    [u"label"]=>
    unicode(1) "b"
  }
}
[011]
NULL
[013]
array(2) {
  [0]=>
  array(2) {
    [u"id"]=>
    unicode(1) "1"
    [u"label"]=>
    unicode(1) "a"
  }
  [1]=>
  array(2) {
    [u"id"]=>
    unicode(1) "2"
    [u"label"]=>
    unicode(1) "b"
  }
}
[016]
NULL
[017]
array(1) {
  [0]=>
  array(11) {
    [0]=>
    unicode(1) "1"
    [u"a"]=>
    unicode(1) "2"
    [1]=>
    unicode(1) "2"
    [2]=>
    unicode(1) "3"
    [u"c"]=>
    unicode(1) "3"
    [3]=>
    unicode(1) "4"
    [u"C"]=>
    unicode(1) "4"
    [4]=>
    NULL
    [u"d"]=>
    NULL
    [5]=>
    unicode(1) "1"
    [u"e"]=>
    unicode(1) "1"
  }
}

Warning: mysqli_fetch_all(): Mode can be only MYSQLI_FETCH_NUM, MYSQLI_FETCH_ASSOC or MYSQLI_FETCH_BOTH in %s on line %d

Warning: mysqli_fetch_array(): Couldn't fetch mysqli_result in %s on line %d
done!