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($listas $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));

    }

    

}