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 | } |
