How to return an array fetched from MySQL in PHP

Question

I am trying to return an array called from a public function stored in a PHP file. The returned array I need to export is in JSON format. I have the below code for calling the array (which in other cases works), but the output is just Array (the sql in phpMyAdmin returns all data)

This is the public function that should return the array, stored in a general PHP class file.

public function getIssueList() {
    $sql = "select * from IssueData";
    $returnValue = array();

    $result = $this->conn->query($sql); // makes the connection and executes the sql

    if ($result != null) {
        $row = $result->fetch_array(MYSQLI_ASSOC);
        if (!empty($row)) {
            $returnValue = $row;
        }
    }

    return $returnValue;

}

Then I call the public function from below code:

$result = $dao->getIssueList(); //opens the connection and calls the public function

echo $result;

But the echo result I get is just the word "Array"

Above code works for other public functions, but it returns only one row and not multiple as I need in this case. Also I need to get the array as associative.

What might be wrong?

change $returnValue = $row; to $returnValue[] = $row; and echo $result; to print_r($result);. — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Nov 15, 2015 at 20:49
(1) ->fecth_array() -> Fetch a result row..., so if you want mulitiple rows you need to do a loop, and add each row to an array. (2) since return $returnValue; will return an array, you can't just echo $result;. You could use print_r($result); or var_dump($result) or ... — Sean
– Sean, Commented Nov 15, 2015 at 20:49

andrrs · Accepted Answer · 2015-11-15 20:45:22Z

1

You can json_encode (http://php.net/manual/en/function.json-encode.php)

echo json_encode($result);

answered Nov 15, 2015 at 20:45

andrrs

2,3093 gold badges17 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dennis Smink · Accepted Answer · 2015-11-15 20:47:28Z

0

You will have to return $result as json_encode($result), also, to fill your array correctly you have to do $returnValue[] = $row;

(You might want to do a while loop to fill your array)

answered Nov 15, 2015 at 20:47

Dennis Smink

4507 silver badges23 bronze badges

Comments

citysurrounded · Accepted Answer · 2015-11-15 20:59:46Z

0

To get multiple rows rather than just one, use a while loop:

if ($result != null) {
$row = $result->fetch_array(MYSQLI_ASSOC);
    while(!empy($row)){
        $returnValue = array_merge($returnValue, $row);
        $row = $result->fetch_array(MYSQLI_ASSOC);
    }
return $returnValue; 
}

answered Nov 15, 2015 at 20:59

citysurrounded

6744 silver badges8 bronze badges

1 Comment

Sean Over a year ago

why not just do while($row = $result->fetch_array(MYSQLI_ASSOC)){ $returnValue = array_merge($returnValue, $row);} instead of

$row = $result->fetch_array(MYSQLI_ASSOC); while(!empy($row)){ $returnValue = array_merge($returnValue, $row); $row = $result->fetch_array(MYSQLI_ASSOC); }

, as that is a lot of redundant code.

ToroLoco · Accepted Answer · 2015-11-15 21:05:01Z

0

ok mostly the problem was that I was using echo instead of print_r.

Also changed below code:

if ($result != null) {
    $row = $result->fetch_array(MYSQLI_ASSOC);
    if (!empty($row)) {
        $returnValue = $row;
    }
}

to:

if ($result != null) {
        while ($returnValue[] = $result->fetch_array(MYSQLI_ASSOC));
}

answered Nov 15, 2015 at 21:05

ToroLoco

5111 gold badge6 silver badges20 bronze badges

Collectives™ on Stack Overflow

How to return an array fetched from MySQL in PHP

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related