在Codeigniter中针对id获取所有记录

问题描述：

When I retrieve the data from database the output is following

I want to fetch records against these id's but when I try in my controller with for each it gives me only 1 record back Here is my code

//fetch all the posts relative to user in session
    $post_id['id'] = $this->message_model->get_post($id);
    echo '<pre>'; print_r($post_id['id']);die;
     foreach ($post_id['id'] as $key) {

        $post_id    =     $key['post_id'];
        $results['post_list'] = $this->Model_Frontend_Posts->get($post_id);
    }

when i print $results['post_list'] it gives me only one record

当我从数据库中检索数据时，输出正在跟随 a > p>

我想要针对这些id获取记录但是当我在我的控制器中尝试每个时它只给我一条记录这是我的代码 p>

  //获取会话中与用户相关的所有帖子
 $ post_id ['id'] = $ this-＆gt; message_model-＆gt; get_post（$ id）; 
 echo'＆lt; pre＆gt;  “;  print_r（$ post_id ['id']）; die; 
 foreach（$ post_id ['id'] as $ key）{
 
 $ post_id = $ key ['post_id']; 
 $ results ['  post_list'] = $ this-＆gt; Model_Frontend_Posts-＆gt; get（$ post_id）; 
} 
  code>  pre> 
 
 当我打印 $ results ['post_list  ']  code>它只给我一条记录 p> 
  div>

答

Put it in an array so that it doesn't overrides on every loop. I guess this should solve it -

$results['post_list'][] = $this->Model_Frontend_Posts->get($post_id);

instead of

$results['post_list'] = $this->Model_Frontend_Posts->get($post_id);

答

$post_id['id'] = $this->message_model->get_post($id);
 $array = array_column($post_id['id'], 'post_id'));
     foreach ($array as $value) {
        $results['post_list'] = $this->Model_Frontend_Posts->get($value);
    }

Better to use array_column from the reference http://php.net/manual/en/function.array-column.php

在Codeigniter中针对id获取所有记录

相关推荐