北漂的女孩

//添加数据
$test = new test();
$test->id = wqewrw;
$test->title = '测试';    
$test->save();

//删除数据
$result = Test::find()->where(['id'=>1])->all();
$result[0]->delete();
Test::deleteAll('id>:id',array(":id"=>3));

//修改数据
$test = Test::find()->where(['id'=>6])->one();
$test->title = "学习yii2";
$test->save();

//查询
$id = '1 or 1=1';
$sql = "select * from test where id =:id";
$result  = Test::findBySql($sql,array(':id' =>$id))->asarray()->all();
//id=1
$result = Test::find()->where(['id'=>1])->all();
//id >1
$result = Test::find()->where(['>','id','1'])->asarray()->all();
//id>=1orid<=2
$result = Test::find()->where(['between','id','1','2'])->asarray()->all();
//title like "%title%"
$result = Test::find()->where(['like','title','title'])->asarray()->all();
//循环查询数据
foreach (Test::find()->batch(3) as $key ) {
    print_r( count($key));
}