数据库之dao dao (data access object) 数据访问对象是第一个面向对象的接口 –百度百科 数据库之dao crud 查询条件 联合查询 join 事务transaction crud class indexcontroller extends ccontroller { public function actioncreate () { $rval = yii::app(
数据库之dao dao (data access object) 数据访问对象是第一个面向对象的接口
–百度百科
数据库之daocrud查询条件联合查询 join事务transactioncrudclass indexcontroller extends ccontroller{ public function actioncreate() { $rval = yii::app()->db->createcommand()->insert('user',array( 'username'=>'blue' //传入数组不需要担心注入 ， yii自动会对数组进行 参数绑定的操作写入 )); } public function actiondelete($id) { yii::app()->db->createcommand()->delete('user','id=:id',array(':id'=>$id)); } public function actionupdate($id) { yii::app()->db->createcommand()->update('user',array('username'=>'blue'),'id=:id',array(':id'=>$id)); } //一维数组 单条数据 public function actionreadrow($id) { $res = yii::app()->db->createcommand()->select('username')->from('user')->where('id=:id',array(':id'=>$id))->queryrow(); var_dump($res); } //查询列 //比如说 查询的是所有的username //返回的数组是 array('姓名1','姓名2','姓名3') public function actionreadcolumn($id) { $res = yii::app()->db->createcommand()->select('username')->from('user')->where('id=:id',array(':id'=>$id))->querycolumn(); var_dump($res); } //二维数组 查询所有 public function actionreadall($id) { $res = yii::app()->db->createcommand()->select('username')->from('user')->where('id=:id',array(':id'=>$id))->queryall(); var_dump($res); } //查询数量 //直接返回对应值，而不是数组 public function actionreadscalar() { $res = yii::app()->db->createcommand()->select('count(*)')->from('user')->queryscalar(); var_dump($res); }}
查询条件 where,like,in,limit,order,group
public function actionwhere() { $connect = yii::app()->db; $res = $connect->createcommand()->select('*')->from('user') ->where('id,array(':id'=>3)) ->queryall(); $res = $connect->createcommand()->select('*')->from('user') ->where('id>:lid and id ,array(':lid'=>3,:mid=>7)) ->queryall(); $res = $connect->createcommand()->select('*')->from('user') ->where('id > :lid',array(':lid'=>3)) ->andwhere('id ,array(':mid'=>7)) ->queryall(); $res = $connect->createcommand()->select('*')->from('user') ->where(array('and','id > :lid','id ),array(':lid'=>3,:mid=>8)) ->queryall(); $res = $connect->createcommand()->select('*')->from('user') ->where(array('and','id > :lid','id ),array(':lid'=>3,:mid=>8)) ->queryall(); $res = $connect->createcommand()->select('*')->from('user') ->where(array('in','id',array(3,4,5))) //->where(array('not in','id',array(3,4,5))) ->queryall(); $res = $connect->createcommand()->select('*')->from('user') ->where(array('like','username','%g%'))// ->where(array('not like','username','%g%'))// ->where(array('like','username',array('%g%','%o%'))) ->queryall(); $res = $connect->createcommand()->select('*')->from('user') ->where(array('and','id > :id','id ,array('or','username = :user1','username = :user2')), array(':id'=>4, ':mid'=>10, 'user1'=>'blue', 'user2'=>'green' )) ->queryall(); $res = $connect->createcommand()->select('*')->from('user') ->where(array('like','username','%g%')) ->offset(1) ->limit(2) ->queryall(); $res = $connect->createcommand()->select('*')->from('user') ->where(array('like','username','%g%')) ->order('id desc') ->queryall(); $res = $connect->createcommand()->select('*,count(*)')->from('user') ->group('username') ->queryall(); var_dump($res); }
联合查询 (join)public function actionjoin() { $res = yii::app()->db->createcommand() ->select('*') ->from('user as u') ->join('city as c','u.city = c.id')// ->leftjoin('city as c','u.city = c.id') ->queryall(); var_dump($res); }
事务(transaction)//yiichina 例子$transaction=$connection->begintransaction();try{ $connection->createcommand($sql1)->execute(); $connection->createcommand($sql2)->execute(); //.... other sql executions $transaction->commit();}catch(exception $e) // 如果有一条查询失败，则会抛出异常{ $transaction->rollback();}