condition sql different in codeigniter code example
Example 1: how to use multiple where condition in codeigniter
$data = array('name' => 'Rockky');
$multiClause = array('id' => $ids, 'name' => $name, 'status' => 1 );
$this->db->where($multiClause);
$query = $this->db->get('table-name', $data);
return $query->result();
Example 2: Update Query in Codeigniter Using Multiple Where Condition
public function update_row(){
$update_rows = array('name' => 'rincky');
$multipleWhere = array('id' => $ids, 'name' => $name, 'status' => 1 );
$this->db->where($multipleWhere);
$this->db->update('user', $update_rows);
}