if with multiple conditions mysql 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);	
		
	}

Tags:

Php Example