在编码器点火器中从两个不同的模型中检索数据，并在一个视图中显示这些数据 - Retrieving data from two different models in codeigniter and showing it in one view

Retrieving data from two different models in codeigniter and showing it in one view

我是CI的新手，我想知道如何从不同的模型但相同的视图中检索数据。

我有两个模型，一个用于费用评估的明细

，另一个是费用评估明细的总价。

    function result_getAssessment($studentid)
            {
                $sql=
                "
                select g.studentid, sb.subjectcode, s.price
                FROM grades g
                INNER JOIN subjectblocking sb ON g.blockcode=sb.blockcode
                INNER JOIN subjects s ON sb.subjectcode=s.subjectcode
                WHERE studentid='$studentid'
                ";
                $result = $this->db->query($sql);
                $result = $result->result();
                return $result; 
            }
function result_totalAssessment($studentid)
        {
            $sql=
            "
            SELECT sum(s.numofunit) total_units, sum(s.price) total_tuition FROM subjects s
            INNER JOIN subjectblocking sb ON s.subjectcode=sb.subjectcode
            INNER JOIN grades g ON sb.blockcode=g.blockcode
            WHERE g.studentid='$studentid'
            ";
            $result = $this->db->query($sql);
            $result = $result->result();
            return $result; 
        }

我的控制器：

 function getAssessment() 
{
   $this->load->view('header');
   $this->load->view('navbar');
   $this->load->view('sidebar');
   $this->load->view('footer');
   $studentid = $this->session->userdata('studentid');
   $data['studentid'] = $studentid;
   $data['query'] = $this->m_login->result_getAssessment($studentid);
   $this->load->view('v_assessment',$data);
   $this->gettotalAssessment();
}
  function gettotalAssessment() 
{
   $studentid = $this->session->userdata('studentid');
   $data['studentid'] = $studentid;
   $data['query'] = $this->m_login->result_totalAssessment($studentid);
   $this->load->view('v_assessment',$data);
}

我的观点：

<?php foreach ($query as $row){ ?>
              <tr>
              <td> <?php echo $row->subjectcode;?> <br></td>
              <td> <?php echo $row->price;?><br></td>
              <td> <?php echo $row->total_tuition;?><br></td>
              </tr>
<?php } ?>

请帮助我，如何从两个模型中检索数据并从一个视图显示它。提前感谢！

这在代码点火器文档中似乎微不足道。虽然我对编码点火器相对较新，但我的贡献可能很方便。事情是这样的：确保加载两个模型（例如在控制器类构造函数中）。然后，代码中有这两行导致问题

1. $data['query'] = $this->m_login->result_getAssessment($studentid); <<<found in getAssessment() method

和

2. $data['query'] = $this->m_login->result_totalAssessment($studentid); <<<found in  gettotalAssessment()  method

您必须为这些结果指定不同的数组键
因为您正在动态构建数组。参见：PHP 手册另请注意，如果在指定现有索引的同时向数组添加 alement，则该索引处的值将被新值覆盖。希望这能给您的解决方案搜索带来更多内容。

实际上您在

加载视图后调用$this->gettotalAssessment();函数getAssessment()您需要在控制器中执行此操作

function getAssessment() 
{
   $this->load->view('header');
   $this->load->view('navbar');
   $this->load->view('sidebar');
   $this->load->view('footer');
   $studentid = $this->session->userdata('studentid');
   $data['studentid'] = $studentid;
   $data['query'] = $this->m_login->result_getAssessment($studentid);
   $data['totalAssessment'] = $this->m_login->result_totalAssessment($studentid);
   $this->load->view('v_assessment',$data);
}

在您看来，您可以通过以下方式访问总评估

$totalAssessment