Eloquent Builder

It provides a convenient, fluent interface to creating and running database queries
 

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

UserPoint::selectRaw("TRUNCATE(SUM(amount),2) as summ, COUNT(id) as cnt") ->where('archive', 0) ->orderBy("dat",desc) ->groupBy("dat") ->take(13) ->get()

Category: Eloquent ORM 4 years ago

Using WhereIn

$whereTypes = ['png','jpeg','JPG','jpg']; $media = PostFile::where('post_id', $post->id)->whereIn('type', $whereTypes)->first();

Category: Eloquent ORM 4 years ago

Updating multiple rows

$values = Value::where('project_id', $id)->update(['data'=>$data]);

Category: Eloquent ORM 4 years ago

How to delete all the rows in a table

\App\Model::query()->delete();

Category: Eloquent ORM 4 years ago

How to use count with where condition

$active_requests = UserPiggyBank::where('process',1)->count();

Category: Eloquent ORM 4 years ago

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

PiggyBankCategory::orderBy( 'name', 'asc' )->get()->pluck('name', 'id');

Category: Eloquent ORM 4 years ago

Using Like

BookingDates::where('email', Input::get('email')) ->orWhere('name', 'like', '%' . Input::get('name') . '%')->get();

Category: Eloquent ORM 4 years ago

Checking what query is run with eloquent

If you want to see what is run in the database use dd(DB::getQueryLog()) to see what queries were run.

Category: Eloquent ORM 4 years ago

Using orWhere

$query->where( 'id', $request->query( 'keyword' ) )->orWhere('company_name', $keyword)->orWhere('job_number', $keyword);

Category: Eloquent ORM 4 years ago

How to use condition in query dynamically

$query = Order::query(); $keyword = $request->query( 'keyword' ) ?? ''; if ( !empty( $request->query( 'keyword' ) ) ) { $query->where(...

Category: Eloquent ORM 4 years ago