php - 目前我得到了我的查询结果，但我想获得记录数

Question

我想得到我的查询的计数，当前它显示所有记录

Controller :

 public function fetchCounts(){
    $Result = $this->receivedModel->vehicleFreight($this->session->userdata('user_branch'));
    }

型号:

public function vehicleFreight($branch_id)  
        {  
             $this->db->select('*');
             $this->db->from('truck_freight');
             $this->db->where('truck_freight_status','truck_freight');
             $this->db->where('fr_memo_to',$branch_id);

            $query = $this->db->get();
            return $query->result();
        }  

如何在查询中使用 count()。在我的数据库中，我有 3 条记录。

Answer 1

试试这个型号

public function vehicleFreight($branch_id)  
        {  
             $this->db->select('count(*)');
             $this->db->from('truck_freight');
             $this->db->where('truck_freight_status','truck_freight');
             $this->db->where('fr_memo_to',$branch_id);

            $query = $this->db->get();
            return $query->result();
        }