Collect and implode column values from multiple query result sets in a CodeIgniter query

Question

I have an array of the following format:

$var = Array
     ( 
     [0] => Array
         (
        [name] => Harry
          )

      [1] => Array
         (
        [name] => Wayne
          )

      )
 Array
     (
     [0] => Array
         (
        [name] => Wayne
         )

I want to implode this array such that i get it in the format:

 Harry,Wayne
 Wayne

From What I have Tried I am getting it in format:

Harry,Wayne
Harry,Wayne,Wayne

What I have Tried (Not important as its wrong)

foreach($var as $a){
 foreach($a as $b){
 }$c[] = $b
   }
 $imp = implode(',',$c);

$var is fetched from database using fetch_array.

    $this->db->select('name');
    $this->db->where('id', $Id);
    $this->db->from('info');
    $row = $this->db->get();
    $var = $row->result_array();

where $Id is array containing certain user ids.

What about the second array block? it is a different array right? or what? — Praveen Puglia
– Praveen Puglia, Commented Jan 2, 2013 at 5:29

Supericy · Accepted Answer · 2013-01-02 05:37:11Z

1

foreach($var as $a)
{
    unset($temp);
    foreach($a as $b)
    {
        $temp[] = $b['name'];
    }
    $c[] = implode(",", $temp);
}

// output all the names
foreach ($c as $csvNames)
{
    echo $csvNames;
}

answered Jan 2, 2013 at 5:37

Supericy

5,8911 gold badge23 silver badges25 bronze badges

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

Comments

Sahal · Accepted Answer · 2013-01-02 05:30:43Z

0

Try this.

foreach($var as $a){
  $m = '';
  $delim = '';
  foreach($a as $k){
     $m .= $delim . $k['name'];
     $delim = ',';
  }

  $c[] = $m;
}

foreach($c as $d){
  echo $d;
}

answered Jan 2, 2013 at 5:30

Sahal

4,15616 gold badges45 silver badges72 bronze badges

1 Comment

Sahal Over a year ago

@Venu, it is always better to have your own algo rather than using built in functions. That will not only increase your skills but also it increase your finding solutions skills

Abby Chau Yu Hoi · Accepted Answer · 2013-01-02 05:46:40Z

0

Please ignore those hard-coded loops. There is a recursive function for it.

array_walk_recursive($var, create_function('$val, $key', 'array_push($obj, $val);'), &$output);
echo implode(",",$output);

answered Jan 2, 2013 at 5:46

Abby Chau Yu Hoi

1,4083 gold badges16 silver badges38 bronze badges

Comments

mickmackusa · Accepted Answer · 2024-10-06 01:37:04Z

Your question says

where $Id is array containing certain user ids.

Well, CodeIgniter's query builder method where() is not designed to receive an array in the way that you are scripting it. I can only assume that you are making iterated trips to the database -- that us both bad practice and avoidable.

To return a flat array of column values from your database query, use where_in() then array_column() on the result set.

The imploding step is likely to be a job for the presentation layer, so defer that process for the view layer.

return array_column(
    $this->db
        ->where_in('id', $ids)
        ->get('name')
        ->result(),
    'name'
);

This will return a flat array of all names from qualifying rows via a single trip to the database.

Collectives™ on Stack Overflow

Collect and implode column values from multiple query result sets in a CodeIgniter query

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related