作者:宅妈每日贴_889 | 来源:互联网 | 2023-07-20 18:19
通过上面的学习,应该不难掌握Query Builder的使用方法。这里简单做实例,仅供参考。
//添加Yii::app()->db->createCommand()->insert('tbl_user', array('username' => 'zhangsan', 'email' => 'zhangsan@zs.com'));//修改Yii::app()->db->createCommand()->update('tbl_user', array('username' => 'Tester'), 'id=:id', array(':id' => 3));//删除 Yii::app()->db->createCommand()->delete('tbl_user', 'id=:id', array(':id' => 2));//查询$users = Yii::app()->db->createCommand()->select('*')->from('tbl_user')->queryAll();var_dump($users);