如何在代码点火器中从带有参数的模型中获取数据 - How to get data from model with parameter in codeigniter

How to get data from model with parameter in codeigniter

大家好，我有一个关于从带参数的模型中获取数据的问题，我不能在视图中调用数据

这是我的型号

    function nilai_mahasiswa($ni_dos,$kd_smt,$kd_kls){
    $data_nilai_mahasiswa = $this->db->query("SELECT dat_jadwal_kuliah.ni_dos, dat_dosen.nama_dos, tab_mata_kuliah.nama_mt_klh, dat_krs.nim_mhs, dat_mahasiswa.nama_mhs, ".
        " dat_krs.kd_mt_klh, dat_krs.kd_kls, dat_krs.jml_hadir, dat_krs.nilai_tugas, dat_krs.nilai_uts, dat_krs.nilai_uas, dat_krs.nilai_akhir, ".
        " dat_krs.grade ".
        " FROM dat_jadwal_kuliah ".
        " INNER JOIN dat_krs ON (dat_jadwal_kuliah.kd_mt_klh = dat_krs.kd_mt_klh AND dat_jadwal_kuliah.kd_pst = dat_krs.kd_pst AND dat_jadwal_kuliah.kd_kls=dat_krs.kd_kls) ".
        " INNER JOIN dat_dosen ON dat_jadwal_kuliah.ni_dos = dat_dosen.ni_dos ".
        " INNER JOIN dat_mahasiswa ON dat_krs.nim_mhs = dat_mahasiswa.nim_mhs ".
        " INNER JOIN tab_mata_kuliah ON dat_krs.kd_mt_klh = tab_mata_kuliah.kd_mt_klh ".
        " WHERE dat_jadwal_kuliah.ni_dos='".$ni_dos."' AND dat_krs.kd_smt='".$kd_smt."' AND dat_krs.kd_kls='".$kd_kls."' ".
        " ORDER BY dat_krs.nim_mhs asc");
    return $data_nilai_mahasiswa;       
}

这是我的控制器

function inputnilai($ni_dos,$kd_smt,$kodemata,$kd_kls) {
    if($this->session->userdata('isLogin') == FALSE)
    {
        redirect('login/login_form');
    }else
    {
        $data['semester'] = "$kd_smt";
        $data['kelas'] = "$kd_kls";
        $data['kodemata'] = "$kodemata";
        $data['nidos'] = "$ni_dos";
        $this->load->model('m_jadwal','',TRUE);
        $user = $this->session->userdata('username');
        $data['pengguna'] = $this->m_login->dataPengguna($user);
        $data['kdsmtaktif'] = $this->m_login->smtaktif();
        $data['data_nilai_mahasiswa'] = $this->m_jadwal->nilai_mahasiswa($ni_dos,$kd_kls,$kd_smt);
        $this->load->view('aka_v',$data);
        $this->load->view('inputnilai_v',$data);
    }
}

最后这是我的观点

            <?php
            foreach($data_nilai_mahasiswa as $row)
            {
                echo $row['nim_mhs'];
                echo $row['nama_mhs'];
                echo "<br>";
            }
            ?>

问题是在您的视图部分$data_nilai_mahasiswa是一个数组，您将其元素提取为$row，但仍然使用$row作为数组$row['nim_mhs']，这是错误的。

你可以使用

        <?php
            foreach($data_nilai_mahasiswa as $row)
            {
                echo $row;
                echo "<br>";
            }
      // or 
           echo $data_nilai_mahasiswa['nim_mhs'];
            ?>