如何使用逗号分隔值在数组中存储数据库值

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;

Answer 1

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.