Level 51
The are the same. whereSlug is a shorthand for where('slug', 'some-slug'). whereSlug is using where under the hood.
1 like
Jun 5, 2024
4
Level 4
Different where syntax?
I am aware you can perform a where via:
Post::where('slug', 'some-slug')->first();
But I have also seen:
Post::whereSlug('some-slug')->first();
There is no custom scope defined on the post model either.
Which one should be used, and why?
Level 4
@MohamedTammam ok so it make no difference.
Level 12
@panthro Laravel handles where with the column name using the magic method __call().
https://stackoverflow.com/questions/60224233/laravel-having-column-name-in-where-clause-static-method#:~:text=SQL%20it%20generates-,%24user%20%3D%20User%3A%3AwhereName('john')%2D%3E,a%20user%20with%20name%20john%20.
Level 122
Its magic developer convenience.
You can do this for any column in the table. It makes zero difference to runtime performance. At best it makes a more 'eloquent' looking code, at worst confuses people new to the project, looking in the docs trying to find a whereSlug method
1 like
Please or to participate in this conversation.