/PHP/Laravel where search like with space

Laravel where search like with space

$search_term = $request->input('search_term');
$words = explode(' ', $search_term);
$column = 'column_name';
$data = $data->where(function ($q) use ($column, $words) {
          foreach ($words as $key => $value) {
            $q->where($column, 'like', "%{$value}%");
          }
        })->get();

Similar codes

0 vote333 views1 answer
Script to create AdminLTE in a Laravel project
PHP Laravel
0 vote288 views1 answer
Data type for price in laravel
PHP Laravel
0 vote255 views2 answers
Send html from datatable in laravel
PHP
13 votes228 views6 answers
Route group in laravel
PHP Laravel
0 vote225 views1 answer
Cf7 first_as_label
PHP
47 votes241 views6 answers
How to add new column in laravel migration
PHP
6 votes241 views2 answers
Laravel check if request has value
PHP Laravel
0 vote219 views1 answer
Supress warning php
PHP
7 votes214 views3 answers
Echo new line
PHP
7 votes261 views5 answers
Jetstream laravel
PHP Laravel