I'm using CodeIgniter 3 to build a website. Now I have an issue with getting data from the database.
This is my Model:
public function Get($arr_condition = null)
{
if (!is_null($arr_condition))
{
$this->db->where($arr_condition);
}
$query = $this->db->get('cus');
if ($query->num_rows() > 0)
{
return $query->result_array();
}
return false;
}
In my Controller, I use an array ($arr_condition) to list all conditional expressions.
$arr_condition['Cus_team'] = 1;
$arr_condition['Cus_user != '] = 2;
$arr_condition['Cus_phone LIKE'] = 09900000;
$arr_condition['Cus_role >'] = 1;
$result = $this->M_cus_dal->get($arr_condition);
My code is working perfectly until I need a condition with where_in(), I tried:
$arr_condtion['Cus_id IN']= array('1,2,3');
But, It not work.
Please give me an ideal to resolve this issue.
You can do something like this:
In controller pass your where_in condition with another parameter like this
$where_in = array('1,2,3');
$result = $this->M_cus_dal->Get($arr_condition,$where_in);
In model method get $where_in
as second parameter as add it to where_in
clause like this :
public function Get($arr_condition = null,$where_in = NULL)
{
if(!is_null($arr_condition))
{
$this->db->where($arr_condition);
}
if(! empty($where_in))
{
$this->db->where_in('Cus_id',$where_in);
}
$query = $this->db->get('cus');
if($query->num_rows()>0)
{
return $query->result_array();
}
return false;
}