imploding an array to echo a string

Question

I'm trying to print the values from an array as a string. I got this code from the PHP documents, but I'm getting a string conversion error. The values are numbers and I can see them

$viz_array_qry = "SELECT (`column_name`) FROM table_name WHERE option_name='$option_name'";
$result = mysql_query($viz_array_qry);
$result_array = array();
while($row = mysql_fetch_assoc($result))
{
    $result_array[] = $row;
    $viz_array = implode (',',$result_array);
}
    print_r($viz_array);

    //echo $viz_array;  <!-- no result-->

If I var_dump the $result_array I get the list of the values below. But I just want to display them as

0,0,57,39,40

I cant work out why the implode it not working?

 array (size=5)
 0 => 
   array (size=1)
     'column_name' => string '0' (length=1)
 1 => 
   array (size=1)
     'column_name' => string '0' (length=1)
 2 => 
   array (size=1)
     'column_name' => string '57' (length=2)
 3 => 
   array (size=1)
     'column_name' => string '39' (length=2)
 4 => 
   array (size=1)
     'column_name' => string '40' (length=2)

Justin Iurman · Accepted Answer · 2014-02-10 20:58:13Z

3

You should only store value of column_name ($row['column_name']) instead of $row (which is an array) and move implode outside of loop

while($row = mysql_fetch_assoc($result))
{
    $result_array[] = $row['column_name'];
}

echo implode(',', $result_array);

edited Feb 10, 2014 at 20:58

answered Feb 10, 2014 at 20:52

Justin Iurman

19k3 gold badges39 silver badges58 bronze badges

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

Comments

Jonathan Eltgroth · Accepted Answer · 2014-02-10 20:54:32Z

0

Implode after the While loop:

$viz_array_qry = "SELECT (`column_name`) FROM table_name WHERE option_name='$option_name'";
$result = mysql_query($viz_array_qry);
$result_array = array();

while($row = mysql_fetch_assoc($result))
{
 $result_array[] = $row;
}

$viz_array = implode (',',$result_array);
print_r($viz_array);

answered Feb 10, 2014 at 20:54

Jonathan Eltgroth

8296 silver badges21 bronze badges

Comments

Abhik Chakraborty · Accepted Answer · 2014-02-10 21:07:20Z

0

Even if you do not want to change the existing code and store the data in the array as you are doing you can use array_map() to get the result as you want as below

$arr = array(0=>array('column_name'=>'0'),1=>array('column_name'=>'0'),
3=>array('column_name'=>'57'),4=>array('column_name'=>'39'));

function get_col($col) {
    return $col["column_name"];
}

$values = implode(array_map("get_col", $arr), ',');

echo $values ;

answered Feb 10, 2014 at 21:07

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

3 Comments

Diamondo25 Over a year ago

Isn't that a workaround on a wrong implementation on his side? I think that adding 2 lines (an array that holds the IDs and the final implode the array) is easier and more understandable than your solution.

Abhik Chakraborty Over a year ago

Yes thats the reason I mentioned "Even if you do not want to change the existing code" if at all the array needs to be used for some other purpose.

conor909 Over a year ago

Ok, well I don't need that this time, but thanks for the info Abhik Chakraborty.

Collectives™ on Stack Overflow

imploding an array to echo a string

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related