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]
]);

图片转代码服务由CSDN问答提供 功能建议

找到 status abanadoned completed

  $ total = self :: sum([
'column'=  >'amount_saved_so_far',
'conditions'=>'status =“completed”AND user_id =:user_id:',
 //找到状态为废弃的计划
'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.

    点赞 打赏 评论

相关推荐 更多相似问题