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)

Abhay Maurya · Accepted Answer · 2019-02-26 12:04:01Z

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, 2019 at 12:04

Abhay Maurya

12.3k9 gold badges50 silver badges67 bronze badges

answered Feb 26, 2019 at 11:03

Jitendra

6143 gold badges11 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ahmed Guesmi Over a year ago

i always get all transaction

Jitendra Over a year ago

Are you sure that you're getting a not empty description?

Jitendra Over a year ago

I think for all the cases this condition is excuting and you are getting all transaction. ->orWhere('receiver_id', $user_id)

Kevin Müller · Accepted Answer · 2019-02-26 11:08:33Z

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 = "" ; }

dparoli · Accepted Answer · 2019-02-26 11:35:36Z

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();

FGDeveloper · Accepted Answer · 2019-02-26 11:12:26Z

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, 2019 at 11:12

answered Feb 26, 2019 at 11:03

FGDeveloper

1,0509 silver badges24 bronze badges

6 Comments

ThataL Over a year ago

Look at his manul query. where( multiple condition ) or where( single condition)

Ahmed Guesmi Over a year ago

i always get all transaction

FGDeveloper Over a year ago

I can't understand you? I said that where "method can use much times".

Ahmed Guesmi Over a year ago

Just i don't get the empty description rows but i get all my rows

FGDeveloper Over a year ago

If you want using two and one or criteria on your query. My solution will work.

|

Collectives™ on Stack Overflow

Laravel-5.6 'LIKE' in where select

4 Answers 4

3 Comments

1 Comment

Comments

6 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

1 Comment

Comments

6 Comments

Linked

Related