Laravel DB::RAW() NOT IN not working

Question

Hello I have 5 records on cards table, and when I use not in on phpmyadmin it's working

SELECT id FROM cards WHERE id NOT IN (1,2)

but when I used not in on Laravel it's not working, and it only bind on 1st

$test = "1,2";

$cards = DB::SELECT(DB::RAW("SELECT id FROM cards WHERE id NOT IN (:exception)"), ['exception'=>$test]);

echo "<pre>";
var_dump($cards);
echo "</pre>";

I'm using this guide to avoid SQL Injection: http://fideloper.com/laravel-raw-queries

score 3 · Answer 1 · edited Apr 22 '20 at 12:51

3

DB::table('cards')->whereRaw('id NOT IN(".$test.")')->get();

Please try this code instead.

edited Apr 22 '20 at 12:51

Regolith

2,944
9
33
50

answered Dec 15 '15 at 16:57

Shawinder Jit Singh

91
1

I need to use DB::RAW() cause I have a long query, this is just a sample to make question easier to understand. – Storm Spirit Dec 15 '15 at 16:58
$cards = DB::SELECT(DB::RAW("SELECT id FROM cards WHERE id NOT IN (".$test.")")); this one ? – Shawinder Jit Singh Dec 15 '15 at 17:02
I need to use http://fideloper.com/laravel-raw-queries to avoid SQL Injection. – Storm Spirit Dec 15 '15 at 17:02
ok actually the problem is with commas , system is assuming single character $test = "1"; instead of $test = "1,2"; – Shawinder Jit Singh Dec 15 '15 at 17:13
i think no problem if you have long query then also you have to use DB::table with in between Raw() where it is needed i dnt think so this method fails – Shawinder Jit Singh Dec 15 '15 at 17:14
alternatively you can put comment in fidelopers 's above post to get solution :P :) – Shawinder Jit Singh Dec 15 '15 at 17:18

Laravel DB::RAW() NOT IN not working

1 Answers1