Select Last Row in the Table

Question

I would like to retrieve the last file inserted into my table  I know that the method first   exists and provides you with the first file in the table but I don t know how to get the last insert

User · Answer

If you are looking for the actual row that you just inserted with Laravel 3 and 4 when you perform a save or create action on a new model like:

$user->save();

-or-

$user = User::create(array('email' => '[email protected]'));

then the inserted model instance will be returned and can be used for further action such as redirecting to the profile page of the user just created.

Looking for the last inserted record works on low volume system will work almost all of the time but if you ever have to inserts go in at the same time you can end up querying to find the wrong record. This can really become a problem in a transactional system where multiple tables need updated.

User · Answer

You ll need to order by the same field you re ordering by now  but descending  As an example  if you have a time stamp when the upload was done called upload time  you d do something like this   For Pre-Laravel 4  return DB  table  files  - gt order by  upload time    desc  - gt first      For Laravel 4 and onwards  return DB  table  files  - gt orderBy  upload time    desc  - gt first      For Laravel 5 7 and onwards  return DB  table  files  - gt latest  upload time  - gt first      This will order the rows in the files table by upload time  descending order  and take the first one  This will be the latest uploaded file

User · Answer

be aware that last    latest   are not deterministic if you are looking for a sequential or event ordered record  The last recent records can have the exact same created at timestamp  and which you get back is not deterministic  So do orderBy id foo - gt first    Other ideas suggestions on how to be deterministic are welcome

User · Answer

You never mentioned whether you are using Eloquent  Laravel s default ORM or not  In case you are  let s say you want to get the latest entry of a User table  by created at  you probably could do as follow   User  orderBy  created at    desc  - gt first      First it orders users by created at field  descendingly  and then it takes the first record of the result   That will return you an instance of the User object  not a collection  Of course  to make use of this alternative  you got to have an User model  extending Eloquent class  This may sound a bit confusing  but it s really easy to get started and ORM can be really helpful   For more information  check out the official documentation which is pretty rich and well detailed

User · Answer

For laravel 8  Model  orderBy  id    desc  - gt withTrashed  - gt take 1 - gt first  - gt id  The resulting sql query  Model  orderBy  id    desc  - gt withTrashed  - gt take 1 - gt toSql    select   from  quot timetables quot  order by  quot id quot  desc limit 1

User · Answer

If the table has date field  this User  orderBy  created at    desc  - gt first     is the best solution  I think  But there is no date field  Model   orderBy  id    desc  - gt first  - gt id  is the best solution  I am sure

User · Answer

You can use the latest scope provided by Laravel with the field you would like to filter  let s say it ll be ordered by ID  then   Model  latest  id  - gt first      So in this way  you can avoid ordering by created at field by default at Laravel

User · Answer

Another fancy way to do it in Laravel 6 x  Unsure but must work for 5 x aswell      DB  table  your table  - gt get  - gt last     You can access fields too    DB  table  your table  - gt get  - gt last  - gt id

User · Answer

Use the latest scope provided by Laravel out of the box   Model  latest  - gt first      That way you re not retrieving all the records  A nicer shortcut to orderBy

User · Answer

Laravel collections has method last   Model  all   - gt  last       last element  Model  all   - gt  last   - gt  pluck  name       extract value from name field     This is the best way to do it

User · Answer

Use Model  where  user id    user id - gt latest  - gt get  - gt first     it will return only one record  if not find  it will return null  Hope this will help

User · Answer

Don t use Model  latest  - gt first    because if your collection has multiple rows created at the same timestamp  this will happen when you use database transaction DB  beginTransaction    and DB  commit    then the first row of the collection will be returned and obviously this will not be the last row  Suppose row with id 11  12  13 are created using transaction then all of them will have the same timestamp so what you will get by Model  latest  - gt first    is the row with id  11

User · Answer

Somehow all the above doesn t seem to work for me in laravel 5 3  so i solved my own problem using   Model  where  user id         user id - gt orderBy  created at    desc  - gt get      hope am able to bail someone out

User · Answer

To get last record details   Model  all  - gt last    or Model  orderBy  id    desc  - gt first      To get last record id   Model  all  - gt last  - gt id  or  Model  orderBy  id    desc  - gt first  - gt id

User · Answer

To get the last record details  use the code below   Model  where  field    value  - gt get  - gt last

User · Answer

Try this    Model  latest  - gt get

User · Answer

Model  where - gt get  - gt last  - gt id

[laravel] Select Last Row in the Table

Examples related to laravel

Examples related to eloquent