Property does not exist on this collection instance. | Laravel | Page 1

scenic sphinx Dec 23, 2022, 5:12 PM

#

#rules

static kite Dec 23, 2022, 5:14 PM

#

scenic sphinx <#998593183363633324>

Should i make it as snippets or what? 😅

scenic sphinx Dec 23, 2022, 5:20 PM

#

static kite Should i make it as snippets or what? 😅

You should post code blocks like the rules say and demonstrate.

static kite Dec 23, 2022, 5:23 PM

#

I'm trying to view some data.

Controller

public function show_2(){
        $company=DB::table('companies')->where('id' , '=' , '2');
        return view('application.apply', [
            'provider_id'=>2,
            'company'=>$company->get()
        ] );
    }

Blade

<x-company-info :company="$company" />

The component

@props(['company'])
<h2> {{ $company->name }} </h2>
<p> {{ $company->details }} </p>

Attached screeshoots for the dd() result, and the error

#

dreamy valley Dec 23, 2022, 5:27 PM

#

You are loading a collection of items, no wonder it throws errors

#

If you want a single result, either get the first() at the end OR even better - use the find() method for the query builder

static kite Dec 23, 2022, 5:32 PM

#

I did the exact same thing here

@props(['latest'])
<x-card>
    <div class="flex flex-col">
        <h5> {{ $latest->title }} </h5>
        <p> {{ $latest->details }} </p>
    </div>
</x-card>

And it's working!

dreamy valley Dec 23, 2022, 5:32 PM

#

Ye sure

static kite Dec 23, 2022, 5:33 PM

#

But why, i don't get it

scenic sphinx Dec 23, 2022, 5:33 PM

#

static kite But why, i don't get it

Because you need a pass a single model instance, and not a collection.

#

This line is the problem:

$company=DB::table('companies')->where('id' , '=' , '2');

#

If you want to get a single company with that ID, then use Eloquent models and build a proper query:

$company = Company::findOrFail(2);

#

But I don’t know why you’d be looking up models with hard-coded IDs like that in the first place.

static kite Dec 23, 2022, 5:34 PM

#

Controller for the apove code

public function list(Request $request){
        $application =DB::table('applications')->where('provider_id' , 'like' , Auth::Guard('providerg')->id() );
        dd($application->get());
        return view('providers.applications' ,[
            'applications'=>$application->get()

        ]);
    }

dreamy valley Dec 23, 2022, 5:35 PM

#

scenic sphinx If you want to get a single company with that ID, then use Eloquent models and b...

It's "show_2* so it makes sense pepeJAM