discuz 如何添加数据DB::insert和更新数据DB::update 查询DB::query删除DB::delete

1.添加数据db::insert
$uid=empty($_post['uid']) ? "" : $_post['uid'];
$username=empty($_post['username']) ? "" : $_post['username'];
$display_type=empty($_post['display_type']) ? "" : $_post['display_type'];
$filename=empty($_post['filename']) ? "" : $_post['filename']; 
$details=empty($_post['details']) ? "" : $_post['details'];
$videoname=empty($_post['videoname']) ? "" : $_post['videoname'];
//$sql="insert into pre_home_video(uid,display_type,filename,default) values('$uid','$display_type','$filename','$default')";
//$query = db::query($sql);
if(!empty($_post['uid']) && !empty($_post['display_type']) && !empty($_post['display_type'] ))
{
$count = db::result(db::query("select uid from pre_common_member where uid= $uid"), 0);
if($count)
{
$arr=array();
$arr['uid'] = $uid;
$arr['username'] = $username;
$arr['display_type'] = $display_type;
$arr['filename'] = $filename; 
$arr['details'] = $details;
$arr['videoname'] = $videoname;
if(!file_exists("data/video/{$uid}")){
mkdir("data/video/{$uid}", 0700);
}
if(!file_exists("data/video/{$uid}/cover")){
mkdir("data/video/{$uid}/cover", 0700);
}
$count1=db::insert('home_video',$arr);
if($count1)
{
echo("");

}
}
else
{
echo("");
}
更新
$id = $_get['id'] ? $_get['id'] : 0;
$query = db::query("select * from ".db::table('home_hall')." where id=$id");
if($query){
$data = db::fetch($query);
if($type == 'gold'){
if($op == 'add'){
$data['isgold'] = 1;
}elseif($op = 'cancle'){
$data['isgold'] = 0;
}
db::update('home_hall', array('isgold'=>$data['isgold']),array('id'=> $id));
}elseif($type == 'index'){
if($op == 'add'){
$data['isindex'] = 1;
}elseif($op = 'cancle'){
$data['isindex'] = 0;
}
db::update('home_hall', array('isindex'=>$data['isindex']),array('id'=> $id));
}
}else{
echo '没有此展厅';
}
3.查询，返回结果集
$perpage = 25;
$start = ($page-1)*$perpage;
$mpurl = adminscript.'?action=goldhall';
$count = db::result(db::query("select count(*) from ".db::table('home_hall')), 0);
if($count){
$query = db::query("select * from ".db::table('home_hall')." limit $start, $perpage");
while ($value = db::fetch($query)) {
$list[] = $value;
}
$multipage = multi($count, $perpage, $page, $mpurl);
}

echo '