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.
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.
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.
Transaction represents a DB transaction. Yii 2.0 have this feature. we can use beginTransaction function before every query.
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
In Yii Framework 2.0, This tutorial will help you to understand the models and SQL queries command.
This tutorial will help you to learn Relation Model, joinwith, innerJoinWith, Join, leftJoin and model query in yii framework 2.0
Yii2.0 framework contains the Scopes functionalities. It will useful to make advanced query concept in yii model query
In Yii Framework 2.0, This tutorial will help you to understand the models and Update Query command.