Yii中的数据库事务的使用方法小结_PHP教程

<?php $array=array(
	0=>array('username'=>'phpernote.com_0','password'=>'123456'),
	1=>array('username'=>'u_1','password'=>'123456'),
	2=>array('username'=>'u_2','password'=>'123456')
);
$transaction=Yii::app()->db->dbConnection->beginTransaction();
//此处db代表的是定义在main.php中的数据库连接对象db
try{
	Yii::app()->db->createCommand()->insert('tbl_user',$array[0]);
	Yii::app()->db->createCommand()->insert('tbl_user',$array[1]);
	Yii::app()->db->createCommand()->insert('tbl_user',$array[2]);
	$transaction->commit();
}catch(Exception $e){
	$transaction->rollback();
}