tp5使用占位符

新增

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]);