What is Query Builder? -

Category: Definitions Topic: Eloquent Builder Created: 3 years ago

Laravel's database query builder provides a convenient, fluent interface to creating and running database queries. It can be used to perform most database operations in your application and works perfectly with all of Laravel's supported database systems.

Last Edited: 3 years ago

What is Query Builder?

Related Posts

Using selectRaw with aggregate function, where, orderBy, groupBy, take and get

Using WhereIn

Updating multiple rows

How to delete all the rows in a table

How to use count with where condition

How to get names in list instead of associated array ( id as key and name as value )

Using Like

Checking what query is run with eloquent

Using orWhere

How to use condition in query dynamically

Using dynamic condition under auth check and request query

Using "with" in eloquent query

Getting last inserted id

Selecting last row of a table

How to write multiple AND queries inside OR query using closure

Returning rows where a column is between two values

Selecting rows if they are NULL or NOT NULL

How to use whereHas to retrieve rows based on existence of relationship

Using withAggregates in Eloquent way

Selecting fields inside eager loading method "with"

Quick way to save or update post with one liner of eloquent code

Using model observer - a separate class to observe model changes and run desired logic

Changing model values using mutators before saving in database

Using parameters in find() method

Using findorFail() and firstOrFail() method

Using whereDate, whereYear, whereMonth, whereDay and whereCreatedAt for dates

Using brackets to specify two or more where clauses into its own where function in eloquent

Using local scope in eloquent

Using global scope in eloquent

How to use eloquent when - more elegant way of using if statement