使用PHP在Codeigniter中连接两个表

Question

I am trying to join two tables and return an array in my Model method in CodeIgniter with php. I've gone through a few previously posted similar questions on stackoverflow and modified my code accordingly. But they don't seem to work. Hence would love to know what's wrong with the following.

I'm using the following method but am currently getting exceptions. Would appreciate suggestions in this regard.

Model Method

public function getUserDetails($username)
{
    $uid = $this->getUserUid($username);
    $this->db->select('s.uid, s.name,s.phone, s.studentId, s.type, sp.profiledesc, sp.age');
    $this->db->from('sysuser as s');
    $this->db->join('studentprofile as sp', 's.uid = sp.uid', 'left');
    $this->db->where(array('s.uid' => $uid));
    $query = $this->db->get();
    return $query->result();
}

Controller

$data1['details'] = $this->userModel->getUserDetails($username);
$this->load->view('studentDashboard/viewProfile',$data1);

View

...
<h2>
   <?php foreach($details as $detail){?>
        <?php echo $detail->s.name;?>
   <?php }?>
</h2>
...

In the view, I've also tried just echoing $detail->name but this doesn't work either.

Answer 1

1. At first, use print_r($details) for checking your data. If it's returning anything or not.

2. Then echo your value like this $detail['name']