arifulhb

    public function getTotalNum(){
        
        $this->db->select('mrcnt_sn');
        $this->db->from('tblmerchant');
        $res=$this->db->get();
        
        return $res->num_rows;
        
    }//end function

arifulhb

public function getTotalSearchNum($keyword, $search_by){
        
        
        $sql='SELECT cust_sn ';
        $sql.='FROM (avcd_customer AS c) ';

        switch ($search_by):
            case 'name':
                $sql.='WHERE c.cust_first_name LIKE "%'.$keyword.'%" OR c.cust_last_name LIKE"%'.$keyword.'%" ';