laravel 5.6 fetching data from database to view

Question

I'm facing an issue on understanding the content of the index function in the controller

I'm trying to get all the posts from my posts table into a view

my index function

public function index()
{
    $posts=\App\post::all();
    return view('MainViews.welcome',compact('posts'));
}

my view

   <div class="row">
    @foreach($posts as $post)
      <div class='col-md-8'>
        <div class="post"></div>
             h3>{{$post->subject}}</h3>
          <a href="#" class="btn btn-primary">read it</a>
          <p>
          </p>
        </div>
      @endforeach
     </div>

I'm getting Undefined variable error and highlighting @foreach

below is error highlighted

          <div class="row">
            18.    <?php $__currentLoopData = $posts; $__env->addLoop ($__currentLoopData); foreach($__currentLoopData as $posts):  $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
           19.          <div class='col-md-8'>
            20.            <div class="post"></div>
            21.              <h3><?php echo e($posts->subject); ?></h3>
            22.              <a href="#" class="btn btn-primary">read it</a>
             23.              <p>
             24.              </p>
              25.            </div>
               26.  <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
              27. 
               28.          </div>
                29.<?php $__env->stopSection(); ?>

Odyssee · Accepted Answer · 2018-06-22 14:34:06Z

1

You Can simply use like this.

public function index()
{
    $posts=DB::select("select * from `users` where `email`='__'");
    return view('MainViews.welcome',['posts'=>$posts]);
}

The view

   <div class="row">
    @foreach($posts as $post)
     <div class='col-md-8'>
       <div class="post"></div>
         < h3>{{$post->subject}}</h3>`<br>
         <a href="#" class="btn btn-primary">read it</a>`<br>
       </div>
     @endforeach
    </div>

edited Jun 22, 2018 at 14:34

Odyssee

2,4612 gold badges24 silver badges38 bronze badges

answered Jun 22, 2018 at 11:45

Ajay Kadoula

3062 silver badges13 bronze badges

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

4 Comments

Ajay Kadoula Over a year ago

also, check the name of the view same in index

IOS777 Over a year ago

Undefined variable: posts (View: C:\Users\amaar\Desktop\Blog\resources\views\MainViews\welcome.blade.php) @Ajay

Ajay Kadoula Over a year ago

make sure the name of view same in index function.

Ajay Kadoula Over a year ago

also sure that these file included with your index function <br> namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Http\Controllers\Controller; use DB;

Collectives™ on Stack Overflow

laravel 5.6 fetching data from database to view

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related