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:

Expand|Select|Wrap|Line Numbers

$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:

Expand|Select|Wrap|Line Numbers

 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:

Expand|Select|Wrap|Line Numbers

 
<?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

Pass a PHP array into Mysql 'IN' clause

re: Pass a PHP array into Mysql 'IN' clause

re: Pass a PHP array into Mysql 'IN' clause

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about