php - CodeIgniter 打印关系数据

Question

我正在查看 CodeIgniter 文档，只找到一种方法来获取整个表，我正在寻找一种方法来获取 UserID 和 CourseTitle来自不同但相关表的一行中的列。

我有这个表:

用户表

UserID | CourseID

CourseID这里是外键

类(class)表

CourseID | CourseTitle

这里的CourseID为主键

Controller :

public function index(){     
    $data['news'] = $this->news_model->user_Call();
    $data['title'] = 'News archive';
    $this->load->view('templates/header', $data);
    $this->load->view('news/index', $data);
    $this->load->view('templates/footer');
}

型号:

public function user_Call(){
   $query = $this->db->get('news');    
   $query = $this->db->get('news');
   return $query->result_array();    
}

查看:

<?php foreach ($news as $news_item): ?>
    <h2><?php echo $news_item['title'] ?></h2>
    <div id="main">
        <?php echo $news_item['text'] ?>
    </div>
<?php endforeach ?>

Answer 1

看看下面我为您制作的函数示例。试试吧。

public function user_Call()
{
   $this->db->select('u.UserID,c.CourseTitle', false);
   $this->db->from('User_table AS u');
   $this->db->join('Course_table AS c', 'c.CourseID = u.CourseID');
   $query = $this->db->get();
   return $query->result_array();    
}