How to view the data of the last saved record in the database

Question

how do I display in the view only the data of the last saved record in the database? I can display all the data by calling the All() method in the control, and the good old foreach in the view to display the data. However, he wanted that when the user finishes the registration he was redirected to a page, where he could check the data that registered.

Obs:I’m using Laravel, eloquent Orm, mysql

in control I have this action to get all the data

public function exibe(){
  $dados = Denuncia::all();
  return view('AdminDenunciaView.exibeInformacao',['dados'=>$dados]);
}

in view use this foreach to display the data

@foreach ($dados as $item)
   {{$item->crime}}.<br/>
   {{$item->infrator}}.<br/>
@endforeach

But as I mentioned, I don’t need all the data to be shown, just the last record data

Answer 1

In the query you could give an order by, to list the last record.

Example: select * from clientes order by cliente_id desc

Thus would return the last registered record.

Answer 2

to sort by last record you can select order by desc Example

select * from tabelaExemplo order by tabelaExemplo_id  desc

To take only the last bank record you can do so:

select * from tabelaExemplo where tabelaExemplo.id = select max(id) from tabelaExemplo

Answer 3

You can order by the highest id (last added) and take the first record of the returned list, with the first() of eloquent.

example: DB::table('tabela')->orderBy('id', 'DESC')->first();

This way the first of the list will be the last id added, and this query will return you only 1 result.