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

最新推荐文章于 2021-02-23 08:30:25 发布

a771948524

最新推荐文章于 2021-02-23 08:30:25 发布

阅读量3.6k

点赞数

分类专栏： PHP

PHP 专栏收录该内容

82 篇文章 0 订阅

订阅专栏

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("<script type='text/javascript'>alert('添加成功');window.location = \"admin.php?action=video\";</script>");
                   
                }
            }
            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('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 '<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('saige_gekufield', array('gid' => $gid));
        DB::delete('saige_gkcomment', array('gid' => $gid));
    }
   
}