How to get last seven record from db in laravel

user_14818166 0
Viewed 80
     
$posts=head::select('DATE','fno')->limit('7')->get();

I used this code but it returns first 7 record i want to return last seven inserted record

laravel
4 Answers

Try this query:

$posts=head::select('DATE','fno')->latest('DATE')->take(7)->get();
user_62468180

if Date column is inserted date time.you can do this

$posts = head::select('DATE','fno')->orderBy('DATE','desc')->limit(7)->get()

in your code,you don't get the last record becuase sql limit if start from above.so we order by something reverse.here we reverse DATE

user_19336760

Based on the documentation, oldest order your query by date. By default, the result will be ordered by the table's created_at column. If you want to change the column that it reference, put the column name inside the oldest syntax. Like so, ...->oldest("column_name")->...

$posts=head::select('DATE','fno')->oldest()->limit(7)->get();
user_115694370

Change the date format accordingly. It will work.

$posts = head::select(DB::raw("DATE_FORMAT(DATE,'%Y-%m-%d')", 'fno')->take(7)->get();
user_148517720
Related