ORM (Object-relational mapping) is used to make database CRUD operations easier. Laravel comes with Eloquent ORM. This tutorial is created to provide some of the frequently used cheat sheet for Laravel Eloquent ORM

Ordering Eloquent hasMany() relationship

Add ->orderBy() to the hasMany relationship to get ordered output of a specified column.

return $this ->hasMany( 'Detail::class' )->orderBy( 'column' );

Eloquent’s where() method

Here are some useful cheat sheet for eloquent’s where() method.

$detail = Detail::where( "id" , "!=" , 50 )->get(); $detail = Detail::where( function ($query) { $query->where( 'a' , '=' , 1 ) ->orWhere( 'b' , '=' , 1 ); })->get(); $detail = Detail::whereRaw( 'age > ? and votes = 100' , array ( 25 ))->get(); $detail = Detail::whereRaw(DB::raw( "id in (select detail_id from students GROUP BY students.detail_id)" ))->get(); $detail = Detail::whereExists( function ($query) { $query->select(DB::raw( 1 )) ->from( 'students' ) ->whereRaw( 'students.detail_id = details.id' ) ->groupBy( 'students.detail_id' ) ->havingRaw( "COUNT(*) > 0" ); })->get(); $detail = Detail::whereIn( 'column' ,[ 1 , 2 , 3 ])->get(); $detail = Detail::whereNotIn( 'id' , function ($query) { $query->select( 'student_id' ) ->from( 'students' ) ->groupBy( 'students.student_id' ); })->get();

Here are some more useful cheat sheet for NULL or NOT NULL in laravel eloquent.

->whereNull( 'column' ) ->orWhereNull( 'column' ) ->whereNotNull( 'column' ) ->orWhereNotNull( 'column' )

Cheat sheet to filter by Day, Month, Year, Date options.

->whereDay() ->whereMonth( 'column' , '=' , 1 ) ->whereYear( 'column' , '>' , 2019 ) ->whereDate( 'column' , '>' , '2019-05-05' )

Prevent Eloquent from adding created_at or updated_at timestamps

Disable both created_at and updated_at in the model to disable the timestamps

const UPDATED_AT = null ; const CREATED_AT = null ;

Make sure to remove this from the migration

$table->timestamps()

restore() soft deleted Eloquent

Use the restore() method to undelete a record.

User::withTrashed()->where( "id" , 1 )->restore()

Make sure to add following lines in the model to enable SoftDeletes.

use SoftDeletes ;

Joins in Eloquent

Here are some useful cheat sheet for eloquent’s join() method.

$product = Product:where( 'id' , $productId) ->join( 'businesses' , 'product.business_id' , '=' , 'businesses.id' ) ->select( 'product.id' , 'businesses.name' )->first(); $product = Product:where( 'id' , $productId) ->leftJoin( 'businesses' , 'product.business_id' , '=' , 'businesses.id' ) ->select( 'product.id' , 'businesses.name' )->first(); $product = Product:where( 'id' , $productId) ->join( 'businesses' , function ($join) use ($cats) { $join->on( 'product.business_id' , '=' , 'businesses.id' ) ->on( 'product.id' , '=' , $cats, 'and' , true );})->first();

Find an item by Primary Key in Eloquent, or throw a ModelNotFoundException

findOrFail($id) method will find a model by it’s primary key or throw an exception if it’s not available.

$id = 10001 ; $user = User::findOrFail($id);

Cache in Eloquent

You can retrieve an item from the cache without loading it all the item.

$details = Cache::remember( 'details' , $seconds, function () { return DB::table( 'details' )->get(); });

rememberForever method is used to retrieve an item from the cache or store it forever

$details = Cache::rememberForever( 'details' , function () { return DB::table( 'details' )->get(); });

Hope this tutorial helped you! Feel free to drop your opinion at the comment section.