select from table not in php array query not working

Question

I get an array to string conversion warning when I try to select using my $name_array variable in the NOT IN clause. I have tried loads of different quotation combinations, but I either get a syntax error or an array to string conversion warning. can anyone see what I'm doing wrong here. Thanks.

$db->query("SELECT contactname
            FROM contacts 
            WHERE contactname 
            NOT IN (' . implode(",", $name_array) . ')
          ");

You need quotes around the names: in ('john','peter','jack') — juergen d
– juergen d, Commented Oct 25, 2013 at 10:45
$db->query("SELECT contactname FROM contacts WHERE contactname NOT IN ('" . implode(",", $name_array) . "') "); implode should be out of the quotes — ManZzup
– ManZzup, Commented Oct 25, 2013 at 10:46
I put the quotation marks around the array variable but I still get the array to string warning — user2014429
– user2014429, Commented Oct 25, 2013 at 10:49
@user2014429: You need to add the quotes around every single name and not around all of them. — juergen d
– juergen d, Commented Oct 25, 2013 at 10:49

Barmar · Accepted Answer · 2013-10-25 10:51:30Z

5

You need to put quotes around each name before imploding them into a list.

$names = implode(",", array_map(function($x) { return "'$x'"; }, $name_array));
$db->query("SELECT contactname
            FROM contacts 
            WHERE contactname 
            NOT IN ($names)
          ");

answered Oct 25, 2013 at 10:51

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

2 Comments

user2014429 Over a year ago

I tried this and I really thought it would work because it seems to solve the problem of the quotation marks for the indexes. But for some reason I'm still getting the blasted array to string warning. But still +1 because it should have solved the problem.

user2014429 Over a year ago

UPDATE - there was something unrelated which was preventing it from working, now the code works great. Thank you very much.

smart developer · Accepted Answer · 2013-10-25 11:06:01Z

3

You have to quote name in '' due to string so please use.

$val="'";
$val.=implode("','",$name_array);
$val.="'";
$db->query("SELECT contactname FROM contacts WHERE contactname NOT IN ($val) ");

This will defiantly help you

answered Oct 25, 2013 at 11:06

smart developer

2243 silver badges14 bronze badges

Comments

valex · Accepted Answer · 2013-10-25 10:54:34Z

2

Try to use FIND_IN_SET()

$db->query("SELECT contactname
            FROM contacts 
            WHERE NOT FIND_IN_SET(contactname, \'' . implode(",", $name_array) . '\')   
          ");

answered Oct 25, 2013 at 10:54

valex

24.2k7 gold badges47 silver badges62 bronze badges

Comments

Adnan · Accepted Answer · 2013-10-25 10:57:11Z

1

$db->query("SELECT contactname
            FROM contacts 
            WHERE contactname 
            NOT IN ('".implode("','",$name_array).'\')');

answered Oct 25, 2013 at 10:57

Adnan

5791 gold badge4 silver badges11 bronze badges

Collectives™ on Stack Overflow

select from table not in php array query not working

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related