php - 使用 codeigniter 对查询执行 foreach？

Question

我正在尝试使用 codeigniter 在我的模型上执行 foreach，但它给我一个错误并返回结果。

代码如下:

public function read(){
        $questions; //array
        $query = $this->db->get('questions');
        foreach($query->result() as $row){
            $getAnswers = $this->db->get_where('answers', array('question_id'=>$row['question_id]']), 4);
            $questions= $getAnswers;

           }

        return $questions;
     }

这是错误:

Fatal error: Cannot use object of type stdClass as array in

Answer 1

将 row 作为对象访问:

$getAnswers = $this->db->get_where('answers', 
                   array('question_id'=>$row->question_id), 4);