Laravel-5.6 'LIKE' in where select

Question

I use this query and i get a error :

 $description = $request->get('description');
        if (!empty($description)){
        $description_query = Transcationhistorique::where(['sender_id' => $user_id, "%$description%", 'LIKE','description'])
            ->orWhere('receiver_id', $user_id)->get();
        }else{
            $description_query  =  "" ;
        }

and this is the error that I get :

"SQLSTATE[42S22]: Column not found: 1054 Unknown column '0' in 'where clause' (SQL: select * from transcation_historique where (sender_id = 32 and 0 = %salaire% and 1 = LIKE and 2 = description) or receiver_id = 32)"

and this what really i want to run:

select * from `transcation_historique` where (`sender_id` = 32 and `description` = %salaire%) or `receiver_id` = 32)

score 3 · Answer 1 · edited Feb 26 '19 at 12:04

3

Try this,

$description_query = Transcationhistorique::where(
                         function($query) use ($user_id, $description){
                             return $query->where('sender_id', $user_id)
                                          ->where('description', 'like', '%' . $description .'%');

                         }
                     )
                     ->orWhere('receiver_id', $user_id)
                     ->get();

edited Feb 26 '19 at 12:04

Abhay Maurya

11,819
8
46
64

answered Feb 26 '19 at 11:03

Jitendra

584
1
10
28

i always get all transaction – Ahmed Guesmi Feb 26 '19 at 11:14
Are you sure that you're getting a not empty description? – Jitendra Feb 26 '19 at 11:19
I think for all the cases this condition is excuting and you are getting all transaction. `->orWhere('receiver_id', $user_id)` – Jitendra Feb 26 '19 at 11:25

score 1 · Answer 2 · answered Feb 26 '19 at 11:08

It seems like your where query is not structured correctly. You should use the following structure if you want to use operators other than "=" Source

$query->where([
    ['column_1', '=', 'value_1'],
    ['column_2', '<>', 'value_2'],
    [COLUMN, OPERATOR, VALUE],
    ...
])

My suggestion is:

 $description = $request->get('description');
 if (!empty($description)){
     $description_query = Transcationhistorique::where([
            ['sender_id', '=', $user_id],
            ['description', 'LIKE', "%{$description}%"]
     ])
     ->orWhere('receiver_id', $user_id)->get();
 }else{
     $description_query  =  "" ;
 }

i always get all transaction – Ahmed Guesmi Feb 26 '19 at 11:14 — Ahmed Guesmi, Feb 26 '19 at 11:14

dparoli · Answer 3 · 2019-02-26T11:35:36.567

1

Try this one:

Transcationhistorique::where('receiver_id', '=', $user_id)
        ->orWhere(function ($query) use ($user_id, $description) {
            $query->where('sender_id', '=', $user_id)->where('description', 'LIKE', "%".$description."%");
        })->get();

edited Feb 26 '19 at 11:35

answered Feb 26 '19 at 11:28

dparoli

8,891
1
30
38

FGDeveloper · Answer 4 · 2019-02-26T11:12:26.247

0

You can use multiple where method as and. Can you try following codes?

    $description = $request->get('description');
    if (!empty($description)){
        $description_query = Transcationhistorique::where('sender_id', $user_id)
        ->where("description", 'LIKE','%' . $description . '%')
        ->orWhere('receiver_id', $user_id)->get();
    }else{
        $description_query  =  "" ;
    }

edited Feb 26 '19 at 11:12

answered Feb 26 '19 at 11:03

FGDeveloper

1,030
9
23

Look at his manul query. where( multiple condition ) or where( single condition) – ThataL Feb 26 '19 at 11:09
i always get all transaction – Ahmed Guesmi Feb 26 '19 at 11:13
I can't understand you? I said that ``where`` "method can use much times". – FGDeveloper Feb 26 '19 at 11:14
Just i don't get the empty description rows but i get all my rows – Ahmed Guesmi Feb 26 '19 at 11:19
If you want using two ``and`` one ``or`` criteria on your query. My solution will work. – FGDeveloper Feb 26 '19 at 11:19
You may should need use for like ``orWhere`` instead of ``where``. Sorry i can't understand your problem. If you tell me your all needs, i can helpful. – FGDeveloper Feb 26 '19 at 11:25

Laravel-5.6 'LIKE' in where select

4 Answers4

Linked