php - 在codeigniter php中将表的计数设为零

Question

嗨，我有一个表 lab_master，我需要获取我编写的查询的表的总数，但将结果设为零作为输出。

控制器：

public function index() {
    $dateFrom = date('Y-m-d', strtotime('-6 days'));
    $dateTo = date('Y-m-d');        
    $dataArr = array('from_date' => $dateFrom,'to_date'=>$dateTo);
    $countAllLabs = $this->dashboard->countAllLabs();
    $data['count_all_labs'] = $countAllLabs;
    $this->load->view('dashboard', $data);
}

模型：

public function countAllLabs($week = 'week', $date = '') {
    $TotalRecord = 0;
    $this->db->select('count(id) as TotalRecord');
    $this->db->from('lab_master lab');
    // $this->db->where('cancel_status', '');
    if (!empty($week)) {
        $dateFrom = date('Y-m-d', strtotime('-6 days'));
        $dateTo = date('Y-m-d');
        $this->db->where("lab.created_date BETWEEN '" . $dateFrom . "' AND '" . $dateTo . "'");
    }
    if (!empty($date)) {
        $this->db->where("DATE_FORMAT('created_date,'%Y-%m-%d')", $date);
    }
    $query = $this->db->get();
    if ($query->num_rows() > 0) {
        $result = $query->row();
        $TotalRecord = $result->TotalRecord;
    }
    return $TotalRecord;
}

看法：

<div class="col-lg-3 userslist">            
                    <div class="user">
                        <i class="fa fa-user-o"></i>
                    </div>
                    <div class="userlist">
                        <ul class="lists">
                            <li class="list1">Labs: <?php echo $count_all_labs; ?></li>
                        </ul>
                    </div>
                </div>

标签： phpcodeigniter