创建数据模型
common/models/ssdb/User.php
/**
* This is the ActiveRecord class for [[\common\models\User]].
*
* @property string $user_id
* @property string $name
* @property integer $age
* @property integer $status
*/
class User extends \wsl\ssdb\ActiveRecord
{
public static $modelClass = '\common\models\User';
}
新增或者替换数据
$userModel = new User();
$userModel->user_id = 1000000;
$userModel->name = '张三';
$userModel->age = 19;
$userModel->status = 0;
$userModel->save();
获取一条数据
$model = User::find()->one();
获取一条数据 排序
$model = User::find()->orderBy('user_id asc')->one();
删除全部
User::deleteAll();
获取一条数据 条件查询
$model = User::find()->andWhere(['user_id' => 1000000])->one();
获取一条数据 多条件查询
$model = User::find()->andWhere(['user_id' => 1000000, 'age' => 19])->one();
获取所有数据列表
$models = User::find()->all();
获取所有数据列表 排序
$models = User::find()->orderBy('age desc')->all();
获取所有数据列表 条件查询
$models = User::find()->andWhere(['user_id' => 1000000])->all();
偏移数据和限定数据返回条数
$models = User::find()->offset(1)->limit(1)->all();
使用DataProvider
$dataProvider = new ActiveDataProvider([
'query' => User::find(),
'pagination' => [
'pageSize' => 20,
],
]);
foreach ($dataProvider->getModels() as $itemModel) {
// code...
}