Search table for each array value

Question

Please I want to know if its possible to search a database table with an array for example:

$array = array('a', 'b', 'c', 'd', 'e');
$query = mysqli_query($con, "SELECT * FROM table WHERE //the possible search for each of the array value// (!in_array(table_colomn, $array)");

Is there a possible way to do this or do I have to run a for each function like so:

foreach($array as $arr){
    //run table query search for each array value
}

yes... so should I run the query like this: WHERE table_colomn IN '".$array."'? — KANAYO AUGUSTIN UG
– KANAYO AUGUSTIN UG, Commented May 23, 2016 at 14:08
Close, but not quite. You need to convert the array into a string and build a proper MySQL query. — gen_Eric
– gen_Eric, Commented May 23, 2016 at 14:10

gen_Eric · Accepted Answer · 2016-05-23 14:11:40Z

4

Here is the way to do it.

$array = array('a', 'b', 'c', 'd', 'e');
$query = "SELECT * FROM table WHERE `column` IN ('".implode("', '", $array)."');";
$query = mysqli_query($con, $query);

edited May 23, 2016 at 14:11

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

answered May 23, 2016 at 14:08

Valik Gubenko

15310 bronze badges

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

3 Comments

gen_Eric Over a year ago

I fixed your quotes for you :)

KANAYO AUGUSTIN UG Over a year ago

lol... I forgot I don't want to get results from the array values so i guess my code will look like this WHERE column !IN ('".implode("', '", $array)."' right?

Valik Gubenko Over a year ago

@KANAYOAUSTINKANE use "SELECT * FROM table WHERE column NOT IN ('".implode("', '", $array)."');"

Collectives™ on Stack Overflow

Search table for each array value

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related