php - Laravel filter a value in all columns

Question

public function getBooks($input)
{
    $books= Book::where('book_name', 'LIKE', '%' . $input . '%')->get();
    return Response::json($books);
}

I know how to filter a column by a given value. But how do I filter ALL columns by a given value. For example, I have a column called 'category' where user should be able to use the same search bar to filter the category.

Something like:

$books = Book::where('all_columns', 'LIKE', '%' . $input . '%')->get();

Thanks!

Answer 1

You have to add a where clause for each column like @JoelHinz suggests. To simplify things a bit you can use an array and a loop:

$query = Book::query();
$columns = ['book_name', 'foo', 'bar'];
foreach($columns as $column){
    $query->orWhere($column, 'LIKE', '%' . $input . '%');
}
$books = $query->get();

Or even use the schema builder to retrieve all column names from your table:

$columns = Schema::getColumnListing('books');