新增
Db::execute('insert into think_user (id, name) values (:id, :name)',['id'=>8,'name'=>'thinkphp']);
修改
$param= [
'id'=>input['id'],
'test'=>input['test']
]
$sql = "update 表 set id=:id,test=:test";
$val = Db:excute($sql,$param);
查询
Db::query('select * from think_user where id=:id',['id'=>8]);