Search Results for "eloquent vs query builder"

Course Lesson • Better Eloquent Performance • 5:20 • Premium

13 - Eloquent vs Query Builder: whereHas vs join() vs Raw SQL

#whereHas #eloquent vs query builder

Tutorial • December 09, 2015 • 2 min read • Free

Select with DB::raw() - make your database work

When selecting data form the database, sometimes you need to make some extra filtering with results - with some if-else statements and similar. With Laravel - you can achieve that with Accessor fields or just looping through results in PHP. But there is a more effective way - to move the filters to the database query itself.

#eloquent vs query builder

Tutorial • February 21, 2019 • 2 min read • Free

Eloquent Trick: Group By Raw with Boolean Condition

I know the title sounds unclear, so let me start with an example. What would be your Eloquent query if you have birth_date field in DB an want to show how many of your users are adult 18+ years, and how many are still children? Let's take a look.

#eloquent vs query builder #eloquent conditions #eloquent tips

Tutorial • January 07, 2023 • 2 min read • Free

Eloquent create() VS Query Builder insert() Method

To add a record to the database, you may use one of two methods. What is the difference?

#eloquent #eloquent performance #eloquent vs query builder

Ask for Personal Help

We'll respond within 24 hours

Function available only for premium members.

Your Email *

What can we help you with? *

Be as specific as possible so we can provide the best guidance.

Cancel

Request Sent!

Thank you. I'll review your request and email you soon with resources or advice. If you need to discuss further, email me [email protected]

Close

Video • February 02, 2021 • 5:47 mins • Free

Eloquent or Query Builder: When to Use Which?

I've been asked this question quite a lot, so decided to discuss the pros and cons of each approach.

#eloquent #eloquent vs query builder

Video • February 07, 2022 • 2:24 mins • Free

Laravel DB Raw Queries: SQL Injection - How to Protect

A quick video showing how to protect from SQL injection in raw queries of Laravel Query Builder.

#security #eloquent vs query builder #SQL

Tutorial • February 05, 2023 • 2 min read • Free

Order by belongsTo Relationship Column: Eloquent vs Query Builder

If you have a query with the `belongsTo` relationship and want to order the records by the column from that related table, the orderBy wouldn't work.

#order by relationship #eloquent performance #eloquent vs query builder

Tutorial • September 27, 2022 • 1 min read • Free

New in Laravel 9.25: touch() on Query Builder

In one of the recent Laravel versions, they released an improvement to use the `touch()` method on Query Builder, and not only on Eloquent Model.

#eloquent vs query builder