/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

5 votes165 views3 answers
Laravel model limit
PHP Laravel
0 vote132 views1 answer
Php tutorials account ledger
PHP
0 vote171 views1 answer
File form validation codeigniter
PHP CodeIgniter
24 votes112 views2 answers
Php ifelse
PHP
6 votes150 views5 answers
Migration rename column laravel
PHP Laravel
0 vote126 views1 answer
Haseeb php code
PHP
7 votes135 views1 answer
Encode zlib php
PHP
1 vote149 views1 answer
Change verify email template laravel
PHP Laravel
0 vote131 views1 answer
Php get refferal
PHP
15 votes133 views1 answer
Laravel composer install ignore
PHP