SHOW:
|
|
- or go back to the newest paste.
1 | <?php | |
2 | $data = array(); | |
3 | ||
4 | /* | |
5 | - | versi 2 pake ini |
5 | + | versi 1 pake ini |
6 | - | $this->db->where('nilai.id_ygdinilai = user.id_user'); |
6 | + | ->join('user usr_nilai', 'n.id_ygdinilai = usr_nilai.id_user') |
7 | - | $this->db->where('nilai.id_penilai = user.id_user'); |
7 | + | ->join('user usr_guru', 'n.id_penilai = usr_guru.id_user'); |
8 | ||
9 | - | $this->db->join('user usr_nilai', 'n.id_ygdinilai = usr_nilai.id_user')->join('user usr_guru', 'n.id_penilai = usr_guru.id_user'); |
9 | + | |
10 | $this->db | |
11 | - | $this->db->select('n.*, usr_guru.nama guru_nama, usr_nilai user_nama')->from('nilai n'); |
11 | + | ->where('n.id_ygdinilai = usr_nilai.id_user') |
12 | ->where('n.id_penilai = usr_guru.id_user'); | |
13 | ||
14 | $this->db->order_by('n.id_nilai', 'desc'); | |
15 | $this->db | |
16 | ->select('n.*, usr_guru.nama guru_nama, usr_nilai user_nama') | |
17 | ->from('nilai n,user usr_nilai,user usr_guru'); | |
18 | ||
19 | $Q = $this->db->get(); | |
20 | ||
21 | if ($Q->num_rows() > 0) { | |
22 | foreach ($Q->result_array() as $row) { | |
23 | $data[] = $row; | |
24 | } | |
25 | } |