Yii2.0 Database Model Tutorials

Upsert is an atomic operation. `Upsert()` will insert new record into a database table If table do not already exist or update them. upsert( $table, $insertColumns, $updateColumns = true, $params = []) Using QueryBuilder $sql = $queryBuilder->upsert('pages', [ 'name' => 'Home page', 'url' => 'http://bsourcecode.com/', // url is unique 'visits' => 10000, ], [ 'visits' => new \yii\db\Expression('visits + 1'), ], $params = array()); Using Command: Yii::$app->db->createCommand()->upsert('pages', [ 'name' => […]... Read More »

Yii2.0 SqlDataProvider is used to get the data provider using plain SQL statement. SqlDataProvider is return the data provider as array for each row of query result.... Read More »

Yii2.0 is giving the support for data validation and also it is very easy way to test the input data. To check validate() of input data, we should declare validation rules for the attributes you plan to validate.... Read More »

Yii2.0 framework model is designed in very comfortable way for dynamic logic based on scenario. In this tutorial i will share my experience about Scenarios. A model may be used in different scenarios in different business rules and logic.... Read More »

Transaction represents a DB transaction. Yii 2.0 have this feature. we can use beginTransaction function before every query.... Read More »

This tutorial will help you to learn find, all, one, where, orderby, count, asarray, indexby, limit, offset, like, in, between, groupby, having, addparams, scopes and findbysql in yii 2.0 framework function... Read More »

In Yii Framework 2.0, This tutorial will help you to understand the models and SQL queries command.... Read More »

This tutorial will help you to learn Relation Model, joinwith, innerJoinWith, Join, leftJoin and model query in yii framework 2.0... Read More »

Yii2.0 framework contains the Scopes functionalities. It will useful to make advanced query concept in yii model query... Read More »

In Yii Framework 2.0, This tutorial will help you to understand the models and Update Query command.... Read More »