代码点火器返回数组


Codeigniter return array

如何返回数组?这是我的代码(这在模型内部)

function getTeacherSchedule($id){
        $sections = $this->dbsections->query('SELECT * FROM sections;');
        foreach ($sections->result_array() as $section){
            $table = $section['NAME'];
            $tblsection = str_replace(array(' ', '-'),'_', $table);
            $schedule = ($this->dbsections->query('SELECT * FROM '.$tblsection.' WHERE TEACHER = '.$id));
            $result = $schedule->result_array();
        }
        return $result;
    }

我希望$schedule的result_array()在控制器中返回,但当我尝试var_dump()它时,它只返回一条记录。

当前,您正在存储一条记录,并在每个循环中覆盖它。尝试-

function getTeacherSchedule($id){
    $sections = $this->dbsections->query('SELECT * FROM sections;');
    foreach ($sections->result_array() as $section){
        // rest of the code
        // .......
        $result[] = $schedule->result_array();
    }
    return $result;
}