mysqli_fetch_array_oo.phpt

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

    func_mysqli_fetch_array($mysqli, $engine, "VARCHAR(255)", $string255, $string255, 590);
    func_mysqli_fetch_array($mysqli, $engine, "VARCHAR(65635)", $string65k, $string65k, 600);
    func_mysqli_fetch_array($mysqli, $engine, "VARCHAR(1) NOT NULL", "a", "a", 610);
    func_mysqli_fetch_array($mysqli, $engine, "VARCHAR(1)", NULL, NULL, 620);
    
    func_mysqli_fetch_array($mysqli, $engine, "BINARY(1)", "a", "a", 630);
    func_mysqli_fetch_array($mysqli, $engine, "BINARY(2)", chr(0) . "a", chr(0) . "a", 640);
    func_mysqli_fetch_array($mysqli, $engine, "BINARY(1) NOT NULL", "b", "b", 650);
    func_mysqli_fetch_array($mysqli, $engine, "BINARY(1)", NULL, NULL, 660);
    
    func_mysqli_fetch_array($mysqli, $engine, "VARBINARY(1)", "a", "a", 670);
    func_mysqli_fetch_array($mysqli, $engine, "VARBINARY(2)", chr(0) . "a", chr(0) . "a", 680);
    func_mysqli_fetch_array($mysqli, $engine, "VARBINARY(1) NOT NULL", "b", "b", 690);
    func_mysqli_fetch_array($mysqli, $engine, "VARBINARY(1)", NULL, NULL, 700);
    
    func_mysqli_fetch_array($mysqli, $engine, "TINYBLOB", "a", "a", 710);
    func_mysqli_fetch_array($mysqli, $engine, "TINYBLOB", chr(0) . "a", chr(0) . "a", 720);
    func_mysqli_fetch_array($mysqli, $engine, "TINYBLOB NOT NULL", "b", "b", 730); 
    func_mysqli_fetch_array($mysqli, $engine, "TINYBLOB", NULL, NULL, 740);
    
    func_mysqli_fetch_array($mysqli, $engine, "TINYTEXT", "a", "a", 750);
    func_mysqli_fetch_array($mysqli, $engine, "TINYTEXT NOT NULL", "a", "a", 760);
    func_mysqli_fetch_array($mysqli, $engine, "TINYTEXT", NULL, NULL, 770);
    
    func_mysqli_fetch_array($mysqli, $engine, "BLOB", "a", "a", 780);
    func_mysqli_fetch_array($mysqli, $engine, "BLOB", chr(0) . "a", chr(0) . "a", 780);
    func_mysqli_fetch_array($mysqli, $engine, "BLOB", NULL, NULL, 790);
       
    func_mysqli_fetch_array($mysqli, $engine, "TEXT", "a", "a", 800);
    func_mysqli_fetch_array($mysqli, $engine, "TEXT", chr(0) . "a", chr(0) . "a", 810);
    func_mysqli_fetch_array($mysqli, $engine, "TEXT", NULL, NULL, 820);
    
    func_mysqli_fetch_array($mysqli, $engine, "MEDIUMBLOB", "a", "a", 830);
    func_mysqli_fetch_array($mysqli, $engine, "MEDIUMBLOB", chr(0) . "a", chr(0) . "a", 840);
    func_mysqli_fetch_array($mysqli, $engine, "MEDIUMBLOB", NULL, NULL, 850);
    
    func_mysqli_fetch_array($mysqli, $engine, "MEDIUMTEXT", "a", "a", 860);
    func_mysqli_fetch_array($mysqli, $engine, "MEDIUMTEXT", chr(0) . "a", chr(0) . "a", 870);
    func_mysqli_fetch_array($mysqli, $engine, "MEDIUMTEXT", NULL, NULL, 880);
    
    func_mysqli_fetch_array($mysqli, $engine, "LONGBLOB", "a", "a", 890);
    func_mysqli_fetch_array($mysqli, $engine, "LONGTEXT", chr(0) . "a", chr(0) . "a", 900);
    func_mysqli_fetch_array($mysqli, $engine, "LONGBLOB", NULL, NULL, 910);
    
    func_mysqli_fetch_array($mysqli, $engine, "ENUM('a', 'b')", "a", "a", 920);
    func_mysqli_fetch_array($mysqli, $engine, "ENUM('a', 'b')", NULL, NULL, 930);
    
    func_mysqli_fetch_array($mysqli, $engine, "SET('a', 'b')", "a", "a", 940);  
    func_mysqli_fetch_array($mysqli, $engine, "SET('a', 'b')", NULL, NULL, 950);
        
    $mysqli->close();
    
    if (null !== ($tmp = $res->fetch_array(MYSQLI_ASSOC)))
        printf("[015] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
        
    print "done!";
?>
--EXPECTF--
[005]
array(4) {
  [0]=>
  string(1) "1"
  ["id"]=>
  string(1) "1"
  [1]=>
  string(1) "a"
  ["label"]=>
  string(1) "a"
}
[006]
array(2) {
  [0]=>
  string(1) "2"
  [1]=>
  string(1) "b"
}
[007]
array(4) {
  [0]=>
  string(1) "3"
  ["id"]=>
  string(1) "3"
  [1]=>
  string(1) "c"
  ["label"]=>
  string(1) "c"
}
[008]
array(2) {
  ["id"]=>
  string(1) "4"
  ["label"]=>
  string(1) "d"
}
[009]
array(4) {
  [0]=>
  string(1) "5"
  ["id"]=>
  string(1) "5"
  [1]=>
  string(1) "e"
  ["label"]=>
  string(1) "e"
}
[011]
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_result::fetch_array(): The result type should be either MYSQLI_NUM, MYSQLI_ASSOC or MYSQLI_BOTH in %s on line %d

Warning: mysqli_result::fetch_array(): The result type should be either MYSQLI_NUM, MYSQLI_ASSOC or MYSQLI_BOTH in %s on line %d

Warning: mysqli_result::fetch_array(): Couldn't fetch mysqli_result in %s on line %d
done! 
--UEXPECTF--
[005]
array(4) {
  [0]=>
  unicode(1) "1"
  [u"id"]=>
  unicode(1) "1"
  [1]=>
  unicode(1) "a"
  [u"label"]=>
  unicode(1) "a"
}
[006]
array(2) {
  [0]=>
  unicode(1) "2"
  [1]=>
  unicode(1) "b"
}
[007]
array(4) {
  [0]=>
  unicode(1) "3"
  [u"id"]=>
  unicode(1) "3"
  [1]=>
  unicode(1) "c"
  [u"label"]=>
  unicode(1) "c"
}
[008]
array(2) {
  [u"id"]=>
  unicode(1) "4"
  [u"label"]=>
  unicode(1) "d"
}
[009]
array(4) {
  [0]=>
  unicode(1) "5"
  [u"id"]=>
  unicode(1) "5"
  [1]=>
  unicode(1) "e"
  [u"label"]=>
  unicode(1) "e"
}
[011]
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_result::fetch_array(): The result type should be either MYSQLI_NUM, MYSQLI_ASSOC or MYSQLI_BOTH in %s on line %d

Warning: mysqli_result::fetch_array(): The result type should be either MYSQLI_NUM, MYSQLI_ASSOC or MYSQLI_BOTH in %s on line %d

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