Mvc\Model::sum

public static mixed sum ([array $parameters])

Allows to calculate a sum on a column that match the specified conditions

//How much are all robots?
 $sum = Robots::sum(array('column' => 'price'));
 echo "The total price of robots is ", $sum, "\n";

 //How much are mechanical robots?
 $sum = Robots::sum(array("type = 'mechanical'", 'column' => 'price'));
 echo "The total price of mechanical robots is  ", $sum, "\n";

Links:

https://docs.phalconphp.com/en/latest/api/Phalcon_Mvc_Model.html#sum

doc_Phalcon

2016-10-16 09:52:57

Comments

Popular Articles

db.models.Sum class Sum(expression, output_field=None, **extra) [source] Computes the sum of all values of the given expression. Default alias: <field>__s

Mvc\Model implements Phalcon\Mvc\EntityInterface, Phalcon\Mvc\ModelInterface, Phalcon\Mvc\Model\ResultInterface, Phalcon\Di\InjectionAwareInterface, Serializab

Mvc\Model::getRelated public Phalcon\Mvc\Model\ResultsetInterface getRelated (string $alias, [array $arguments]) Returns related records based on defined relations

Mvc\Model::toArray public array toArray ([array $columns]) Returns the instance as an array representation print_r($robot->toArray());

Mvc\Model::getDI public getDI () Returns the dependency injection container