discuz 增删该查

最新推荐文章于 2023-03-01 10:43:49 发布

discuzmall

最新推荐文章于 2023-03-01 10:43:49 发布

阅读量248

点赞数

分类专栏： discuz

discuz 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

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′)."limit start, 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));
}