Answers for "php ci get query"

codeigniter raw query

$sql="Select * from my_table where 1";    
    $query = $this->db->query($SQL);
    return $query->result_array();

codeigniter 3 update

$data = array(
        'title' => $title,
        'name' => $name,
        'date' => $date
);

$this->db->where('id', $id);
$this->db->update('mytable', $data);