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

1. [代码][PHP]代码     跳至 [1] [全屏预览]

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107

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