具有活动记录的CodeIgniter COUNT - CodeIgniter COUNT with active record?

CodeIgniter COUNT with active record?

本文关键字：CodeIgniter COUNT 记录活动 | 更新日期: 2023-09-27

我在codeigniter工作。。我想计算具有相同顺序的行数_no。。下面是我的代码。

public function get_my_orders() {
        $user_data = $this->session->all_userdata();
        $email = $user_data['user_email'];
            $this->db->select('*');
            $this->db->from('order_details');
            $this->db->where('email', $email);
            $this->db->group_by('order_no');
            $this->db->order_by('order_no', 'DESC');
            $query = $this->db->get();
            return $query->result();
    }

请帮忙。。

您可以使用$this->db->count_all_results（）

 public function get_my_orders() {
    $user_data = $this->session->all_userdata();
    $email = $user_data['user_email'];
        //$this->db->select('*');// no need select as you only want counts
        $this->db->from('order_details');
        $this->db->where('email', $email);
        //$this->db->group_by('order_no');//no need group_by as you only want counts
        //$this->db->order_by('order_no', 'DESC');//no need order_by as you only want counts            
        return $this->db->count_all_results();;
}

尝试将选择行更改为如下所示：

            $this->db->select('COUNT(*) as count');

您将只能访问一个名为count的变量，而不是像当前那样访问所有字段。要保持所有变量都可访问并添加计数，请使用以下内容：

            $this->db->select('*, COUNT(*) as count');

请随意更改count的小写名称，我只是以它为例。

检查代码点火器手动

$query = $this->db->get();
return  $query->num_rows();  //Return total no. of rows here

$query->num_rows();将计算您的查询返回的活动记录总数。