how to store database values in an array with comma seperated values

Question

I am looking to store the database values which are already stored as id's and retrieve via a for each loop within an array.

I have tried something like this, but it is not working:

foreach ($list as $item)
{
     $commaSeparated = implode(',' , $item['id');
}
echo $commaSeparated;

Where item['id'] is the specific column pulled out of the query. If I use the $list variable, then I am getting the full result of the query which I do not want.

But, my error results in this:

Warning: implode(): Invalid arguments passed

This is what has correctly returned what I need:

foreach ($list as &$id)
        {

            $listArr[] = $id['toolbar_id'];

            $commaSeparated = implode(',' , $listArr)

                             echo $commaSeparated;

zerkms · Accepted Answer · 2011-08-31 01:44:43Z

2

That happens because you need to perform

$commaSeparated = implode(',' , $list);

It is not a good practice though. You should never store the lists as comma-separated items in database. Instead - create additional table for it and store 1 item per row.

answered Aug 31, 2011 at 1:44

zerkms

256k73 gold badges447 silver badges551 bronze badges

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

3 Comments

lockdown Over a year ago

I miscommunicated my issue. The items are coming from the database already. They are single id values. I am trying to store each one of these values which are pulled from a query into an array. Although if I use $list as the value to store in the array, it does not pull the specific column value as I would want. I will edit my question above.

zerkms Over a year ago

@Brandon Ellis: you need to rephrase your question obviously then

lockdown Over a year ago

Yes. I just have. My apologies.

Ted Hopp · Accepted Answer · 2011-08-31 01:44:12Z

2

The second argument to implode needs to be an array. Try this:

$commaSeparated = implode(',', $list);

answered Aug 31, 2011 at 1:44

Ted Hopp

235k48 gold badges412 silver badges533 bronze badges

Comments

CrociDB · Accepted Answer · 2011-08-31 01:44:36Z

2

Implode function accepts a separator and an array for parameters. Then you should do this:

$commaSeparated = implode(',' , $list);

echo $commaSeparated;

(Source: http://php.net/manual/pt_BR/function.implode.php)

answered Aug 31, 2011 at 1:44

CrociDB

1,2241 gold badge7 silver badges20 bronze badges

Comments

Gustav · Accepted Answer · 2011-08-31 02:15:56Z

0

You need to do more checks to avoid the error if your data is not in correct format.

if(is_array($list)){
    foreach ($list as $item)
    {
        if(is_array($item)) 
            $commaSeparated = implode(',' , $item);
    }
    echo $commaSeparated;
}

answered Aug 31, 2011 at 2:15

Gustav

2,9401 gold badge27 silver badges31 bronze badges

Comments

score 0 · Accepted Answer · 2011-08-31 02:57:35Z

0

I suggest you trying a var_dump($variable) where $variable is the ...variable, in which the data is stored, knowing its structure will tell you what data to expect and how to iterate over it.

edited Aug 31, 2011 at 2:57

answered Aug 31, 2011 at 2:06

user912695

Collectives™ on Stack Overflow

how to store database values in an array with comma seperated values

5 Answers 5

3 Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related