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(\'stu\'); 
  $data[\'id\']=\'\'; 
  $data[\'name\']=I(\'get.name\'); 
  $data[\'age\']=I(\'get.age\'); 
  $data[\'num\']=I(\'get.num\'); 
  $data[\'address\']=I(\'get.add\'); 
  $Studata->add($data); 
  $this->success(\"正在。。。\",U(\'Stu/showdata\')); 
 } 
 public function showdata() 
 { 
  $Studata = M(\'stu\'); 
  $data=$Studata->select(); 
  $this->assign(\'info\',$data); 
  $this->display(\'school/showdata\'); 
 } 
 public function del(){ 
  $id = I(\'get.id\'); 
  $Studata = M(\'stu\'); 
  $bool = $Studata->where([\'id\'=>$id])->delete(); 
  if($bool){ 
   echo 1; 
  }else{ 
   echo 0; 
  } 
 } 
 public function updata() 
 { 
  $id = I(\'get.id\'); 
  $Studata = M(\'stu\'); 
  $data = $Studata->where([\'id\'=>$id])->find(); 
  $this->assign(\'data\',$data); 
  $this->display(\"school/upshowdata\"); 
 } 
 public function updatadeal() 
 { 
  $Studata = M(\'stu\'); 
  $id = I(\'get.id\'); 
  $data[\'name\']=I(\'get.name\'); 
  $data[\'age\']=I(\'get.age\'); 
  $data[\'num\']=I(\'get.num\'); 
  $data[\'address\']=I(\'get.add\'); 
  $bool = $Studata->where([\'id\'=>$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[\'id\']}</td> 
  <td>{$vo[\'name\']}</td> 
  <td>{$vo[\'age\']}</td> 
  <td>{$vo[\'num\']}</td> 
  <td>{$vo[\'address\']}</td> 
  <td><a href=\"javascript:void(0)\" rel=\"external nofollow\" rel=\"external nofollow\" class=\"del\" where=\"{$vo[\'id\']}\">删除</a></td> 
   <td><a href=\"javascript:void(0)\" rel=\"external nofollow\" rel=\"external nofollow\" class=\"up\" where=\"{$vo[\'id\']}\">修改</a></td> 
 </tr> 
</foreach> 
</table> 
</center> 
</body> 
</html> 
<script src=\"http://libs.baidu.com/jquery/2.1.4/jquery.min.js\"></script> 
<script> 
 $(\'.del\').click(function () { 
  var where = $(this).attr(\'where\'); 
  $.ajax({ 
   type: \"get\", 
   url: \"{:U(\'Stu/del\')}?id=\"+where, 
   success: function(msg){ 
    if(msg==1){ 
     alert(\'删除成功\'); 
     location.href(\'showdata\'); 
    }else { 
     alert(\'删除失败\'); 
    } 
   } 
  }); 
 }) 
 $(\'.up\').click(function () { 
  var where = $(this).attr(\'where\'); 
  location.href(\'updata?id=\'+where); 
  // $.ajax({ 
  //  type: \"get\", 
  //  url: \"{:U(\'Stu/updata\')}?id=\"+where, 
  //  success: function(msg){ 
  //   $(\'#content\').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(\'Stu/getdata\')}\" 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(\'Stu/updatadeal\')}\" method=\"get\"> 
 <input type=\"hidden\" value=\"{$data[\'id\']}\" name=\"id\"> 
 <br> 
 名字: <input type=\"text\" name=\"name\" value=\"{$data[\'name\']}\"> 
 <br> 
 年龄: <input type=\"text\" name=\"age\" value=\"{$data[\'age\']}\"> 
 <br> 
 学号:<input type=\"text\" name=\"num\" value=\"{$data[\'num\']}\"> 
 <br> 
 籍贯:<input type=\"text\" name=\"add\" value=\"{$data[\'address\']}\"> 
 <br> 
 <input type=\"submit\" value=\"提交\"> 
 <br> 
</form> 
</body> 
</html>

执行在浏览器里面输入：http://127.0.0.1:90/TP_3.2.2/index.php/Home/Stu/stushow

点击删除

修改：

总结

以上所述是小编给大家介绍的PHP实现数据库的增删查改功能及完整代码，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对免费资源网网站的支持！

版权声明 1 本网站名称：偶像资源网
2 本站永久网址：https://www.ox520.com
3 本网站的文章部分内容可能来源于网络，仅供大家学习与参考，如有侵权，请联系站长 QQ593098775进行删除处理。
4 本站一切资源不代表本站立场，并不代表本站赞同其观点和对其真实性负责。
5 本站一律禁止以任何方式发布或转载任何违法的相关信息，访客发现请向站长举报
6 本站资源大多存储在云盘，如发现链接失效，请联系我们我们会第一时间更新。

THE END

PHP实现数据库的增删查改功能及完整代码

请登录后发表评论