Laravel find() query doesn't bind any data

Question

Using laravel 4.0

This is my call to find:

User::find(2)->first()

And this is the result from getQueryLog():

[query] => select * from `users` limit 1
[bindings] => Array
    (
    )

I expected that it would use a where = ?.

I'm almost certain this worked well until it didn't.

Thanks for the help.

User::find(2) will return user with primary key 2. check here, why are you useing first() — chanchal
– chanchal, Commented Nov 4, 2014 at 12:44
I think ->first() is somehow, working against you. Have you tried without? — klauskpm
– klauskpm, Commented Nov 4, 2014 at 12:45

Marcin Nabiałek · Accepted Answer · 2014-11-04 12:46:12Z

1

It's enough to use:

$user = User::find(2);

It will get you User with primary key 2.

You don't need to and cannot use find with first - there's only one User with given primary key so Eloquent automatically get user and you don't need to use first in this case. You could use first if you would like to get user this way:

$user = User::where('id','2')->first();

The above code is equivalent to:

$user = User::find(2);

(assuming id is primary key)

answered Nov 4, 2014 at 12:46

Marcin Nabiałek

112k43 gold badges272 silver badges300 bronze badges

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

Collectives™ on Stack Overflow

Laravel find() query doesn't bind any data

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