/PHP/Add like and equal in same query in laravel

Add like and equal in same query in laravel

$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();

Source: stackoverflow.com

Similar codes

4 votes270 views2 answers
Laravel blade errors all
PHP
0 vote267 views1 answer
Magento 2 print php error
PHP
3 votes320 views6 answers
Laravel cors
PHP Laravel
0 vote284 views4 answers
Today date to ago for the date in php
PHP
2 votes291 views2 answers
Php milliseconds
PHP
6 votes292 views6 answers
Laravel collection pluck
PHP
-1 vote336 views2 answers
Fresh migrqte laravel
PHP Laravel
0 vote297 views1 answer
Get the last saved row in a table laravel
PHP Laravel
1 vote282 views1 answer
Formdata jquery ajax php
PHP
0 vote328 views1 answer
Syntax error, unexpected variable "$result" in D:\wordpress\xampp\htdocs\templete\user_delete.php on line 13
PHP Wordpress