Laravel not getting info out of database, displays erros

Question

Sorry, I'm new to developing on Laravel. I'm trying to show info contained in the database on my page. But it can't find the variable holding all the data. I can see the info in Tinker, but i can't seem to deplay is.

I posted some pictures so you can have a look. I'd love to hear your feedback.

Images: https://i.stack.imgur.com/ynfkP.jpg

Code:

Route:

<?php

Route::get('/', function () {
    return view('index');
});

Route::resource('complaints', 'ComplaintController');

Controller:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Complaint;

class ComplaintController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $complaints = Complaint::all();

        return view('index', compact('complaints'));
    }

Blade:

@extends('layout')

@section('title','Welcome')

@section('content')

{{-- @foreach ($complaints as $complaint)
    <h1>{{ $complaint->title }}</h1>
    <p>{{ $complaint->body }}</p>
@endforeach --}}

{{ $complaints }}


@endsection

It would be much easier to help if you posted your code as text rather than images. — Matt, Nov 12 '18 at 10:48
Add code here too, which contains route, controller and blade file. — Kamal Paliwal, Nov 12 '18 at 10:48
your code is ok , did you set your database config in .env ? — parastoo, Nov 12 '18 at 10:55
Thank you for your feedback, Posting 3 different code tags does not work on stackoverflow, so i made a Pastebin for you to take a look: pastebin.com/dWv6YxEq The database is correctly configured because the POST method already works for adding new items into DB. — STechmo, Nov 12 '18 at 11:22
your route is `/complaints` but you visited `/` in the pictures — Amir, Nov 12 '18 at 11:25

score 0 · Answer 1 · answered Nov 12 '18 at 12:14

Try it with another syntax like below:

public function index() {
    $complaints = Complaint::all();
    return view('index')->with(compact('complaints'));
}

or

 public function index() {
    $complaints = Complaint::all();
    return view('index')->with('complaints', $complaints);
}

score 0 · Answer 2 · answered Nov 12 '18 at 12:27

0

As @amirhosseindz said
When you're visiting this url : http://127.0.0.1:8000/complaints it will work because you're hitting

Route::resource('complaints', 'ComplaintController');

But when you visit this url : http://127.0.0.1:8000

you're hitting this action:

Route::get('/', function () {
    return view('index');
});

where $complaints doesn't exists

answered Nov 12 '18 at 12:27

Clément Baconnier

5,718
5
29
55

Thank you, the view did not include the complaints, thats why they did not show up. – STechmo Nov 12 '18 at 21:50

score 0 · Answer 3 · answered Nov 12 '18 at 12:33

You should try this:

Your Controller

public function index() {
    $complaints = Complaint::all();
    return view('index',compact('complaints'));
}

Your View (index.blade.php)

@extends('layout')

@section('title','Welcome')

@section('content')

  @if(isset($complaints))
   @foreach ($complaints as $complaint)
    <h1>{{ $complaint->title }}</h1>
    <p>{{ $complaint->body }}</p>
   @endforeach
  @endif


@endsection

score 0 · Accepted Answer · answered Nov 12 '18 at 13:16

0

You are not routing to the correct function in your controller. Try this

Route::resource('complaints', 'ComplaintController@index');

answered Nov 12 '18 at 13:16

Mike Miller

3,071
3
25
32

Laravel not getting info out of database, displays erros

4 Answers4