Get total number of records based on keyword and search_by item.

getTotalSearchNum

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.'%" ';
                
                break;
            case 'nric':
                $sql.='WHERE c.cust_card_id LIKE "%'.$keyword.'%" ';
                break;
            case 'card_number':
                $sql.='WHERE c.cust_id LIKE "%'.$keyword.'%" ';
                break;
            case 'car_number':
                $sql.='WHERE c.cust_car_no LIKE "%'.$keyword.'%" ';
                break;
        endswitch;
              
         $res=$this->db->query($sql);
         
         return $res->num_rows();
        
    }//end function