Discuz教程网

[插件制作] discuz 如何添加数据DB::insert和更新数据DB::update 查询DB::query删除DB::delete

[复制链接]
authicon dly 发表于 2012-8-3 20:59:51 | 显示全部楼层 |阅读模式
  1. 1.添加数据DB::insert
  2. $uid=empty($_POST['uid']) ? "" : $_POST['uid'];
  3. $username=empty($_POST['username']) ? "" : $_POST['username'];
  4. $display_type=empty($_POST['display_type']) ? "" : $_POST['display_type'];
  5. $filename=empty($_POST['filename']) ? "" : $_POST['filename'];
  6. $details=empty($_POST['details']) ? "" : $_POST['details'];
  7. $videoname=empty($_POST['videoname']) ? "" : $_POST['videoname'];
  8. //$sql="insert into pre_home_video(uid,display_type,filename,default) values('$uid','$display_type','$filename','$default')";
  9. //$query = DB::query($sql);
  10. if(!empty($_POST['uid']) && !empty($_POST['display_type']) && !empty($_POST['display_type'] ))
  11. {
  12. $count = DB::result(DB::query("select uid from pre_common_member where uid= $uid"), 0);
  13. if($count)
  14. {
  15. $arr=array();
  16. $arr['uid'] = $uid;
  17. $arr['username'] = $username;
  18. $arr['display_type'] = $display_type;
  19. $arr['filename'] = $filename;
  20. $arr['details'] = $details;
  21. $arr['videoname'] = $videoname;
  22. if(!file_exists("data/video/{$uid}")){
  23. mkdir("data/video/{$uid}", 0700);
  24. }
  25. if(!file_exists("data/video/{$uid}/cover")){
  26. mkdir("data/video/{$uid}/cover", 0700);
  27. }
  28. $count1=DB::insert('home_video',$arr);
  29. if($count1)
  30. {
  31. echo("<script type='text/javascript'>alert('添加成功');window.location = "admin.php?action=video";</script>");

  32. }
  33. }
  34. else
  35. {
  36. echo("<script type='text/javascript'>alert('添加失败,该用户不存在');</script>");
  37. }
  38. 更新
  39. $id = $_GET['id'] ? $_GET['id'] : 0;
  40. $query = DB::query("select * from ".DB::table('home_hall')." where id=$id");
  41. if($query){
  42. $data = DB::fetch($query);
  43. if($type == 'gold'){
  44. if($op == 'add'){
  45. $data['isgold'] = 1;
  46. }elseif($op = 'cancle'){
  47. $data['isgold'] = 0;
  48. }
  49. DB::update('home_hall', array('isgold'=>$data['isgold']),array('id'=> $id));
  50. }elseif($type == 'index'){
  51. if($op == 'add'){
  52. $data['isindex'] = 1;
  53. }elseif($op = 'cancle'){
  54. $data['isindex'] = 0;
  55. }
  56. DB::update('home_hall', array('isindex'=>$data['isindex']),array('id'=> $id));
  57. }
  58. }else{
  59. echo '没有此展厅';
  60. }
  61. 3.查询,返回结果集
  62. $perpage = 25;
  63. $start = ($page-1)*$perpage;
  64. $mpurl = ADMINSCRIPT.'?action=goldhall';
  65. $count = DB::result(DB::query("SELECT COUNT(*) FROM ".DB::table('home_hall')), 0);
  66. if($count){
  67. $query = DB::query("SELECT * FROM ".DB::table('home_hall')." limit $start, $perpage");
  68. while ($value = DB::fetch($query)) {
  69. $list[] = $value;
  70. }
  71. $multipage = multi($count, $perpage, $page, $mpurl);
  72. }

  73. echo '<table width="100%" border=1>';
  74. echo '<tr><td>用户id</td><td>展厅名</td><td>展厅级别</td><td>联系电话</td><td>操作</td><td>操作</td></tr>';
  75. foreach ($list as $k => $v){
  76. echo "<tr>";
  77. echo "<td>{$v['uid']}</td>";
  78. echo "<td>{$v['hallname']}</td>";
  79. echo $v['isgold'] ? "<td>金牌</td>" : "<td>普通</td>";
  80. echo "<td>{$v['telephone']}</td>";
  81. if($v['isgold'] == 1){
  82. echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=gold&op=cancle'>取消金牌展厅</a></td>";
  83. }else{
  84. echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=gold&op=add'>升级</a></td>";
  85. }
  86. if($v['isindex'] == 1){
  87. echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=index&op=cancle'>取消首页推荐</a></td>";
  88. }else{
  89. echo "<td><a href='admin.php?action=goldhall&id={$v['id']}&type=index&op=add'>首页推荐</a></td>";
  90. }
  91. echo "</tr>";
  92. }
  93. echo '</table>';
  94. if($multipage){
  95. echo $multipage;
  96. }
  97. //删除
  98. if($_GET['op'] == 'delete'){
  99. if($gid){ //还要删除文件
  100. DB::delete('saige_geku', array('id' => $gid));
  101. DB::delete('saige_gekufield', array('gid' => $gid));
  102. DB::delete('saige_gkcomment', array('gid' => $gid));
  103. }

  104. }
复制代码

游客,如果您要查看本帖隐藏内容请回复



上一篇:SPS Discuz7.2 超强给力修改版 update 2012.02.14
下一篇:看一下这个美化怎么弄(里面有图片)
authicon 季V晴天 发表于 2012-8-10 01:05:15 | 显示全部楼层
来看阿奎那
authicon Mad_World 发表于 2012-10-9 14:08:57 | 显示全部楼层
这个很好
学习了

authicon 小亮仔 发表于 2013-1-26 15:49:29 | 显示全部楼层
楼主加油,我们都看好你哦。
authicon 那厮回忆 发表于 2013-8-21 11:12:57 | 显示全部楼层
太生气了,无法HOLD啦 >_<......
authicon 858067319 发表于 2013-8-22 02:21:08 | 显示全部楼层
discuz 如何添加数据DB::insert和更新数据DB::update 查询DB::query删除DB::delete discuz 如何添加数据DB::insert和更新数据DB::update 查询DB::query删除DB::delete
authicon lai286438690 发表于 2013-8-26 09:59:45 | 显示全部楼层
激动人心,无法言表!
authicon 网络摆渡客 发表于 2013-11-12 21:59:21 | 显示全部楼层
每个都要回复哦
authicon kaiyinglai 发表于 2014-2-12 18:11:32 | 显示全部楼层
看不懂
求说明
authicon 荷叶地汪 发表于 2014-7-1 09:29:26 | 显示全部楼层
学习一下学习一下
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

1314学习网 ( 浙ICP备10214163号 )

GMT+8, 2024-3-29 22:17

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表