discuz 增删该查

来源：互联网发布：淘宝账号名称怎么改编辑：程序博客网时间：2024/04/30 21:23

1.添加数据DB::insert
uid=empty(_POST[‘uid’]) ? “” : POST[‘uid′];username=empty(POST[‘username′])?“”:_POST[‘username’];
displaytype=empty(_POST[‘display_type’]) ? “” : POST[‘displaytype′];filename=empty(POST[‘filename′])?“”:_POST[‘filename’];
details=empty(_POST[‘details’]) ? “” : POST[‘details′];videoname=empty(POST[‘videoname′])?“”:_POST[‘videoname’];
//sql="insertintoprehomevideo(uid,displaytype,filename,default)values(′uid’,’displaytype′,′filename’,’default′)”;//query = DB::query(sql);if(!empty(_POST['uid']) && !empty(_POST[‘display_type’]) && !empty(_POST[‘display_type’] ))
{
count=DB::result(DB::query("selectuidfromprecommonmemberwhereuid=uid”), 0);
if(count)
            {arr=array();
arr[′uid′]=uid;
arr[′username′]=username;
arr[′displaytype′]=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("<script type='text/javascript'>alert('添加失败，该用户不存在');</script>");        }

更新
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(‘homehall′,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(“SELECTCOUNT(∗)FROM“.DB::table(‘homehall′)),0);if(count){
query=DB::query("SELECT∗FROM".DB::table(′homehall′)."limitstart, perpage”);while(value = DB::fetch(query))$list[]=$value;multipage = multi(count,perpage, page,mpurl);
}

        echo '<table width="100%" border=1>';        echo '<tr><td>用户id</td><td>展厅名</td><td>展厅级别</td><td>联系电话</td><td>操作</td><td>操作</td></tr>';        foreach ($list as $k => $v){            echo "<tr>";            echo "<td>{$v['uid']}</td>";            echo "<td>{$v['hallname']}</td>";            echo $v['isgold'] ? "<td>金牌</td>" : "<td>普通</td>";            echo "<td>{$v['telephone']}</td>";            if($v['isgold'] == 1){                echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=gold&op=cancle'>取消金牌展厅</a></td>";            }else{                echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=gold&op=add'>升级</a></td>";            }            if($v['isindex'] == 1){                echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=index&op=cancle'>取消首页推荐</a></td>";            }else{                echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=index&op=add'>首页推荐</a></td>";            }            echo "</tr>";        }        echo '</table>';        if($multipage){            echo $multipage;        }

//删除
if(_GET[‘op’] == ‘delete’){
if(gid){ //还要删除文件
DB::delete(‘saige_geku’, array(‘id’ => gid));DB::delete(‘saigegekufield′,array(‘gid′=>gid));
DB::delete(‘saige_gkcomment’, array(‘gid’ => $gid));
}

}

0 0