Relational SQL query array DB::table()-> select() ->where()->get(); [Laravel]

Question

I got an error with this code and the error is just from 'verification'< 25 The "less than" operator is the issue when I change that with => it does not come up with an error. How do I rewrite this query?

$allRecords = DB::table('users')->select(DB::raw('CONCAT(name, " ", last_name) AS name'),'email as email_address')->where(array('verification'< 25,'is_admin'=>0,'is_approved'=>1))->orderby('id', 'DESC')->get();

try this 'verification<' and let me know please?

KUMAR
– KUMAR

2020-06-26 02:15:53 +00:00
Commented Jun 26, 2020 at 2:15 — KUMAR
– KUMAR, Commented Jun 26, 2020 at 2:15
You mean 'verification<' => 25 or just 'verification<' 25?

Babatunde Oke
– Babatunde Oke

2020-06-26 02:17:49 +00:00
Commented Jun 26, 2020 at 2:17 — Babatunde Oke
– Babatunde Oke, Commented Jun 26, 2020 at 2:17
just 'verification<' 25

KUMAR
– KUMAR

2020-06-26 02:18:27 +00:00
Commented Jun 26, 2020 at 2:18 — KUMAR
– KUMAR, Commented Jun 26, 2020 at 2:18
Still getting errors

Babatunde Oke
– Babatunde Oke

2020-06-26 02:23:32 +00:00
Commented Jun 26, 2020 at 2:23 — Babatunde Oke
– Babatunde Oke, Commented Jun 26, 2020 at 2:23
The error is coming from PHP or MySQL?

FanoFN
– FanoFN

2020-06-26 02:29:26 +00:00
Commented Jun 26, 2020 at 2:29 — FanoFN
– FanoFN, Commented Jun 26, 2020 at 2:29

Senthurkumaran · Accepted Answer · 2020-06-26 02:48:58Z

1

Try like below

$allRecords = DB::table('users')
                 ->select(DB::raw('CONCAT(name, " ", last_name) AS name'),'email as email_address')
                 ->where('verification', '<', 25)
                 ->where(array('is_admin'=>0,'is_approved'=>1))
                 ->orderby('id', 'DESC')
                 ->get();

answered Jun 26, 2020 at 2:48

Senthurkumaran

1,8882 gold badges22 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

Relational SQL query array DB::table()-> select() ->where()->get(); [Laravel]

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related