Laravel-5 'LIKE' equivalent (Eloquent) Laravel-5 'LIKE' equivalent (Eloquent) php php

Laravel-5 'LIKE' equivalent (Eloquent)


php mysql laravel-5

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

Try this

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

php mysql laravel-5

I have scopes for this, hope it help somebody.https://laravel.com/docs/master/eloquent#local-scopes

public function scopeWhereLike($query, $column, $value){    return $query->where($column, 'like', '%'.$value.'%');}public function scopeOrWhereLike($query, $column, $value){    return $query->orWhere($column, 'like', '%'.$value.'%');}

Usage:

$result = BookingDates::whereLike('email', $email)->orWhereLike('name', $name)->get();

php mysql laravel-5 

$data = DB::table('borrowers')        ->join('loans', 'borrowers.id', '=', 'loans.borrower_id')        ->select('borrowers.*', 'loans.*')           ->where('loan_officers', 'like', '%' . $officerId . '%')        ->where('loans.maturity_date', '<', date("Y-m-d"))        ->get();

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last