Codeigniter next_row（）返回null

Question

Im trying to get the next row everytim ei run the function but it always returns 0

Model

function getNextMuziek($id)
    {
        $this->db->where('id', $id);
        $this->db->limit(1);
        $query = $this->db->get('muziek')->num_rows() == 1;
        return $query->next_row();
    }

Answer 1

According to the documentation, next_row() is to be used to navigate through a result set. This will not serve your purposes. If you want your function to return the next row after the row specified by $id, the easiest thing would be to use a greater than comparison and return the first row. You could modify your code to

$query = $this->db->where('id >', $id)->limit(1)->get('muziek');
if ($query->num_rows() == 1) {
    return $query->row();
}