YII2 DB Count Results query

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… Continue reading YII2 DB Count Results query

yii, mode rule for unique composite key

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… Continue reading yii, mode rule for unique composite key