집 > 기사 > 백엔드 개발 > PHP는 데이터베이스 추가, 삭제, 쿼리 및 수정을 구현합니다.

PHP는 데이터베이스 추가, 삭제, 쿼리 및 수정을 구현합니다.

不言원래의: 2018-04-18 14:08:082730검색

이 글에서는 데이터베이스 추가, 삭제, 쿼리, 수정을 구현하기 위한 PHP를 주로 소개합니다. 이제는 모든 사람과 공유합니다. 도움이 필요한 친구들이 참고할 수 있습니다.

이 글에서는 jquery, tp 프레임워크를 사용합니다.

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

<?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

<!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

<!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는 데이터베이스 추가, 삭제, 쿼리 및 수정을 구현합니다.

관련 기사