multiple where condition codeigniter
you can use an array and pass the array.
Associative array method:$array = array('name' => $name, 'title' => $title, 'status' => $status);$this->db->where($array); // Produces: WHERE name = 'Joe' AND title = 'boss' AND status = 'active'
Or if you want to do something other than = comparison
$array = array('name !=' => $name, 'id <' => $id, 'date >' => $date);$this->db->where($array);
Yes, multiple calls to where() is a perfectly valid way to achieve this.
$this->db->where('username',$username);$this->db->where('status',$status);
http://www.codeigniter.com/user_guide/database/query_builder.html
you can try this function for multi-purpose
function ManageData($table_name='',$condition=array(),$udata=array(),$is_insert=false){$resultArr = array();$ci = & get_instance();if($condition && count($condition)) $ci->db->where($condition);if($is_insert){ $ci->db->insert($table_name,$udata); return 0;}else{ $ci->db->update($table_name,$udata); return 1;}
}