How to return last record from database in codeigniter?

Question

I am trying to get the last date for which I have the data. So I want to print the last date in my column date_data.

In Model:

public function last_record()
{ 
    $query = $this->db->select('LAST(date_data)');
    $this->db->from('date_data');
    return $query;
}

In Controller:

$last_data = $this->attendance_m->last_record();
var_dump($last_data);

But I am not getting the desired result

Solution 1

Try this

$query = $this->db->query("SELECT * FROM date_data ORDER BY id DESC LIMIT 1");
$result = $query->result_array();
return $result;

Solution 2

For getting last record from table use ORDER BY DESC along with LIMIT 1

return $last_row=$this->db->select('*')->order_by('id',"desc")->limit(1)->get('date_data')->row();

Solution 3

You can do this as below code:

public function get_last_record(){
     $this->db->select('*');
     $this->db->from('date_data');
     $this->db->order_by('created_at', 'DESC'); // 'created_at' is the column name of the date on which the record has stored in the database.
     return $this->db->get()->row();
}

You can put the limit as well if you want to.

Solution 4

public function last_record()
{ 

    return $this->db->select('date_data')->from('table_name')->limit(1)->order_by('date_data','DESC')->get()->row();
}    

Solution 5

There is an easy way to do that, try:

public function last_record()
{ 
$query ="select * from date_data order by id DESC limit 1";
$res = $this->db->query($query);
return $res->result();
}

View more solutions

Comments

[Rajan]

Thanks a lot for your answer

[Rajan]

Thanks a lot for ur answer

[Rajan]

Thanks a lot for ur answer

[Dylan B]

yah, this answer is great! Thanks