首頁 > 後端開發 > php教程 > PHP實作資料庫的增刪查改

PHP實作資料庫的增刪查改

不言
發布: 2023-03-24 10:30:01
原創
2790 人瀏覽過

這篇文章主要介紹了PHP實作資料庫的增刪查改,有著一定的參考價值,現在分享給大家,有需要的朋友可以參考一下


本文用到:jquery、tp框架

TP_3.2.2/Application/Home/Controller/StuController.class.php
##

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

<?php

/**

 * Created by PhpStorm.

 * User: root

 * Date: 2018/4/17

 * Time: 16:32

 */

 

namespace Home\Controller;

 

 

use Think\Controller;

 

class StuController extends Controller

{

 

  public  function StuShow(){

        $this->display("school/stu");

    }

 

   public function getdata(){

      $Studata = M(&#39;stu&#39;);

      $data[&#39;id&#39;]=&#39;&#39;;

      $data[&#39;name&#39;]=I(&#39;get.name&#39;);

      $data[&#39;age&#39;]=I(&#39;get.age&#39;);

      $data[&#39;num&#39;]=I(&#39;get.num&#39;);

      $data[&#39;address&#39;]=I(&#39;get.add&#39;);

      $Studata->add($data);

      $this->success("正在。。。",U(&#39;Stu/showdata&#39;));

    }

    public function showdata()

    {

        $Studata = M(&#39;stu&#39;);

        $data=$Studata->select();

        $this->assign(&#39;info&#39;,$data);

        $this->display(&#39;school/showdata&#39;);

    }

    public function del(){

        $id = I(&#39;get.id&#39;);

        $Studata = M(&#39;stu&#39;);

        $bool = $Studata->where([&#39;id&#39;=>$id])->delete();

        if($bool){

            echo 1;

        }else{

            echo 0;

        }

    }

    public function updata()

    {

        $id = I(&#39;get.id&#39;);

        $Studata = M(&#39;stu&#39;);

        $data = $Studata->where([&#39;id&#39;=>$id])->find();

        $this->assign(&#39;data&#39;,$data);//传递数据到前端页面

        $this->display("school/upshowdata");

    }

 

    public function updatadeal()

    {

        $Studata = M(&#39;stu&#39;);

        $id = I(&#39;get.id&#39;);

        $data[&#39;name&#39;]=I(&#39;get.name&#39;);

        $data[&#39;age&#39;]=I(&#39;get.age&#39;);

        $data[&#39;num&#39;]=I(&#39;get.num&#39;);

        $data[&#39;address&#39;]=I(&#39;get.add&#39;);

        $bool = $Studata->where([&#39;id&#39;=>$id])->save($data);

        if($bool){

            $this->showdata();

        }else{

            echo 0;

        }

    }

}

登入後複製



#TP_3.2.2/Application/Home/View/school/showdata.html


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>数据展示界面</title>
</head>
<body id="content">
<center>
    <h2>学生信息展示</h2>
<table border="1">
    <th>编号</th>
    <th>姓名</th>
    <th>年龄</th>
    <th>学号</th>
    <th>籍贯</th>
    <th>操作</th>
    <th>操作</th>
<foreach name="info" item="vo" >
    <tr>
        <td>{$vo[&#39;id&#39;]}</td>
        <td>{$vo[&#39;name&#39;]}</td>
        <td>{$vo[&#39;age&#39;]}</td>
        <td>{$vo[&#39;num&#39;]}</td>
        <td>{$vo[&#39;address&#39;]}</td>
        <td><a href="javascript:void(0)" class="del" where="{$vo[&#39;id&#39;]}">删除</a></td>
            <td><a href="javascript:void(0)" class="up" where="{$vo[&#39;id&#39;]}">修改</a></td>
    </tr>

</foreach>
</table>
</center>
</body>
</html>

<script src="http://libs.baidu.com/jquery/2.1.4/jquery.min.js"></script>
<script>
    $(&#39;.del&#39;).click(function () {
        var where = $(this).attr(&#39;where&#39;);
        $.ajax({
            type: "get",
            url: "{:U(&#39;Stu/del&#39;)}?id="+where,
            success: function(msg){
                if(msg==1){
                    alert(&#39;删除成功&#39;);
                    location.href(&#39;showdata&#39;);
                }else {
                    alert(&#39;删除失败&#39;);
                }
            }
        });
    })

    $(&#39;.up&#39;).click(function () {
        var where = $(this).attr(&#39;where&#39;);
        location.href(&#39;updata?id=&#39;+where);
        // $.ajax({
        //     type: "get",
        //     url: "{:U(&#39;Stu/updata&#39;)}?id="+where,
        //     success: function(msg){
        //         $(&#39;#content&#39;).html(msg);
        //     }
        // });
    })
</script>
登入後複製

TP_3.2.2/Application/Home/View/school/stu.html
#

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

<!doctype html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <meta name="viewport"

          content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">

    <meta http-equiv="X-UA-Compatible" content="ie=edge">

    <title> 学号注册查询系统 </title>

</head>

<body>

<form action="{:U(&#39;Stu/getdata&#39;)}" method="get">

    <br>

    名字: <input type="text" name="name">

    <br>

    年龄: <input type="text" name="age">

    <br>

    学号:<input type="text" name="num">

    <br>

    籍贯:<input type="text" name="add">

    <br>

    <input type="submit" value="提交">

    <br>

</form>

 

</body>

</html>

登入後複製




#TP_3.2.2/Application/Home/View/school/stu.html

#

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

<!doctype html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <meta name="viewport"

          content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">

    <meta http-equiv="X-UA-Compatible" content="ie=edge">

    <title> 学号注册查询系统 </title>

</head>

<body>

<form action="{:U(&#39;Stu/updatadeal&#39;)}" method="get">

    <input type="hidden" value="{$data[&#39;id&#39;]}" name="id">

    <br>

    名字: <input type="text" name="name" value="{$data[&#39;name&#39;]}">

    <br>

    年龄: <input type="text" name="age" value="{$data[&#39;age&#39;]}">

    <br>

    学号:<input type="text" name="num" value="{$data[&#39;num&#39;]}">

    <br>

    籍贯:<input type="text" name="add" value="{$data[&#39;address&#39;]}">

    <br>

    <input type="submit" value="提交">

    <br>

</form>

 

</body>

</html>

登入後複製

執行在瀏覽器內輸入:http ://127.0.0.1:90/TP_3.2.2/index.php/Home/Stu/stushow


#注意:連接埠一般是80,由於我修改過設定檔所以是90





點選刪除

修改:########################### ###相關推薦:#########PHP實作資料擷取的方法######

以上是PHP實作資料庫的增刪查改的詳細內容。更多資訊請關注PHP中文網其他相關文章!

相關標籤:
來源:php.cn
本網站聲明
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn
作者最新文章
熱門教學
更多>
最新下載
更多>
網站特效
網站源碼
網站素材
前端模板