我试图让我的页面显示成本总和,但我在尝试从我的控制器中调用变量时遇到了问题。以下是我的代码:
控制器:
public function cost()
{
$data['training'] = $this->form_model->getStatistics();
$data['cost'] = $this->form_model->getTotalCost();
$this->load->view('costStats_view', $data);
}
型号:
function getTotalCost()
{
$query = $this->db->query("SELECT SUM(cost) AS totalCost FROM tbl_training");
return $query->result();
}
视图:
<div class="form-group">
<label>Tota Cost</label>
<p class="form-control-static"><?=$cost['totalCost'];?></p>
</div>
result()
此方法以对象数组或失败时为空数组。通常你会在foreach循环中使用这个
视图
<?php
foreach ($cost as $row)
{
?>
<p class="form-control-static"><?=$row->totalCost;?></p>
<?php
}
?>