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));
}
}