Laravel Query Builder

While retrieving data from Laravel models

$users = User::where('name', 'John')->get();

$users = User::query()->where('name', 'John')->get();

Which one is recommended and why ?

Snapey

2 years ago

Level 122

They are the same i use query() where I want to spread over many lines

$users = User::where('name', 'John')->latest()->get();

// instead

$users = User::query()
		->where('name', 'John')
		->latest()
		->get();

laravel_ninja

2 years ago

Level 4

@Snapey Then what's the purpose of using this I've seen this many times when using scopes but I don't really understand why even we use this.

jlrdw

2 years ago

Level 75

@laravel_ninja EIther will work, some folks like eloquent for related data. But it still converts to normal sql and PDO at runtime.

Snapey

2 years ago

Level 122

@laravel_ninja sometimes you just need to start the query and then apply other conditions later in the function.

eg;

	$query = User::query();

	// some other logic, or checking something

	$query->where('stuff', $nonsense);

	// some other logic

	$query->where('foo', $bar);

	// later, ready to run the query

	$users = $query->get();

But don't worry about it, Just know that it can be done. When you need something like this, you can give it a try

Please or to participate in this conversation.