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