如何在mysql查询中使用foreach循环

Question

I want to add some condition to my sql select by using foreach loop. For example:

select id, custom_id, name, customer from db_clients where id = 5

By using foreach I want to and more "where" condition.

select id, custom_id, name, customer from db_clients where id = 5 and id = 19

My PHP code:

$this ='select id, custom_id, name, customer from db_clients where id = 5' . foreach($ids AS $id){
'. and id = '.$id}';

Where is the problem ?

Answer 1

$this ='select id, custom_id, name, customer from db_clients where id in ('.implode(',',$ids).') ';

That does assume $ids always has at least one array value, it is can be empty you need to add another check before doing that or add a -1 or some id that will never exists into the array before populating it just to be sure it's never empty there's many ways to handle an empty situation.