How to implement multiple conditions for single table column in PhalconPHP

Question

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

Nikolay Mihaylov · Accepted Answer · 2016-09-06T08:43:24.077

3

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.

edited Sep 06 '16 at 08:43

answered Sep 06 '16 at 08:36

Nikolay Mihaylov

3,868
8
27
32

1

You've forgot the bind part in your first snippet – Luke Sep 06 '16 at 08:38
Stripped the example on purpose to show only important parts. – Nikolay Mihaylov Sep 06 '16 at 08:40
2

As it's an answer for beginner phalconist question I'd post full code. It's still quite short. But it's just my opinion. Your answer - your rules – Luke Sep 06 '16 at 08:41
1

You have convinced me! :) – Nikolay Mihaylov Sep 06 '16 at 08:43

How to implement multiple conditions for single table column in PhalconPHP

1 Answers1