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

2018-09-07 13:26

阅读：281

　　本文用到：jquery、tp框架

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

　　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=删除成功); 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>

　　执行在浏览器里面输入：

　　点击删除