如何在laravel中将连接查询显示到视图中

Question

i am using laravel 5.5 and am trying to show into a view the current data :

$data = DB::table('demandes')
  ->join('articles', 'articles.id', '=', 'demandes.article_id')
  ->join('users', 'users.id', '=', 'demandes.client_id')  
  ->select('demandes.*', 'articles.nom_article', 'users.prenom')
  ->get();          

i am trying to find how to make a foreach statement even thought its not the same table i am working with ,

here is the demande table :

table demandes in phpmyadmin

Answer 1

Few changes in query

$data = DB::table('demandes as D')
      ->select('D.*', 'A.nom_article', 'U.prenom')
      ->join('articles as A', 'A.id', '=', 'D.article_id')
      ->join('users as U', 'U.id', '=', 'D.client_id')  
      ->get(); 

Foreach loop on view:

@foreach($data as $value)
   {{ $value->nom_article }}
   {{ $value->prenom }}
@endforeach

See if the same you are looking for.