TP5增删改查

//增

public function insert(){


//执行查询语句


$data=Db::execute("insert into gx_ni value(null,'dsadsa','123')");
dump ($data);
}

//删除

public function delete(){


$data=Db::execute("delete from gx_member where user_id=1");
dump ($data);


}

//改


public function update(){


$data=Db::execute("update gx_ni set old='32' where id=4");
dump ($data);
}

//查


public function select(){

// 查询数据

//使用系统类查询
// $data=Db::query("select * from gx_member");
// dump ($data);

//查询指定的ID的数据

$data=Db::query("select *from gx_member where user_id=?",[2]);
dump ($data);
//获取执行的sql语句


// echo Db::getLastSql();


}