duanrenzou1619 2015-11-20 11:17
浏览 45
已采纳

无法从Codeigniter中的foreach循环中的两个表中获取记录

I am working on Codeigniter and i have following tables, i want that first one subject name to be printed then all its sub-subjects and so on as given below :

Subjects:

-----------------------
id |     Subjects Name 
----------------------- 
1  |     Mathematics
2  |     Physics
3  |     Chemistry 

Subsections:

---------------------------------------------
id | subject_id    |   SubsectionsName
---------------------------------------------
1        2             Electromagnetism
2        1                 Algebra
3        3             Organic Chemistry
4        1           Geometry and Topology
5        2                 Mechanics

I want following output

Mathematics
 Algebra
 Geometry and Topology
Physics
 Electromagnetism
 Mechanics
Chemistry
 Organic Chemistry

for that i am using following code but it is not giving me correct output.

$condition = "id =" . "'" . $subject_id . "'";
$this->db->select('*');
$this->db->from('subject');
$this->db->where($condition);
$query = $this->db->get();

if ($query->num_rows() > 0) {

    foreach($query->result_array() as $row)
    {  
        $rows[] = $row;
        $condition = "subject_id =" . "'" . $row['id'] . "'";
        $this->db->select('*');
        $this->db->from('subsections');
        $this->db->where($condition);
        $query_course_material = $this->db->get();
        foreach($query->result_array() as $row1)
        {
          $rows[] = $row1;
        }

    }
    return $rows;

} else {
return false;
}
  • 写回答

1条回答 默认 最新

  • dongxi1965 2015-11-20 11:22
    关注

    Inner foreach is having incorrect variable. It should have $query_course_material instead of $query. Please check below :

    $query_course_material = $this->db->get();
    foreach($query_course_material->result_array() as $row1)
    {
       $rows[] = $row1;
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 有人能看一下我宿舍管理系统的报修功能该怎么改啊?链表那里总是越界
  • ¥15 cs loadimage运行不了,easyx也下了,没有用
  • ¥15 r包runway详细安装教程
  • ¥15 Html中读取Json文件中数据并制作表格
  • ¥15 谁有RH342练习环境
  • ¥15 STM32F407 DMA中断问题
  • ¥15 uniapp连接阿里云无法发布消息和订阅
  • ¥25 麦当劳点餐系统代码纠错
  • ¥15 轮班监督委员会问题。
  • ¥20 关于变压器的具体案例分析