How to loop through model and get each id in a varaible [duplicate]

Question

Hello I am new to laravel, I want to loop through a data table and get each id of it in a variable. So i did it like this, but unfortunatly nothing works

$station_id = 0;
$stations = Station::all();

foreach ($stations as $station) {
    $station_id =  $station->id;
}
return $station_id;

this only showing the last id;

Answer 1

What you can do is loop all of the result set and add the ids to an array. First, you need an empty array:

$stations = Station::all();
$station_ids = [];

foreach ($stations as $station) {
    $station_ids[] =  $station->id;
}
return $station_ids;

Once you have all station_ids, you can then loop in your view like this

Controller

$stations = Station::all();
    $station_ids = [];

    foreach ($stations as $station) {
        $station_ids['ids'] =  $station->id;
    }
    return view('view.blade.php',$station_ids);

view

@foreach($ids as $id)
      {{ $id->fieldname}}
  @endforeach

You can not assign a single variable in a loop to a single id.

Answer 2

The way you are trying it your $station_id will be set to the very last ID.. If you want to have an array of ids from the stations just use this:

$stations = Station::pluck('id')->toArray();