如何使用codeigniter中的左连接的活动记录显示来自两个不同表的字段？

Question

function get_all_notification() { //get all notification based on the 'notification' table left join by 'membership' table

    $this->db->select()->from('notification')->join('membership','membership.membership_id = notification.notif_id','left');            $notif = $this->db->get();
    return $notif->result();
}

I cannot display the fields from membership table.

Answer 1

Try this

function get_all_notification() { //get all notification based on the 'notification' table left join by 'membership' table

    $this->db->select('*')->from('notification')->join('membership','membership.membership_id = notification.notif_id','left');
    $notif = $this->db->get();
    return $notif->result();
}