/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

0 vote113 views1 answer
Smtp php test
PHP
3 votes108 views1 answer
How to escape html tags in php
PHP
0 vote124 views1 answer
Mail php send
PHP
0 vote122 views6 answers
Array value auto fill in old value laravel 8
PHP Laravel
2 votes119 views4 answers
Get acf repeater field
PHP
3 votes131 views2 answers
Laravel Migrations from an existing database
PHP
0 vote106 views1 answer
$SERVER get cuurent directior PHP
PHP
0 vote137 views4 answers
Wordpress get current taxonomy
PHP Wordpress
0 vote115 views1 answer
Laravel auth without vue or bootstrap
PHP Laravel
9 votes166 views2 answers
Appending txt file from php
PHP