/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

1 vote184 views1 answer
How to add attributes to an exsisting object in php
PHP
1 vote173 views5 answers
File upload in php through ajax
PHP
0 vote199 views1 answer
How to get post by comment in laravel
PHP Laravel
3 votes180 views3 answers
Laravel clear table
PHP
1 vote194 views1 answer
Php remove 1 day from date
PHP
0 vote296 views1 answer
Laravel check if primary key exists
PHP
1 vote212 views2 answers
Php iterate folder
PHP
0 vote179 views1 answer
Install wget downloader php
PHP
14 votes176 views2 answers
Php 3 digit decimal
PHP
19 votes214 views4 answers
Php json_decode not working
PHP