PHP Implode Prints "Array" instead of value

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("\n" , $QueryArray);
echo $output;
?>
</textarea>

However the below query prints:

Array
Array
Array
Array
..etc

Not sure where code is going wrong.

It's an array of arrays. Implode doesn't flatten it to be one dimensional. — John Conde
– John Conde, Commented Sep 28, 2015 at 19:37
how about implodeing: $QueryArray[] =$row["Column1"].' '.$row["Column2"].' '.$row["Column3"]); — user557846
– user557846, Commented Sep 28, 2015 at 19:39

nessuno · Accepted Answer · 2015-09-28 19:40:27Z

3

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("\n" , $array);
}
echo $output;
?>
</textarea>

I hope it helps

answered Sep 28, 2015 at 19:40

nessuno

27.1k5 gold badges87 silver badges78 bronze badges

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

3 Comments

nessuno Over a year ago

You're right @Dagon. My solution is only a dirty fix. The better way is to create a mono dimensional array, concatenating resulting rows with a "\n", in that way: $row["Column1"]. "\n". $row["Column2"]. "\n" .$row["Column3"]

user557846 Over a year ago

quick? this is a slower fix

user5174952 Over a year ago

@nessuno I prefer simple over complex, which is what Dagon provided, thanks anyway

maikelm · Accepted Answer · 2015-09-28 20:10:37Z

0

In your code $QueryArray is a array of array. if your field count are know, simply you can:

<?php 
$sql = $myquery;
$result = $conn->query($sql);
if ($result->num_rows > 0) {
   while($row = $result->fetch_assoc()) {
      $QueryArray[] = $row["Column1"];
      $QueryArray[] = $row["Column2"];
      $QueryArray[] = $row["Column3"];
}
} else {}
?>

answered Sep 28, 2015 at 20:10

maikelm

4036 silver badges31 bronze badges

Comments

Cereais · Accepted Answer · 2021-11-09 15:49:58Z

0

This is an old question but someone might need the answer.

echo "<pre>";
print_r($QueryArray);
echo "</pre>";

answered Nov 9, 2021 at 15:49

Cereais

451 silver badge9 bronze badges

1 Comment

mickmackusa Over a year ago

Is this actually the answer to how to implode a string?

Collectives™ on Stack Overflow

PHP Implode Prints "Array" instead of value

3 Answers 3

3 Comments

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

1 Comment

Related