Array of IDs as fetchAll parameter

Asked Jul 09 '15 at 10:18

Active Jul 09 '15 at 10:58

Viewed 31 times

I have the following function:

public function findByIds($ids = array())
{
    return Database :: fetchAll('SELECT * FROM foo_bar WHERE test = 0 AND id IN :ids', array(
        array(':ids', $ids)
    ));
}

But it doesn't work of course. The $ids variable has the following structure:

array(3) { [0]=> array(1) { ["id"]=> string(3) "101" } [1]=> array(1) { ["id"]=> string(3) "102" } [2]=> array(1) { ["id"]=> string(3) "110" } }

How can I match my query to find only rows specified by ids from my array?

edited Jul 09 '15 at 10:58

Your Common Sense

156,878
40
214
345

asked Jul 09 '15 at 10:18

Karol Hernik

What does that mean its not working. What is the error? – B001ᛦ Jul 09 '15 at 10:21
It's just wrong, I can't substitute string with array. Is there any way to do this? – Karol Hernik Jul 09 '15 at 10:23
Does @Uchia s answer not work? – B001ᛦ Jul 09 '15 at 10:25
you have to catch the array **values** in an array and search with IN – B001ᛦ Jul 09 '15 at 10:26
Are you getting any error while using my answer @KarolHernik – Narendrasingh Sisodia Jul 09 '15 at 10:30

Array of IDs as fetchAll parameter

0 Answers0