How can I search with multiple columns in Laravel

Question

I am very new in Laravel, I try to search with one column and this is my code. But now I want to search with multiple columns - how can I do that?

My controller :

public function search_pers(Request $request)
{
    $mle = $request->input('mle');
    $listpers = Personne::where('mle', 'LIKE', '%'.$mle.'%')->get();

    return view('frontend.etat_civil', ['personnes' => $listpers]);
}

Does this help?: [How to Create Multiple Where Clause Query Using Laravel Eloquent?](https://stackoverflow.com/questions/19325312/how-to-create-multiple-where-clause-query-using-laravel-eloquent) — Paul Spiegel, Jun 14 '20 at 15:28
How about this?: [How To Get Search Query From Multiple Columns in Database](https://stackoverflow.com/questions/48089966/how-to-get-search-query-from-multiple-columns-in-database) — Paul Spiegel, Jun 14 '20 at 16:01

ScaisEdge · Answer 1 · 2020-06-14T16:58:33.443

1

You could use an array

     Personne::where([
        ['col1', '=', 'value1'],
        ['col2', '<>', 'value2'],
        [Your_col, OPERATOR, value],
        ...
    ])

or in your case

      $str = "concat('%',".$mle .",'%')";
      $listpers = Personne::where([
            ['mle', 'LIKE', $str],
            ['col1', '=', 'value1'],
            ['col2', '<>', 'value2'],
            [Your_col, OPERATOR, value],
      )->get();

edited Jun 14 '20 at 16:58

answered Jun 14 '20 at 15:06

ScaisEdge

131,976
10
91
107

@SaraAlaoui answer updated .. hope is more clear – ScaisEdge Jun 14 '20 at 15:56
yes , ` $listpers = Personne::where([ ['mle', 'LIKE', '%'.$mle.'%'], ['nom', 'LIKE', '%'.$mle.'%'], ])->get(); ` but it gives nothing – Sara Alaoui Jun 14 '20 at 16:50
you have error?? ,.. show the code you are actually using ..anyway answer updated .with a new suggestion – ScaisEdge Jun 14 '20 at 16:58

score 0 · Accepted Answer · answered Jun 14 '20 at 17:10

As I understand what you need is an orWhere condition:

 public function search_pers(Request $request)
    {
      $mle = $request->input('mle');
      $listpers = Personne::where('mle', 'LIKE', '%'.$mle.'%')->orWhere('nom','like','%'.$mle.'%')->get();

      return view('frontend.etat_civil', ['personnes' => $listpers]);
    }

Another alternative and probably a better one is to use fulltext search. MySQL Fulltext search

How can I search with multiple columns in Laravel

2 Answers2