Laravel Controller Query is giving null output

Question

I have written below code

$setting = Setting::where('id', 1)->first();
return view('posts.setting', compact('setting'));

When I use this variable in my index,

<?php $setting = isset($_POST['setting']) ? $_POST['setting'] : 'NULL'; ?>

<?php print_r($setting); ?>

I am getting NULL. Why is my query not generating any output?

Can you confirm if you have a row in your setting table with ID as 1 ? — mighty_dev
– mighty_dev, Commented May 17, 2019 at 12:42
ok, to debug further, can you show your model file? Can you do a dd($setting) before view(.....) and check what you get. — mighty_dev
– mighty_dev, Commented May 17, 2019 at 14:08

Akash Kumar Verma · Accepted Answer · 2019-05-17 11:28:11Z

1

why are you using $_POST you don't need

@php 
    $setting = isset($setting) ? $setting : 'NULL'; 
    print_r($setting);
@endphp

answered May 17, 2019 at 11:28

Akash Kumar Verma

3,3582 gold badges19 silver badges33 bronze badges

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

2 Comments

Chintak Dholakia Over a year ago

Still, received NULL as a response.

Akash Kumar Verma Over a year ago

try to print_r($setting); die; in controller. maybe $setting is null. means data for id 1 not exist

Natvarsinh Parmar - bapu · Accepted Answer · 2019-05-18 16:03:24Z

0

If a record exists with id 1 then return a view with data otherwise dump and die in the controller just for your testing.

In controller:

     $setting = Setting::find(1);

     if($setting){
         return view('posts.setting', compact('setting'));
     } else {
         dd('No record found!');
     }

answered May 18, 2019 at 16:03

Natvarsinh Parmar - bapu

1,1381 gold badge8 silver badges8 bronze badges

Comments

Chintak Dholakia · Accepted Answer · 2019-05-19 03:40:01Z

0

For the benefit of all users, It had seeded database tables. I ran the following command

php artisan db:seed

and it started working. Not sure why it could not fetch manually created record but took it once I ran db seed

answered May 19, 2019 at 3:40

Chintak Dholakia

531 silver badge8 bronze badges

Collectives™ on Stack Overflow

Laravel Controller Query is giving null output

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related