how to use IN-function within Zend_Select

Question

I different string values komma separated out of a form.

In the code I cast them and then it looks like this:

$kritkeyword ='test, abc, xyz';

Now I want to use the variable within an IN-function. In original sql ist would be:

where keyword IN ('test', 'abc', 'xyz')

In my code I tried to do the following:

$select->where('keyword IN (?)', $kritkeyword);

I also tried:

$select->where(['keyword IN ?' =>$kritkeyword]);

Until now I had different ideas how to write it, but I always get a sql error. So how to do this correct?

score 1 · Accepted Answer · answered Aug 07 '20 at 13:32

1

You must use Zend\Db\Sql\Where. If $kitkeyword is array :

$condition = new Zend\Db\Sql\Where();
$condition->in('keyword', $kritkeyword);
$select->where($condition);

answered Aug 07 '20 at 13:32

Alain Pomirol

1

You can also you $select->where->in('keyword', $kritkeyword); as zend then will behind the scene create a Zend\Db\Sql\Where Object – Otto Sandström Aug 13 '20 at 13:19
thats the same like Alain Pomirol suggested – pia-sophie Aug 17 '20 at 07:03

1 Answers1