PHP Implode打印“数组”而不是值

Question

Below is the PHP code to retrieve data:

<?php
$sql = $myquery;
$result = $conn->query($sql);

$QueryArray = array();
if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {

    $QueryArray[] = Array($row["Column1"], $row["Column2"], $row["Column3"]);

    }

} else {

}
?>

And on the HTML side:

<textarea style="width:100%; height:50%; resize:none; rows="5" cols="40">
<?php 
$output = implode("
" , $QueryArray);
echo $output;
?>
</textarea>

However the below query prints:

Array
Array
Array
Array
..etc

Not sure where code is going wrong.

Answer 1

As you can see $QueryArray is an array of arrays

$QueryArray[] = Array($row["Column1"], $row["Column2"], $row["Column3"]);

You can access the $queryArray elements (array), in a foreach loop. Than use implode to print what you want.

<textarea style="width:100%; height:50%; resize:none; rows="5" cols="40">
<?php
$output = '';
foreach($array in $QueryArray) {
    $output .= implode("
" , $array);
}
echo $output;
?>
</textarea>

I hope it helps