Computer Programming CookBook

YII2 DB count results query Simple in the controller or view file add do this: $count =MODEL:: find ()   ->select([ 'COUNT(id) AS cnt' ])   ->where([   'field1' => $value1 , ])-> andWhere([ '>' , 'field2' , $value2 ]) - >one()->cnt; And in the model of the table add before this line: public static function tableName() Add public $cnt ; like below: public $cnt ; public static function tableName() {

Here is the code to to make a rule in the model file to make unique composite keys : Save code below as proctected/components/CompositeUniqueKeyValidator.php <?php /** * CompositeUniqueKeyValidator class file. */ class CompositeUniqueKeyValidator extends CValidator { /** * @var string comma separated columns that are unique key */ public $keyColumns ; public $errorMessage = '"{columns_labels}" are not unique' ; /** * @var boolean whether the error message should be added to all of the columns */ public $addErrorToAllColumns = false ; /** * @param CModel $object the object being validated * @param string $attribute if there is an validation error then error message * will be added to this property */ protected function validateAttribute ( $object , $attribute ) { $class = get_class ( $object ); Yii :: import ( $class ); $ke...