Search code examples
laravelforeachdatatablesyajra-datatable

Loop retrieving only one result in Laravel with Yajra Datatable


This is my query:

$albix = DB::table('albi')
  ->select(['albi.id'])
  ->join('albi_user', 'albi.id', '=', 'albi_user.albi_id')
  ->where('user_id', '=', $user_id)
  ->get();

This is my foreach loop that should retrieve multiple items:

foreach ($albix as $a) {
    return $albi->id == $a->id ? 'alert-warning' : '';
}

Why is this not working?


Solution

  • Return stop your loop

    if($albi->id == $a->id){ return 'alert-warning';}

    $data = []
    foreach ($albix as $a) {
       $data[$a->id] = $albi->id == $a->id ? 'alert-warning' : '';
    }
    return $data;