php - 消息: Undefined variable and Invalid argument supplied for foreach() in Codeigniter

Question

帮助我..我在 View 中收到错误消息: undefined variable :pekawai和消息:foreach()的参数无效。我想显示 mysql 表中的所有条目，但我不断收到错误消息。我是 Codeigniter 的新手，无法真正弄清楚如何解决这个问题。

我的 Controller

<?php

    class Perolehan_Dana extends CI_Controller
    {

        function __construct()
        {
            parent::__construct();
            //checkAksesModule();
            if($this->session->userdata('id_user') != TRUE){
            redirect(base_url(''));
            exit;
            };
            $this->load->helper(array('url'));
            $this->load->library('ssp');
            $this->load->model('model_perolehan_dana');
        }

        function pegawai($value='')
        {

            $data = array('data'  =>$this->model_perolehan_dana->pegawai(),);
            tpl('perolehan_dana/view', $data);
        }

}

我的模型

<?php

    class Model_perolehan_dana extends CI_Model
    {

        public $table = "tbl_perolehan_dana";

        function pegawai()
        {
            return $this->db->query("SELECT * from tbl_perolehan_dana a, tbl_sumber_dana b, tbl_jenis_dana c where a.sumber_dana=b.id_sumber_dana AND c.id_sumber_dana=a.jenis_dana group by a.id");
        }

    }

?>

我的看法

<?php $no=1; foreach($pegawai as $admin): ?>
       <tr>
       <td><?= $no ?></td>
       <td><?= $admin['sumber_dana'] ?></td> 
       <td><?= $admin['jenis_dana'] ?></td>
       <td><?= $admin['tahun_anggaran'] ?></td>
       <td><?= $admin['jml_rp'] ?></td>
       <td><a href="<?= base_url('admin/pegawai_edit/'.$admin['id']) ?>" class="btn btn-info">Edit</a> <a href="<?= base_url('admin/pegawai_hapus/'.$admin['id']) ?>" class="btn btn-danger">Hapus</a></td> 
       </tr>
       <?php $no++; endforeach; ?>

请帮助我。谢谢你。

Answer 1

请尝试以下代码
Controller :

function pegawai($value='')
{
   $data = array();
   $data['pegawai'] = $this->model_perolehan_dana->pegawai();
   tpl('perolehan_dana/view', $data);
}

型号:

function pegawai()
{
   return $this->db->query("SELECT * from tbl_perolehan_dana a, tbl_sumber_dana b, tbl_jenis_dana c where a.sumber_dana=b.id_sumber_dana AND c.id_sumber_dana=a.jenis_dana group by a.id")->result_array();
}

查看:

<?php if(!empty($pegawai)) { ?>
<?php $no=1; foreach($pegawai as $admin): ?>
       <tr>
       <td><?= $no ?></td>
       <td><?= $admin['sumber_dana'] ?></td> 
       <td><?= $admin['jenis_dana'] ?></td>
       <td><?= $admin['tahun_anggaran'] ?></td>
       <td><?= $admin['jml_rp'] ?></td>
       <td><a href="<?= base_url('admin/pegawai_edit/'.$admin['id']) ?>" class="btn btn-info">Edit</a> <a href="<?= base_url('admin/pegawai_hapus/'.$admin['id']) ?>" class="btn btn-danger">Hapus</a></td> 
       </tr>
       <?php $no++; endforeach; ?>
<?php } ?>