查询操作:
User::find()->one();
each查询
$query = (new Query())->from('student')->where(['classes_id'=>6])->batch(10);
echo '<pre>';
foreach ($query as $students){
var_dump($students);
}
batch查询
$query = (new Query())->from('student')->where(['classes_id'=>6])->each(10);
echo '<pre>';
foreach ($query as $students){
var_dump($students);
}
新增操作:
$model = newUser();
$model->username = 'username';
$model->age = '20';
$model->insert();
$connection = Yii::$app->db;
$r = $connection->createCommand()
->insert('classes',['name'=>'class','school_id'=>67843,'comment'=>'test','is_pay'=>0,'account_type_id'=>2])
->execute();
$class = new Classes();
$class->name = 'class2';
$class->school_id = 67843;
$r = $class->save();
批量插入
$connection = Yii::$app->db;
$r = $connection->createCommand()
->batchInsert('classes',['name','school_id'],[['class3','67843'],['class4','67843']])
->execute();
修改操作:
$User = User::findOne($id);
$User->name = 'zhangsan';
$User->save();
删除操作:
User::deleteAll('name = username'); 删除 name = username 的数据;
User::findOne($id)->delete(); 删除主键为 $id变量 值的数据库;
User::deleteAll('age > :age AND sex = :sex', [':age' => '20', ':sex' => '1']); 删除符合条件的数据;