>im 使用 codeigniter 的数据库类从我的数据库返回数据,无论如何我可以将其放入同一个数组中而无需在循环完成后执行额外的array_merge逻辑?
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;
}
结果数组
[4] => Array
(
[0] => Array
(
[form_text] => Participant Name
)
)
[5] => Array
(
[0] => Array
(
[form_text] => Date of Birth
)
)
我想要什么 :
[0] => Array
(
[form_text] => Participant Name
[form_text] => Date of Birth
)
试试这个
$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;
}
它将生成一个带有文本的数组
当运行 PHP 5>= 5.5.0 时,您可以使用内置函数来实现此目的array_column()
$form_names = $query->result_array();
$my_array = array_column($form_names, 'form_text');
生产:
Array (
[0] => Participant Name
[1] => Date of Birth
)
将$form_titles[] = $form_names;
替换为$form_titles[] = $form_names["form_text"];
简单使用
where_in()
foreach 获取所有键并一次性运行查询,摆脱一次又一次地运行查询
$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();