dongtanliefang8765 2018-05-18 22:41
浏览 842
已采纳

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

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 ?

  • 写回答

1条回答 默认 最新

  • dongyun6835 2018-05-18 22:52
    关注
    $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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 画CAD几张图片内容如下1111111111111111111111111111111111111111111
  • ¥15 基于python的电影系统推荐
  • ¥20 springmvc重定向和返回json
  • ¥15 数学建模——参会安排怎么做
  • ¥15 电脑键盘实现触摸功能
  • ¥25 matlab无法将表达式转换为双数组怎么解决?
  • ¥15 单片机汇编语言相关程序
  • ¥20 家用射频美容仪技术规格
  • ¥15 大家帮我看看为什么错了
  • ¥15 unity互动琴弦抖动效果