Home  >  Article  >  php教程  >  discuz 如何添加数据DB::insert和更新数据DB::update 查询DB::query删除DB::delete

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

PHP中文网
PHP中文网Original
2016-05-25 17:12:281983browse

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("");

}
}
else
{
echo("");
}
更新
$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 '

';
echo '';
foreach ($list as $k => $v){
echo "";
echo "";
echo "";
echo $v['isgold'] ? "" : "";
echo "";
if($v['isgold'] == 1){
echo "";
}else{
echo "";
}
if($v['isindex'] == 1){
echo "";
}else{
echo "";
}
echo "";
}
echo '
用户id展厅名展厅级别联系电话操作操作
{$v['uid']}{$v['hallname']}金牌普通{$v['telephone']}取消金牌展厅升级取消首页推荐首页推荐
';
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));
}
}    

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn