How i get column while compare json encoded data in select query?

Question

The users is json encoded

$agent_id = $request->get('user');

$model = AgentPermission::select('module_category')->where('users', 'like', '%$agent_id%')->get();

I want to to show "module category" where json encoded data is present in "users" column if it is working the whole code is working fine because when i use this

$model = AgentPermission::select('module_category')->where('users', 'like', '%"10"%')->get();  it is working perfect

Is there a reason you storing users in a field rather than in a separate table? — Rwd, May 25 '19 at 09:34

score 0 · Answer 1 · answered May 25 '19 at 17:19

0

The comparison should be inside double quotes, not single quotes

$model = AgentPermission::select('module_category')->where('users', 'like', "%$agent_id%")->get();

since PHP injects variables only when using double quotes.

The alternative is:

$model = AgentPermission::select('module_category')->where('users', 'like', '%' . $agent_id . '%')->get();

answered May 25 '19 at 17:19

JoeGalind

3,545
2
29
33

@NabeelAli if it answered your question, please mark it as resolved. – JoeGalind May 28 '19 at 16:22

How i get column while compare json encoded data in select query?

1 Answers1