dqy1265 2016-09-06 08:32
浏览 305
已采纳

如何在PhalconPHP中为单表列实现多个条件

What would be the right syntax to find the sum of money saved in plans where the status is either abanadoned or completed:

$total = self::sum([
    'column' => 'amount_saved_so_far',
    'conditions' => 'status = "completed" AND user_id = :user_id:',
    //find plans with a status of abandoned as well
    'bind' => ['user_id' => $userId]
]);
  • 写回答

1条回答 默认 最新

  • dongyu9667 2016-09-06 08:36
    关注

    You could simply do and it's perfectly fine solution:

    $total = self::sum([
        'column' => 'amount_saved_so_far',
        'conditions' => '(status = "completed" OR status = "abanadoned") 
                         AND user_id = :user_id:',
        'bind' => ['user_id' => $userId]
    ]);
    

    Or another option would be to use array binding:

    $total = self::sum([
        'column' => 'amount_saved_so_far',
        'conditions' => 'status IN ({vars:array}) AND user_id = :user_id:',
        'bind' => [
            'vars' => ['completed', 'abanadoned'],
            'user_id' => $userId
        ]
    ]);
    

    Second option is more elegant and more practical in case you have more values for the IN clause.

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

报告相同问题?

悬赏问题

  • ¥15 关于#matlab#的问题:需要 MATLAB 运行程序,对比四个多址通信方式(TDMA,FDMA,CDMA,OFDMA)的抗噪声性能
  • ¥15 有没有复现过PFENet的,如何解决?
  • ¥15 FDMA,OFDMA,TDMA 和 CDMA 系统容量对比仿真
  • ¥15 图神经网络的入侵检测
  • ¥15 工业数据采集技术+存储架构推荐
  • ¥15 GPT-SOVITS如何训练少数民族语言支持合成语音
  • ¥20 树莓派4b使用Camera Module 3时出现the system should be configured for the legacy camera stack问题
  • ¥200 GitHub开源程序配置在VScode调试
  • ¥15 爬虫保存的scv文件0kb
  • ¥20 如何实现基于强化学习的带电作业机械臂的运动规划与控制