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

1.添加数据DB::insert
$uid=empty($_POST[&＃39;uid&＃39;]) ? "" : $_POST[&＃39;uid&＃39;];
$username=empty($_POST[&＃39;username&＃39;]) ? "" : $_POST[&＃39;username&＃39;];
$display_type=empty($_POST[&＃39;display_type&＃39;]) ? "" : $_POST[&＃39;display_type&＃39;];
$filename=empty($_POST[&＃39;filename&＃39;]) ? "" : $_POST[&＃39;filename&＃39;];
$details=empty($_POST[&＃39;details&＃39;]) ? "" : $_POST[&＃39;details&＃39;];
$videOname=empty($_POST[&＃39;videoname&＃39;]) ? "" : $_POST[&＃39;videoname&＃39;];
//$sql="insert into pre_home_video(uid,display_type,filename,default) values(&＃39;$uid&＃39;,&＃39;$display_type&＃39;,&＃39;$filename&＃39;,&＃39;$default&＃39;)";
//$query = DB::query($sql);
if(!empty($_POST[&＃39;uid&＃39;]) && !empty($_POST[&＃39;display_type&＃39;]) && !empty($_POST[&＃39;display_type&＃39;] ))
{
$count = DB::result(DB::query("select uid from pre_common_member where uid= $uid"), 0);
if($count)
{
$arr=array();
$arr[&＃39;uid&＃39;] = $uid;
$arr[&＃39;username&＃39;] = $username;
$arr[&＃39;display_type&＃39;] = $display_type;
$arr[&＃39;filename&＃39;] = $filename;
$arr[&＃39;details&＃39;] = $details;
$arr[&＃39;videoname&＃39;] = $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(&＃39;home_video&＃39;,$arr);
if($count1)
{
echo("");

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

echo &＃39;&＃39;;
echo &＃39;&＃39;;
foreach ($list as $k => $v){
echo "";
echo "";
echo "";
echo $v[&＃39;isgold&＃39;] ? "" : "";
echo "";
if($v[&＃39;isgold&＃39;] == 1){
echo "";
}else{
echo "";
}
if($v[&＃39;isindex&＃39;] == 1){
echo "";
}else{
echo "";
}
echo "";
}
echo &＃39;

用户id	展厅名	展厅级别	联系电话	操作	操作
{$v[&＃39;uid&＃39;]}	{$v[&＃39;hallname&＃39;]}	金牌	普通	{$v[&＃39;telephone&＃39;]}	取消金牌展厅	升级	取消首页推荐	首页推荐

&＃39;;
if($multipage){
echo $multipage;
}
//删除
if($_GET[&＃39;op&＃39;] == &＃39;delete&＃39;){
if($gid){ //还要删除文件
DB::delete(&＃39;saige_geku&＃39;, array(&＃39;id&＃39; => $gid));
DB::delete(&＃39;saige_gekufield&＃39;, array(&＃39;gid&＃39; => $gid));
DB::delete(&＃39;saige_gkcomment&＃39;, array(&＃39;gid&＃39; => $gid));
}
}