phpmysqlcodeigniterselectquery-builder

Why does CodeIgniter's query builder ignore builder methods called after get() when rendering the query?


I have this query and I want to put it on my code igniter php.

SELECT MAX(IDnumber) FROM student WHERE IDnumber LIKE '2013256%'

I tried this one but it returns an error:

$this->db->select_max('IDnumber');
$this->db->get('student');
$IDnumber = $this->db->like('IDnumber', '2013256', 'after'); 
return $IDnumber;

Solution

  • You are getting result after $this->db->get(), so use

    $this->db->select_max('IDnumber');
    $this->db->like('IDnumber', '2013256', 'after'); 
    $this->db->from('student');
    return $this->db->get();
    

    Also You can use chaining method:

    return $this->db->select_max('IDnumber')->like('IDnumber', '2013256', 'after')->get('student');