Laravel 4 query inside view

Question

In my previous question, I got to perform a raw SQL query.

I've declared an public function in my controller:

public function deaths()
{
    $getdeaths = DB::statement('SELECT * FROM player_deaths ORDER BY time DESC LIMIT 10');
    return View::make('main.latestdeaths')->with('getdeaths', $getdeaths);
}

When retrieving data, I want to display players name, so inside the view in a foreach, is tried to run a SQL query.

        @foreach($getdeaths as $getdeath)
    <tr>
        <? $name = DB::select( DB::raw('SELECT name FROM players WHERE id = '$getdeath->player_id'') ) ?>
        <td>{{ $getdeath->player_id }}</td>
        <td></td>
        <td></td>
    </tr>
    @endforeach

When I try to echo $name, the variable is not defined.

Can I parse it some other way?

I've seen this recently in a stranger code. Why would anyone want to query from the view? This is ugly and breaking the MVC conventions. Please avoid doing such stuff or get used to develope structured . . . . I cant tell much about Laravel but considering other MVC-Frameworks you might be interested in Model-relations which is common and following the conventions. Be clever. Split logic. — Jonathan

Mostafa Elgaafary Mostafa Elgaafary · Accepted Answer · 2013-08-17T10:48:37

here you go :

$getDeaths = DB::table('player_deaths')->orderBy('time','desc')->take(10)->get();
return View::make('main.latestdeaths')->with('getDeaths', $getDeaths);

That will give you an object of all your player_deaths ordered by time.

Laravel 4 query inside view

3 Answers