Search all the columns using laravel query builder

This is much of a sql related question. But I need to solve it in a laravel way. I have to implement a search functionality which makes search on every column of the table and join table. I have used postgres as database and query needs to be perfomed in json column type also.

My query looks like this

$cases = \DB::table('cases')
            ->join('services', 'cases.id', '=', 'services.case_id')
            ->where(function($query) use ($request)
            {
                $query->whereRaw('*', 'like', '%'.$request->get('query').'%');
            })
            ->get();

I need to perfom where query to all columns.

NoorDeen

11 years ago

Level 6

you can use searchable package it is easy and customizable and support joins .

2 likes

pmall

11 years ago

Level 56

$columns = [...];

$query = YourModel::select('*');

foreach($columns as $column)
{
  $query->where($column, '=', $search_value);
}

$models = $query->get();

6 likes

togo_hgl

4 years ago

Level 1

Works like a charm, although i would like to recommend

$query = YourModel::all();

also when pushing the results you'd probably want to use php array_push method and use an array for the responses:

$query = YourModel::all(); // Get all data of the class

$search_value = 'teststring'; // searchstring
$columns = array('test', 'test2'); // could also be used like $columns = ['test', 'test2'];

$resultsarray = array();

	foreach ($columns as $column) {
    	$results = $query->where($column, $search_value);
        if ($results != '[]') {
        	array_push($resultsarray, $results);
        }
	}

$result = $resultsarray;

I hope this may help some people in the future for reference :)

benoit.cornette

9 years ago

Level 5

@pmall, thanks! Used this one but instead of "where" I used "orWhere" and solved my problem.

1 like

Please or to participate in this conversation.