如何在laravel中获取mysql表的最后一行值？

Question

i want to show the active deposit of my user.therefore i want to get last amount user has deposited in his account. but i have new in Laravel . i have tried following but its sums all amount of user not only last one. if you need i will share whole bunch of code here.

$data['a_deposit'] = Deposit::whereUser_id(Auth::user()->id)->orderBy('id','DESC',LIMIT 1)->take(1)->sum('amount');

from here i want to get last amount

$data['last_deposit'] = Deposit::whereUser_id(Auth::user()->id)->orderBy('id','DESC')->take(6)->get();

Answer 1

If you want to get only the last ammount, use value():

Deposit::where('user_id', auth()->id())->latest('id')->value('amount');

If you want to get last amount from already loaded collection:

$data['last_deposit'] = Deposit::whereUser_id(Auth::user()->id)->orderBy('id','DESC')->take(6)->get();

You can do this:

$amount = $data['last_deposit']->first()->amount;