How to pass an array into IN() clause?

Question

I have an array like this:

$str = 'In My Cart : 11 12 items';
preg_match_all('!\d+!', $str, $matches);
print_r($matches); // output is two number: 11, 12

Now I want to know, how can I pass this array $matches to this query?

SELECT column_name(s)
FROM table_name
WHERE column_name IN ($matches); // actually I want something like this: IN (11, 12)

Is there any solution?

Sougata Bose · Accepted Answer · 2015-10-14T08:40:56.263

5

Use implode -

"SELECT column_name(s)
FROM table_name
WHERE column_name IN (" .implode(',', $matches[0]) . ")";

edited Oct 14 '15 at 08:40

answered Oct 14 '15 at 08:33

Sougata Bose

Seems correct, Thanks ... (I will check it and accept it as my answer if worked correctly). +1 upvote – Shafizadeh Oct 14 '15 at 08:34
Well, there is a small problem, the output of this `implode(',', $matches)` is this: `array`! I think I need two `implode()` – Shafizadeh Oct 14 '15 at 08:38
Can you add `var_dump($matches)`? – Sougata Bose Oct 14 '15 at 08:39
`array(1) { [0]=> array(2) { [0]=> string(2) "11" [1]=> string(2) "12" } }` – Shafizadeh Oct 14 '15 at 08:40
Check the updated answer. – Sougata Bose Oct 14 '15 at 08:41
In your opinion, do I need to use prepared statements in this case? I think it is not necessarily, because the output is just numbers, am I right? – Shafizadeh Oct 14 '15 at 08:52
Using prepared statements is a good practice. – Sougata Bose Oct 14 '15 at 08:54

1 Answers1