Return a flat array of column values from a CodeIgniter active record query

Question

im returning data back from my db using codeigniter's database class , is there anyway I can put it into the same array without having to do additional array_merge logic after the loop completes?

foreach ($saved_forms[0] as $key => $value) {
     $this->db->select('form_text');
     $this->db->from('form_labels');
     $this->db->where('form_label', $key);
     $query = $this->db->get();
        
     $form_names = $query->result_array();
     $form_titles[] = $form_names;
}

result array

[4] => Array
    (
        [0] => Array
            (
                [form_text] => Participant Name
            )    
    )    
[5] => Array
    (
        [0] => Array
            (
                [form_text] => Date of Birth
            )    
    )

What I want:

 [0] => Array
       (
        [form_text] => Participant Name
        [form_text] => Date of Birth
       )

omma2289 · Accepted Answer · 2013-09-06 19:57:09Z

3

Try this

$query = $this->db->select('form_text')
         ->from('form_labels');
         ->where_in('form_label', array_keys($saved_forms[0]));
         ->get();

foreach( $query->result as $label){
   $form_titles[] = $label->form_text;
}

It will produce a single array with the texts

answered Sep 6, 2013 at 19:57

omma2289

54.7k8 gold badges66 silver badges68 bronze badges

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

2 Comments

Undermine2k Over a year ago

can you comment on if this is faster then me doing array_walk_recursive($array, function($a) use (&$return) { $return[] = $a; }); ?

omma2289 Over a year ago

@Undermine2k Honestly I'm not sure, maybe you'll be interested in this php.net/manual/en/function.array-walk.php#112722, if it was me though I would use the foreach because it's simpler

Adriano Rosa · Accepted Answer · 2014-11-25 05:25:57Z

2

When Running PHP 5 >= 5.5.0 you can achieve this with the built-in function array_column()

$form_names = $query->result_array();
$my_array = array_column($form_names, 'form_text');

Produces:

Array ( 
 [0] => Participant Name 
 [1] => Date of Birth 
)

answered Nov 25, 2014 at 5:25

Adriano Rosa

8,8311 gold badge29 silver badges25 bronze badges

Comments

Derek · Accepted Answer · 2013-09-06 19:31:30Z

1

Replace $form_titles[] = $form_names; with $form_titles[] = $form_names["form_text"];

answered Sep 6, 2013 at 19:31

Derek

3,4351 gold badge20 silver badges35 bronze badges

Comments

M Khalid Junaid · Accepted Answer · 2013-09-06 19:35:41Z

1

Simple use the where_in() use foreach to get all the keys and run your query in a go and get rid of running query again and again

$keys=array();
foreach ($saved_forms[0] as $key => $value) {         
    $keys[] = $key;    
}

$this->db->select('form_text');
$this->db->from('form_labels');    
$this->db->where_in('form_label', $keys); 
// or $this->db->or_where_in();   
$query = $this->db->get();
$form_names  = $query->result_array();

answered Sep 6, 2013 at 19:35

M Khalid Junaid

64.6k10 gold badges93 silver badges120 bronze badges

1 Comment

Undermine2k Over a year ago

this removes the outer array layer but still gives me an extra level I don't need:

(     [0] => Array         (             [form_text] => Participant Name         )      [1] => Array         (             [form_text] => Date of Birth         )

mickmackusa · Accepted Answer · 2024-09-24 07:20:31Z

0

Most succinctly, fetch all qualifying rows associated with the $saved_forms[0] keys, then return the form_labels column from that array of zero or more objects. This will return a flat, indexed array of form_text values.

return array_column(
    $this->db
        ->where_in('form_label', array_keys($saved_forms[0]));
        ->get('form_labels')
        ->result(),
    'form_text'
);

answered Sep 24, 2024 at 7:20

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

Collectives™ on Stack Overflow

Return a flat array of column values from a CodeIgniter active record query

result array

5 Answers 5

2 Comments

Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

result array

5 Answers 5

2 Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related