discuz

推荐列表 站点导航

当前位置:首页 > 建站教程 > discuz >

discuz 如何添加数据DB::insert和更新数据DB::update 查询DB::qu

来源:网络整理  作者:  发布时间:2020-12-15 04:24
1.添加数据DB::insert $uid=empty($_POST[uid]) ? : $_POST[uid]; $username=empty($_POST[username]) ? : $_POST[username]; $display_type=empty($_POST[di...

$list[] = $value;

echo '<table width="100%" border=1>';

echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=gold&op=cancle'>取消金牌展厅</a></td>";

$arr=array();

$arr['display_type'] = $display_type;

$perpage = 25;

//删除

3.查询,返回结果集

}else{

if($op == 'add'){

echo $multipage;

if($gid){ //还要删除文件

if($type == 'gold'){

echo "<td>{$v['hallname']}</td>";

$username=empty($_POST['username']) ? "" : $_POST['username'];

}else{

$start = ($page-1)*$perpage;

if($v['isindex'] == 1){

$data = DB::fetch($query);

}elseif($op = 'cancle'){

$mpurl = ADMINSCRIPT.'?action=goldhall';

if($query){

1.添加数据DB::insert

$count = DB::result(DB::query("select uid from pre_common_member where uid= $uid"), 0);

mkdir("data/video/{$uid}/cover", 0700);

}

}

if(!empty($_POST['uid']) && !empty($_POST['display_type']) && !empty($_POST['display_type'] ))

{

echo '没有此展厅';

$videoname=empty($_POST['videoname']) ? "" : $_POST['videoname'];

}elseif($op = 'cancle'){

$count = DB::result(DB::query("SELECT COUNT(*) FROM ".DB::table('home_hall')), 0);

{

$query = DB::query("SELECT * FROM ".DB::table('home_hall')." limit $start, $perpage");

$data['isgold'] = 0;

echo "<td>{$v['uid']}</td>";

if($count){

DB::update('home_hall', array('isgold'=>$data['isgold']),array('id'=> $id));

$id = $_GET['id'] ? $_GET['id'] : 0;

$arr['filename'] = $filename; 

}

if(!file_exists("data/video/{$uid}")){

 

$data['isindex'] = 0;

 

DB::delete('saige_gekufield', array('gid' => $gid));

$data['isgold'] = 1;

echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=index&op=cancle'>取消首页推荐</a></td>";

$uid=empty($_POST['uid']) ? "" : $_POST['uid'];

$multipage = multi($count, $perpage, $page, $mpurl);

echo '<tr><td>用户id</td><td>展厅名</td><td>展厅级别</td><td>联系电话</td><td>操作</td><td>操作</td></tr>';

}

DB::delete('saige_gkcomment', array('gid' => $gid));

$data['isindex'] = 1;

}

//$query = DB::query($sql);

{

}

}

}

if($count1)

$details=empty($_POST['details']) ? "" : $_POST['details'];

mkdir("data/video/{$uid}", 0700);

echo "</tr>";

$arr['uid'] = $uid;

if($op == 'add'){

}elseif($type == 'index'){

echo "<td>{$v['telephone']}</td>";

echo "<tr>";

$count1=DB::insert('home_video',$arr);

更新

$arr['username'] = $username;

if(!file_exists("data/video/{$uid}/cover")){

$display_type=empty($_POST['display_type']) ? "" : $_POST['display_type'];

$query = DB::query("select * from ".DB::table('home_hall')." where id=$id");

echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=index&op=add'>首页推荐</a></td>";

if($count)

DB::update('home_hall', array('isindex'=>$data['isindex']),array('id'=> $id));

else

}else{

echo("<script type='text/javascript'>alert('添加成功');window.location = \"admin.php?action=video\";</script>");

echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=gold&op=add'>升级</a></td>";

}

if($multipage){

echo '</table>';

DB::delete('saige_geku', array('id' => $gid));

$arr['videoname'] = $videoname;

}

echo $v['isgold'] ? "<td>金牌</td>" : "<td>普通</td>";

foreach ($list as $k => $v){

$arr['details'] = $details;

}

if($v['isgold'] == 1){

while ($value = DB::fetch($query)) {

}

}

//$sql="insert into pre_home_video(uid,display_type,filename,default) values('$uid','$display_type','$filename','$default')";

{

if($_GET['op'] == 'delete'){

echo("<script type='text/javascript'>alert('添加失败,该用户不存在');</script>");

$filename=empty($_POST['filename']) ? "" : $_POST['filename']; 

}

相关热词: discuz

本站内容来源于网络,如有侵权请与我们联系,我们会及时删除,我们深感抱歉!
注:本站所有信息仅供用于网络技术学习参考,学习中请遵循相关法律法规!

本文地址: https://v30.fanwenzhu.com/jz/discuz/4006.shtml

Copyright © www.juheyunku.com      关于 | 合作 | 声明 | 联系 | 更新 | 地图 | Tags

discuz 如何添加数据DB::insert和更新数据DB::update 查询DB::qu

2020-12-15 编辑:

$list[] = $value;

echo '<table width="100%" border=1>';

echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=gold&op=cancle'>取消金牌展厅</a></td>";

$arr=array();

$arr['display_type'] = $display_type;

$perpage = 25;

//删除

3.查询,返回结果集

}else{

if($op == 'add'){

echo $multipage;

if($gid){ //还要删除文件

if($type == 'gold'){

echo "<td>{$v['hallname']}</td>";

$username=empty($_POST['username']) ? "" : $_POST['username'];

}else{

$start = ($page-1)*$perpage;

if($v['isindex'] == 1){

$data = DB::fetch($query);

}elseif($op = 'cancle'){

$mpurl = ADMINSCRIPT.'?action=goldhall';

if($query){

1.添加数据DB::insert

$count = DB::result(DB::query("select uid from pre_common_member where uid= $uid"), 0);

mkdir("data/video/{$uid}/cover", 0700);

}

}

if(!empty($_POST['uid']) && !empty($_POST['display_type']) && !empty($_POST['display_type'] ))

{

echo '没有此展厅';

$videoname=empty($_POST['videoname']) ? "" : $_POST['videoname'];

}elseif($op = 'cancle'){

$count = DB::result(DB::query("SELECT COUNT(*) FROM ".DB::table('home_hall')), 0);

{

$query = DB::query("SELECT * FROM ".DB::table('home_hall')." limit $start, $perpage");

$data['isgold'] = 0;

echo "<td>{$v['uid']}</td>";

if($count){

DB::update('home_hall', array('isgold'=>$data['isgold']),array('id'=> $id));

$id = $_GET['id'] ? $_GET['id'] : 0;

$arr['filename'] = $filename; 

}

if(!file_exists("data/video/{$uid}")){

 

$data['isindex'] = 0;

 

DB::delete('saige_gekufield', array('gid' => $gid));

$data['isgold'] = 1;

echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=index&op=cancle'>取消首页推荐</a></td>";

$uid=empty($_POST['uid']) ? "" : $_POST['uid'];

$multipage = multi($count, $perpage, $page, $mpurl);

echo '<tr><td>用户id</td><td>展厅名</td><td>展厅级别</td><td>联系电话</td><td>操作</td><td>操作</td></tr>';

}

DB::delete('saige_gkcomment', array('gid' => $gid));

$data['isindex'] = 1;

}

//$query = DB::query($sql);

{

}

}

}

if($count1)

$details=empty($_POST['details']) ? "" : $_POST['details'];

mkdir("data/video/{$uid}", 0700);

echo "</tr>";

$arr['uid'] = $uid;

if($op == 'add'){

}elseif($type == 'index'){

echo "<td>{$v['telephone']}</td>";

echo "<tr>";

$count1=DB::insert('home_video',$arr);

更新

$arr['username'] = $username;

if(!file_exists("data/video/{$uid}/cover")){

$display_type=empty($_POST['display_type']) ? "" : $_POST['display_type'];

$query = DB::query("select * from ".DB::table('home_hall')." where id=$id");

echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=index&op=add'>首页推荐</a></td>";

if($count)

DB::update('home_hall', array('isindex'=>$data['isindex']),array('id'=> $id));

else

}else{

echo("<script type='text/javascript'>alert('添加成功');window.location = \"admin.php?action=video\";</script>");

echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=gold&op=add'>升级</a></td>";

}

if($multipage){

echo '</table>';

DB::delete('saige_geku', array('id' => $gid));

$arr['videoname'] = $videoname;

}

echo $v['isgold'] ? "<td>金牌</td>" : "<td>普通</td>";

foreach ($list as $k => $v){

$arr['details'] = $details;

}

if($v['isgold'] == 1){

while ($value = DB::fetch($query)) {

}

}

//$sql="insert into pre_home_video(uid,display_type,filename,default) values('$uid','$display_type','$filename','$default')";

{

if($_GET['op'] == 'delete'){

echo("<script type='text/javascript'>alert('添加失败,该用户不存在');</script>");

$filename=empty($_POST['filename']) ? "" : $_POST['filename']; 

}

本站内容来源于网络,如有侵权请与我们联系,我们会及时删除,我们深感抱歉!
注:本站所有信息仅供学习参考!
本文地址为 https://v30.fanwenzhu.com/jz/discuz/4006.shtml

相关文章

风云图片

推荐阅读

返回discuz频道首页