Problems with query function laravel

Question

I would like to load the user, which has the appropriate url in the table invites stored. Unfortunately, I do not get the query written. How can I switch to the table "invites" and still load the right user to the page?

Relation:

One to one

Route

 Route::get('/invite/{url}', 'Auth\RegisterController@show')->name('invite.show');

Table invites:

Schema::create('invites', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('user_id')->unsigned()->nullable();
            $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
            $table->text('greeting')->nullable();
            $table->string('url')->unique();
            $table->timestamps();
        });

function

public function show($url)
{
    $user = User::where(function ($query) use ($url) {
        $query->where('invites.url', '=', $url);
    })->first();

    return view('invite_user', compact('user'));
}

Paras · Accepted Answer · 2018-10-06 16:58:03Z

1

Try this:

$user = User::whereHas('invites', function($query) use($url) {
    $query->where('url', $url);
})->first();

Make sure that you have the invites relationship function in your User model like so:

public function invites() {
    return $this->hasMany(Invite::class, 'user_id');
}

answered Oct 6, 2018 at 16:58

Paras

9,51336 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

Problems with query function laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related