Get data from database and display to blade template in laravel

Question

I have a problem when I learning laravel. My views include master.blade.php and top.blade.php file. In master.blade.php, I used @include('top') command to get content show UI. But now I don't know how to get and passing database to top.blade.php. I was used direct App\Article; to do this. can anyone help me? thanks.

Master.blade.php file

@include('top')

Top.blade.php file

<?php 
use App\Article;
$articles = Article::orderBy(DB::raw('RAND()'))->take(1)->get();
 ?>
@foreach ($articles as $a)
{{ $a->title }}
@endforeach

More answers here : stackoverflow.com/a/54860667/3057779 You can also call controller function — romanzpolski
– romanzpolski, Commented Oct 8, 2020 at 14:51

Alexey Mezenin · Accepted Answer · 2016-05-19 07:25:10Z

2

You could do this:

<?php 
$articles = \App\Article::orderBy(DB::raw('RAND()'))->take(1)->get();
?>

But it's better to keep data logic in a model or a controller and pass it to the views.

answered May 19, 2016 at 7:25

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mr D Over a year ago

Thanks @Mezenin. if my top.blade.php appearing in all pages, then what do I do?

Alexey Mezenin Over a year ago

@Dung, this should work in all views which include top.blade.php

Loganathan Natarajan Over a year ago

Is there a better way to handle laravel?

Thibault Dumas · Accepted Answer · 2016-05-19 07:25:02Z

1

Juste use a Controller to pass database data in to your view, it should be

ArticlesController.php

$articles = Article::orderBy(DB::raw('RAND()'))->take(1)->get();
return view('master', compact('articles');

It's just an example, but now top.blade.php which is included in master, will contain $articles.

answered May 19, 2016 at 7:25

Thibault Dumas

1,0802 gold badges11 silver badges24 bronze badges

1 Comment

Mr D Over a year ago

Thanks @Dumas. follow you, I must to call view top.blade.php in all controller to show top.blade.php in all page.

Collectives™ on Stack Overflow

Get data from database and display to blade template in laravel

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related