Laravel not getting info out of database, displays erros

up vote
0
down vote

favorite

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://imgur.com/a/zLSqSDG

Code:

Route:

<?php



Route::get('/', function () {

    return view('index');

});



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

Controller:

<?php



namespace AppHttpControllers;



use IlluminateHttpRequest;

use AppComplaint;



class ComplaintController extends Controller

{

    /**

     * Display a listing of the resource.

     *

     * @return IlluminateHttpResponse

     */

    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

edited Nov 12 at 13:08

blue-phoenox

3,81681440

asked Nov 12 at 10:45

STechmo

3

It would be much easier to help if you posted your code as text rather than images.
– M̨̹̖̱̠̭̠̱̘͌̓ͬͫa̧͔͇̗͖͖͑ͭ͝t̆͗̊ͫt
Nov 12 at 10:48

Add code here too, which contains route, controller and blade file.
– Kamal Paliwal
Nov 12 at 10:48

your code is ok , did you set your database config in .env ?
– amini.swallow
Nov 12 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 at 11:22

1

your route is /complaints but you visited / in the pictures
– AmirhosseinDZ
Nov 12 at 11:25

|
show 1 more comment

up vote
0
down vote

favorite

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

Images: https://imgur.com/a/zLSqSDG

Code:

Route:

<?php



Route::get('/', function () {

    return view('index');

});



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

Controller:

<?php



namespace AppHttpControllers;



use IlluminateHttpRequest;

use AppComplaint;



class ComplaintController extends Controller

{

    /**

     * Display a listing of the resource.

     *

     * @return IlluminateHttpResponse

     */

    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

edited Nov 12 at 13:08

blue-phoenox

3,81681440

asked Nov 12 at 10:45

STechmo

3

It would be much easier to help if you posted your code as text rather than images.
– M̨̹̖̱̠̭̠̱̘͌̓ͬͫa̧͔͇̗͖͖͑ͭ͝t̆͗̊ͫt
Nov 12 at 10:48

Add code here too, which contains route, controller and blade file.
– Kamal Paliwal
Nov 12 at 10:48

your code is ok , did you set your database config in .env ?
– amini.swallow
Nov 12 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 at 11:22

1

your route is /complaints but you visited / in the pictures
– AmirhosseinDZ
Nov 12 at 11:25

|
show 1 more comment

up vote
0
down vote

favorite

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

Images: https://imgur.com/a/zLSqSDG

Code:

Route:

<?php



Route::get('/', function () {

    return view('index');

});



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

Controller:

<?php



namespace AppHttpControllers;



use IlluminateHttpRequest;

use AppComplaint;



class ComplaintController extends Controller

{

    /**

     * Display a listing of the resource.

     *

     * @return IlluminateHttpResponse

     */

    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

edited Nov 12 at 13:08

blue-phoenox

3,81681440

asked Nov 12 at 10:45

STechmo

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

Images: https://imgur.com/a/zLSqSDG

Code:

Route:

<?php



Route::get('/', function () {

    return view('index');

});



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

Controller:

<?php



namespace AppHttpControllers;



use IlluminateHttpRequest;

use AppComplaint;



class ComplaintController extends Controller

{

    /**

     * Display a listing of the resource.

     *

     * @return IlluminateHttpResponse

     */

    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

php laravel tinker

edited Nov 12 at 13:08

blue-phoenox

3,81681440

asked Nov 12 at 10:45

STechmo

edited Nov 12 at 13:08

blue-phoenox

3,81681440

asked Nov 12 at 10:45

STechmo

edited Nov 12 at 13:08

blue-phoenox

3,81681440

edited Nov 12 at 13:08

blue-phoenox

3,81681440

edited Nov 12 at 13:08

blue-phoenox

3,81681440

asked Nov 12 at 10:45

STechmo

asked Nov 12 at 10:45

STechmo

asked Nov 12 at 10:45

STechmo

3

It would be much easier to help if you posted your code as text rather than images.
– M̨̹̖̱̠̭̠̱̘͌̓ͬͫa̧͔͇̗͖͖͑ͭ͝t̆͗̊ͫt
Nov 12 at 10:48

Add code here too, which contains route, controller and blade file.
– Kamal Paliwal
Nov 12 at 10:48

your code is ok , did you set your database config in .env ?
– amini.swallow
Nov 12 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 at 11:22

1

your route is /complaints but you visited / in the pictures
– AmirhosseinDZ
Nov 12 at 11:25

|
show 1 more comment

3

It would be much easier to help if you posted your code as text rather than images.
– M̨̹̖̱̠̭̠̱̘͌̓ͬͫa̧͔͇̗͖͖͑ͭ͝t̆͗̊ͫt
Nov 12 at 10:48

Add code here too, which contains route, controller and blade file.
– Kamal Paliwal
Nov 12 at 10:48

your code is ok , did you set your database config in .env ?
– amini.swallow
Nov 12 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 at 11:22

1

your route is /complaints but you visited / in the pictures
– AmirhosseinDZ
Nov 12 at 11:25

It would be much easier to help if you posted your code as text rather than images.
– M̨̹̖̱̠̭̠̱̘͌̓ͬͫa̧͔͇̗͖͖͑ͭ͝t̆͗̊ͫt
Nov 12 at 10:48

Add code here too, which contains route, controller and blade file.
– Kamal Paliwal
Nov 12 at 10:48

your code is ok , did you set your database config in .env ?
– amini.swallow
Nov 12 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 at 11:22

your route is /complaints but you visited / in the pictures
– AmirhosseinDZ
Nov 12 at 11:25

|
show 1 more comment

4 Answers
4

active

oldest

votes

up vote
0
down vote

accepted

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

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

answered Nov 12 at 13:16

Mike Miller

2,06611220

This solved my Issue, thank you very much!
– STechmo
Nov 12 at 21:48

add a comment |

up vote
0
down vote

Try it with another syntax like below:

public function index() {

    $complaints = Complaint::all();

    return view('index')->with(compact('complaints'));

}

 public function index() {

    $complaints = Complaint::all();

    return view('index')->with('complaints', $complaints);

}

answered Nov 12 at 12:14

thenextbillionaire

add a comment |

up vote
0
down vote

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 at 12:27

cbaconnier

9751621

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

add a comment |

up vote
0
down vote

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

answered Nov 12 at 12:33

Saurabh Dhariwal

1,01812

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53260498%2flaravel-not-getting-info-out-of-database-displays-erros%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

4 Answers
4

active

oldest

votes

4 Answers
4

active

oldest

votes

up vote
0
down vote

accepted

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

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

answered Nov 12 at 13:16

Mike Miller

2,06611220

This solved my Issue, thank you very much!
– STechmo
Nov 12 at 21:48

add a comment |

up vote
0
down vote

accepted

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

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

answered Nov 12 at 13:16

Mike Miller

2,06611220

This solved my Issue, thank you very much!
– STechmo
Nov 12 at 21:48

add a comment |

up vote
0
down vote

accepted

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

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

answered Nov 12 at 13:16

Mike Miller

2,06611220

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

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

answered Nov 12 at 13:16

Mike Miller

2,06611220

answered Nov 12 at 13:16

Mike Miller

2,06611220

answered Nov 12 at 13:16

Mike Miller

2,06611220

answered Nov 12 at 13:16

Mike Miller

2,06611220

This solved my Issue, thank you very much!
– STechmo
Nov 12 at 21:48

add a comment |

This solved my Issue, thank you very much!
– STechmo
Nov 12 at 21:48

This solved my Issue, thank you very much!
– STechmo
Nov 12 at 21:48

add a comment |

up vote
0
down vote

Try it with another syntax like below:

public function index() {

    $complaints = Complaint::all();

    return view('index')->with(compact('complaints'));

}

 public function index() {

    $complaints = Complaint::all();

    return view('index')->with('complaints', $complaints);

}

answered Nov 12 at 12:14

thenextbillionaire

add a comment |

up vote
0
down vote

Try it with another syntax like below:

public function index() {

    $complaints = Complaint::all();

    return view('index')->with(compact('complaints'));

}

 public function index() {

    $complaints = Complaint::all();

    return view('index')->with('complaints', $complaints);

}

answered Nov 12 at 12:14

thenextbillionaire

add a comment |

up vote
0
down vote

Try it with another syntax like below:

public function index() {

    $complaints = Complaint::all();

    return view('index')->with(compact('complaints'));

}

 public function index() {

    $complaints = Complaint::all();

    return view('index')->with('complaints', $complaints);

}

answered Nov 12 at 12:14

thenextbillionaire

Try it with another syntax like below:

public function index() {

    $complaints = Complaint::all();

    return view('index')->with(compact('complaints'));

}

 public function index() {

    $complaints = Complaint::all();

    return view('index')->with('complaints', $complaints);

}

answered Nov 12 at 12:14

thenextbillionaire

answered Nov 12 at 12:14

thenextbillionaire

answered Nov 12 at 12:14

thenextbillionaire

answered Nov 12 at 12:14

thenextbillionaire

add a comment |

up vote
0
down vote

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 at 12:27

cbaconnier

9751621

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

add a comment |

up vote
0
down vote

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 at 12:27

cbaconnier

9751621

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

add a comment |

up vote
0
down vote

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 at 12:27

cbaconnier

9751621

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 at 12:27

cbaconnier

9751621

answered Nov 12 at 12:27

cbaconnier

9751621

answered Nov 12 at 12:27

cbaconnier

9751621

answered Nov 12 at 12:27

cbaconnier

9751621

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

add a comment |

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

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

add a comment |

up vote
0
down vote

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

answered Nov 12 at 12:33

Saurabh Dhariwal

1,01812

add a comment |

up vote
0
down vote

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

answered Nov 12 at 12:33

Saurabh Dhariwal

1,01812

add a comment |

up vote
0
down vote

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

answered Nov 12 at 12:33

Saurabh Dhariwal

1,01812

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

answered Nov 12 at 12:33

Saurabh Dhariwal

1,01812

answered Nov 12 at 12:33

Saurabh Dhariwal

1,01812

answered Nov 12 at 12:33

Saurabh Dhariwal

1,01812

answered Nov 12 at 12:33

Saurabh Dhariwal

1,01812

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Vfrdtyky