Pass a PHP array into Mysql 'IN' clause

[bilibytes]

Hi there,

is it possible to pass a PHP array to get some data matching in a Mysql Table?

lets say i have a list of names that i get from PHP into an array:

$php_array = array(0=>'john', 1=>'marcus', 2=>'robert', 3=>'samuel'...)

and i want to know which of these are in my Table.

could i do:

SELECT user_id
FROM users
WHERE user_name IN ($php_array)

i don't know if mysql can make it..

is there a way to perform this?


thank you,

best regards

[Atli]

Hi.

You could try the implode function.

For example:

<?php
$array = array("first", "second", "third");
$list = "'". implode("', '", $array) ."'";
echo $list; // Outputs: 'first', 'second', 'third'
?>
 

The $list string could then be used in the IN function.

[bilibytes]

ok great, thankyou very much!

bilibytes

[mohamedhafezqo]

perfect, thanks very much