// 獲得數(shù)據(jù)庫(kù)連接
$conn = Yii::$app->db;
// 執(zhí)行數(shù)據(jù)庫(kù)查詢語(yǔ)句
Yii::$app->db->createCommand("SELECT * FROM `user`");Yii::$app->db->createCommand("SELECT * FROM `user` WHERE uid=:uid",[":uid"=>1]);Yii::$app->db->createCommand("SELECT * FROM `user` WHERE uid=:uid")->addValue([":uid"=>1]);
// SQL語(yǔ)句插入數(shù)據(jù)
Yii::$app->db->createCommand('INSERT INTO user (email, password) VALUES("test3@example.com", "test3");')->execute();
// 數(shù)組形式插入數(shù)據(jù)
Yii::$app->db->createCommand()->insert('user', ['email'=>'test4@example.com','password'=>'changeme7','first_name'=>'Test'])->execute();
// 批量插入數(shù)據(jù)
Yii::$app->db->createCommand()->batchInsert('user', ['email','password','first_name'],[['james.franklin@example.com','changeme7','James'],['linda.marks@example.com','changeme7','Linda']['roger.martin@example.com','changeme7']])->execute();
// 更新數(shù)據(jù)
Yii::$app->db->createCommand()->update('user', ['updated_at'=> time()],'id = 2')->execute();
// 刪除數(shù)據(jù)
Yii::$app->db->createCommand()->delete('user','id = 3')->execute();
獲取結(jié)果方法
// 獲取所有數(shù)據(jù)(數(shù)組形式返回)
Yii::$app->db->createCommand("SELECT * FROM `user`")->queryAll();
// 獲取一條數(shù)據(jù)（一維數(shù)組）
Yii::$app->db->createCommand("SELECT * FROM `user` WHERE id = 1")->queryOne();
// 獲取一個(gè)值
Yii::$app->db->createCommand("SELECT count(*) AS total FROM `user` WHERE id = 1")->queryScalar();
// 獲取某一列（放到一位數(shù)組中）
Yii::$app->db->createCommand("SELECT username FROM `user`")->queryColumn();
