国产三级农村妇女在线,国产精品毛片a∨一区二区三区,国产乱子伦视频大全,国产精品色拉拉,国产欧美日韩一区二区三区,

首頁 > 技術(shù) > cms教程

discuz 如何添加數(shù)據(jù)DB::insert和更新數(shù)據(jù)DB::update 查詢DB::qu

小編 cms教程 2024-04-01 16:40:50
1.添加數(shù)據(jù)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.查詢，返回結(jié)果集
$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展廳名展廳級別聯(lián)系電話操作操作
{$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));
}
}

TAg

加載中~

本網(wǎng)站LOGO受版權(quán)及商標(biāo)保護(hù)，版權(quán)登記號：國作登字-2022-F-10126915，未經(jīng)湖南木星科技官方許可，嚴(yán)禁使用。
Copyright ? 2012-2022 湖南木星科技有限公司（木星網(wǎng)）版權(quán)所有
轉(zhuǎn)載內(nèi)容版權(quán)歸作者及來源網(wǎng)站所有，本站原創(chuàng)內(nèi)容轉(zhuǎn)載請注明來源，商業(yè)媒體及紙媒請先聯(lián)系：aishangyiwan@126.com

工信部備案號：湘ICP備19012813號-5