通过db执行sql语句
//添加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();
//查询一条数据
$sql ="SELECT id,name FROM tbl_user WHERE email='123@qq.com'";
$users=Yii::app()->db->createCommand($sql)->queryRow();
php返回数据给ajax
echo json_encode($array);
php中json_decode()和json_encode()的使用方法
javascript 将json字符串转换为json对象的方法解析 (待搞懂)
