Laravel显示WHERE子句的所有帖子和laravel中的分页

Question

so i want to display post in my index page but only the posts that are reviewed by the admin. so i added another column in my database table post which is called "review" which is integer. So this is what i have in hand.

in my controller i have this

public function index()
    {

        $this->layout->content = View::make('partials.index', 
            array(
            'posts' => Post::paginate(9)
            ));
    }

and in my index page i have this

@section('content')
    <div class="dashboard">
    @foreach (array_chunk($posts->getCollection()->all(),2) as $row)
        <div class="row">
            @foreach($row as $post)
                <article class="col-md-4 effect4" id="dash-box">
                    <p></p>

                    <c>{{$post->content}}</c><br>
                    <b>{{$post->title}}</b><br>
                    <d>posted..{{$post->created_at->diffForHumans()}}</d>
                    <hr>
                </article>
            @endforeach
        </div>
    @endforeach

    <div class="page">
    {{$posts->appends(Request::only('difficulty'))->links()}}
    </div>
    </div>
@stop

Help im newbie here i hope someone can help me out with this one hoping for a reply thanks

Answer 1

Just call:

Post::whereReview(1)->paginate(9);