如何将PHP查询结果导入数组？

Question

I know this is insanely easy, but I'm a noob and not sure what I'm doing wrong here:

1: $mysqli = new mysqli('test', 'test', 'test', 'test');
2: if ($stmt = $mysqli->prepare($query)) {
3:     if (!$stmt->execute()) {
4:        $out .= "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
5:    }
6:    $out = $stmt->fetch_array();
7: } else {
8:   $out .= $mysqli->error;
9: }

I get a Fatal error: Call to undefined method mysqli_stmt::fetch_array() error on line 6.

Answer 1

You can use mysqli_stmt::get_result() if you have PHP 5.3 or greater, then use mysql_result::fetch_array():

$mysqli = new mysqli('test', 'test', 'test', 'test');
if ($stmt = $mysqli->prepare($query)) {
    if (!$stmt->execute()) {
        $out .= "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
    }
    $res = $stmt->get_result();
    while ($out = $res->fetch_array()) {
    }
else {
    $out .= $mysqli->error;
}

Also, you may want to check out all of the MySQL-Improved documentation.

You can also fetch all rows at once with mysqli_result::fetch_all().