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, my sample model for search with relataionship

A model file for yii which has search fucntion which searches using relation ship: <?php/** * This is the model class for table “sf_category_slider”. * * The followings are the available columns in table ‘sf_category_slider’: * @property integer $rec_id * @property integer $cat_id * @property string $brand_id * @property string $slider_image * @property string $slider_link… Continue reading YII, my sample model for search with relataionship

yii, some form validation examples

Yii some basic form validations using rules in modelslike email, compare password (match password), date, unique, captcha etc Below is full model code: <?php/** * This is the model class for table "users". * * The followings are the available columns in table 'users': * @property integer $user_id * @property string $user_name * @property string… Continue reading yii, some form validation examples

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