ajax交互案例_含真_前端开发者

数据交互是前端很重要的一部分,静态页是基础,而交互才是网页的精髓。交互又分为人机交互和前后端数据交互,现阶段的互联网下,大部分的网站都要进行前后端数据交互,如何交互呢?交互的流程大概就是前端发送数据给后端,后端接送数据,进行处理,将处理后的结果发送给前端,前端接受数据。前端和后端的收和发通过什么呢?

前端通过表单和ajax发送数据,接受只能通过ajax;后端(php)通过$_GET[]、$_POST[]、$_REQUEST[]接收,打印语句来发送:echo、print、print_r()、die()

ajax是前后端交互的重要手段,ajax的全称是asynchronous JavaScript and XML(异步JavaScript和XML);

这么说可能也感受不出什么,案例来感受下吧!

首先我们要准备下页面布局,布局用到了bootstrap的模态框,可以自己百度看下哈!

 1 <!DOCTYPE html>
 2 <html lang="en">
 3 
 4 <head>
 5     <meta charset="UTF-8">
 6     <meta name="viewport" content="width=device-width, initial-scale=1.0">
 7     <meta http-equiv="X-UA-Compatible" content="ie=edge">
 8     <link rel="stylesheet" href="libs/bootstrap.css">
 9     <title>Document</title>
10 </head>
11 
12 <body>
13     <div class="container">
14         <div class="row align-items-center">
15             <div class="col-2 h1">LOGO</div>
16             <div class="col-2 h4">学生信息系统</div>
17             <button type="button" class="btn btn-primary col-1" data-toggle="modal" data-target="#exampleModal"
18                 data-whatever="@mdo" id="insert">添加信息</button>
19         </div>
20         <div class="row my-5">
21             <table class="table table-bordered thead-default table-sm">
22                 <thead>
23                     <tr>
24                         <th>ID</th>
25                         <th>name</th>
26                         <th>machine</th>
27                         <th>examination</th>
28                         <th>delete</th>
29                         <th>update</th>
30                     </tr>
31                 </thead>
32                 <tbody>
33                     <!-- <tr>
34                         <td>1</td>
35                         <td>admin</td>
36                         <td>23</td>
37                         <td>87</td>
38                         <td><span class="btn btn-primary btn-info" ly="delete">删除</span></td>
39                         <td><button type="button" class="btn btn-primary btn-info" data-toggle="modal"
40                             data-target="#exampleModal" data-whatever="@fat" ly="update">修改</button></td>
41                     </tr> -->
42                 </tbody>
43             </table>
44         </div>
45         <div class="row">
46             <nav aria-label="Page navigation example" class="w-100">
47                 <ul class="pagination pagination-sm justify-content-center">
48                     <li class="page-item disabled"><a class="page-link" href="#">上一页</a></li>
49                     <li class="page-item"><a class="page-link" href="#">1</a></li>
50                     <li class="page-item"><a class="page-link" href="#">2</a></li>
51                     <li class="page-item"><a class="page-link" href="#">3</a></li>
52                     <li class="page-item"><a class="page-link" href="#">下一页</a></li>
53                 </ul>
54             </nav>
55         </div>
56     </div>
57     <div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel">
58         <div class="modal-dialog" role="document">
59             <div class="modal-content">
60                 <div class="modal-header">
61                     <h4 class="modal-title" id="exampleModalLabel">请输入信息:</h4>
62                     <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span
63                             aria-hidden="true">&times;</span></button>
64                 </div>
65                 <div class="modal-body">
66                     <form>
67                         <div class="form-group">
68                             <label for="recipient-name" class="control-label">姓名:</label>
69                             <input type="text" class="form-control" id="name">
70                         </div>
71                         <div class="form-group">
72                             <label for="message-text" class="control-label">机试:</label>
73                             <input class="form-control" id="cpt" />
74                         </div>
75                         <div class="form-group">
76                             <label for="message-text" class="control-label">笔试:</label>
77                             <input class="form-control" id="pen" />
78                         </div>
79                     </form>
80                 </div>
81                 <div class="modal-footer">
82                     <button type="button" class="btn btn-primary mx-auto" data-dismiss="modal" id="send">提交</button>
83                 </div>
84             </div>
85         </div>
86     </div>
87 </body>
88 <script src="libs/jquery-2.2.4.js"></script>
89 <script src="libs/popper.js"></script>
90 <script src="libs/bootstrap.js"></script>
91 <script src="js/ajax.js"></script>
92 <script src="js/index.js"></script>
93 </html>
 1 <!DOCTYPE html>
 2 <html lang="en">
 3 
 4 <head>
 5     <meta charset="UTF-8">
 6     <meta name="viewport" content="width=device-width, initial-scale=1.0">
 7     <meta http-equiv="X-UA-Compatible" content="ie=edge">
 8     <link rel="stylesheet" href="libs/bootstrap.css">
 9     <title>Document</title>
10 </head>
11 
12 <body>
13     <div class="container">
14         <div class="row align-items-center">
15             <div class="col-2 h1">LOGO</div>
16             <div class="col-2 h4">学生信息系统</div>
17             <button type="button" class="btn btn-primary col-1" data-toggle="modal" data-target="#exampleModal"
18                 data-whatever="@mdo" id="insert">添加信息</button>
19         </div>
20         <div class="row my-5">
21             <table class="table table-bordered thead-default table-sm">
22                 <thead>
23                     <tr>
24                         <th>ID</th>
25                         <th>name</th>
26                         <th>machine</th>
27                         <th>examination</th>
28                         <th>delete</th>
29                         <th>update</th>
30                     </tr>
31                 </thead>
32                 <tbody>
33                     <!-- <tr>
34                         <td>1</td>
35                         <td>admin</td>
36                         <td>23</td>
37                         <td>87</td>
38                         <td><span class="btn btn-primary btn-info" ly="delete">删除</span></td>
39                         <td><button type="button" class="btn btn-primary btn-info" data-toggle="modal"
40                             data-target="#exampleModal" data-whatever="@fat" ly="update">修改</button></td>
41                     </tr> -->
42                 </tbody>
43             </table>
44         </div>
45         <div class="row">
46             <nav aria-label="Page navigation example" class="w-100">
47                 <ul class="pagination pagination-sm justify-content-center">
48                     <li class="page-item disabled"><a class="page-link" href="#">上一页</a></li>
49                     <li class="page-item"><a class="page-link" href="#">1</a></li>
50                     <li class="page-item"><a class="page-link" href="#">2</a></li>
51                     <li class="page-item"><a class="page-link" href="#">3</a></li>
52                     <li class="page-item"><a class="page-link" href="#">下一页</a></li>
53                 </ul>
54             </nav>
55         </div>
56     </div>
57     <div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel">
58         <div class="modal-dialog" role="document">
59             <div class="modal-content">
60                 <div class="modal-header">
61                     <h4 class="modal-title" id="exampleModalLabel">请输入信息:</h4>
62                     <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span
63                             aria-hidden="true">&times;</span></button>
64                 </div>
65                 <div class="modal-body">
66                     <form>
67                         <div class="form-group">
68                             <label for="recipient-name" class="control-label">姓名:</label>
69                             <input type="text" class="form-control" id="name">
70                         </div>
71                         <div class="form-group">
72                             <label for="message-text" class="control-label">机试:</label>
73                             <input class="form-control" id="cpt" />
74                         </div>
75                         <div class="form-group">
76                             <label for="message-text" class="control-label">笔试:</label>
77                             <input class="form-control" id="pen" />
78                         </div>
79                     </form>
80                 </div>
81                 <div class="modal-footer">
82                     <button type="button" class="btn btn-primary mx-auto" data-dismiss="modal" id="send">提交</button>
83                 </div>
84             </div>
85         </div>
86     </div>
87 </body>
88 <script src="libs/jquery-2.2.4.js"></script>
89 <script src="libs/popper.js"></script>
90 <script src="libs/bootstrap.js"></script>
91 <script src="js/ajax.js"></script>
92 <script src="js/index.js"></script>
93 </html>

1<!DOCTYPE html> 2<html lang=”en”> 3 4<head> 5<meta charset=”UTF-8″> 6<meta name=”viewport” content=”width=device-width, initial-scale=1.0″> 7<meta http-equiv=”X-UA-Compatible” content=”ie=edge”> 8<link rel=”stylesheet” href=”libs/bootstrap.css> 9<title></title>10</head>1112<body>13<div class=”container”>14<div class=”row align-items-center”>15<div class=”col-2 h1″></div>16<div class=”col-2 h4″></div>17<button type=”button” class=”btn btn-primary col-1″ data-toggle=”modal” data-target=”#exampleModal”18 data-whatever=”@mdo” id=”insert”></button>19</div>20<div class=”row my-5″>21<table class=”table table-bordered thead-default table-sm”>22<thead>23<tr>24<th></th>25<th></th>26<th></th>27<th></th>28<th></th>29<th></th>30</tr>31</thead>32<tbody>33<!– <tr>
34 <td>1</td>
35 <td>admin</td>
36 <td>23</td>
37 <td>87</td>
38 <td><span class=”btn btn-primary btn-info” ly=”delete”>删除</span></td>
39 <td><button type=”button” class=”btn btn-primary btn-info” data-toggle=”modal”
40 data-target=”#exampleModal” data-whatever=”@fat” ly=”update”>修改</button></td>
41 </tr> –>42</tbody>43</table>44</div>45<div class=”row”>46<nav aria-label=”Page navigation example” class=”w-100″>47<ul class=”pagination pagination-sm justify-content-center”>48<li class=”page-item disabled”><a class=”page-link” href=”#”></a></li>49<li class=”page-item”><a class=”page-link” href=”#”></a></li>50<li class=”page-item”><a class=”page-link” href=”#”></a></li>51<li class=”page-item”><a class=”page-link” href=”#”></a></li>52<li class=”page-item”><a class=”page-link” href=”#”></a></li>53</ul>54</nav>55</div>56</div>57<div class=”modal fade” id=”exampleModal” tabindex=”-1″ role=”dialog” aria-labelledby=”exampleModalLabel”>58<div class=”modal-dialog” role=”document”>59<div class=”modal-content”>60<div class=”modal-header”>61<h4 class=”modal-title” id=”exampleModalLabel”></h4>62<button type=”button” class=”close” data-dismiss=”modal” aria-label=”Close”><span
63aria-hidden=”true”>&times;</span></button>64</div>65<div class=”modal-body”>66<form>67<div class=”form-group”>68<label for=”recipient-name” class=”control-label”></label>69<input type=”text” class=”form-control” id=”name”>70</div>71<div class=”form-group”>72<label for=”message-text” class=”control-label”></label>73<input class=”form-control” id=”cpt”/>74</div>75<div class=”form-group”>76<label for=”message-text” class=”control-label”></label>77<input class=”form-control” id=”pen”/>78</div>79</form>80</div>81<div class=”modal-footer”>82<button type=”button” class=”btn btn-primary mx-auto” data-dismiss=”modal” id=”send”></button>83</div>84</div>85</div>86</div>87</body>88<script src=”libs/jquery-2.2.4.js”></script>89<script src=”libs/popper.js”></script>90<script src=”libs/bootstrap.js”></script>91<script src=”js/ajax.js”></script>92<script src=”js/index.js”></script>93</html>

接下来就是js了,其实交互就是增删改查。先来看下查。

; (function () {
 2     class Project {
 3         constructor() {
 4             // 获取元素
 5             this.tbody=document.querySelector("tbody");
 6             this.addBtn=document.querySelector("#insert");
 7             this.submit=document.querySelector("#send");
 8             this.name = document.getElementById("name");
 9             this.cpt = document.getElementById("cpt");
10             this.pen = document.getElementById("pen");
11             // console.log(this.addBtn);
12             this.selectUrl = "http://localhost/test/project/php/select.php";
16             this.select();
17       }   
18          select() {
19             var that = this;
20             ajax({
21                 url: this.selectUrl,
22                 success: function (res) {
23                     // console.log(res);
24                     that.res = JSON.parse(res);
25                     if (that.res.code) {
26                         alert(that.res.msg);
27                     } else {
28                         // console.log(that.res);
29                         that.display();
30                     }
31                 }
32             });
33         }
34     display() {
35             // console.log(this.res.length);
36             var str = "";
37             for (var i = 0; i < this.res.length; i++) {
38                 str += `<tr>
39                 <td>${this.res[i].Id}</td>
40                 <td>${this.res[i].name}</td>
41                 <td>${this.res[i].machine}</td>
42                 <td>${this.res[i].examination}</td>
43                 <td><span class="btn btn-primary btn-info" ly="delete">删除</span></td>
44                 <td><button type="button" class="btn btn-primary btn-info" data-toggle="modal"
45                     data-target="#exampleModal" data-whatever="@fat" ly="update">修改</button></td>
46             </tr> `
47             }
48             this.tbody.innerHTML=str;
49         }
50     }
51     new Project();
52 })();
; (function () {
 2     class Project {
 3         constructor() {
 4             // 获取元素
 5             this.tbody=document.querySelector("tbody");
 6             this.addBtn=document.querySelector("#insert");
 7             this.submit=document.querySelector("#send");
 8             this.name = document.getElementById("name");
 9             this.cpt = document.getElementById("cpt");
10             this.pen = document.getElementById("pen");
11             // console.log(this.addBtn);
12             this.selectUrl = "http://localhost/test/project/php/select.php";
16             this.select();
17       }   
18          select() {
19             var that = this;
20             ajax({
21                 url: this.selectUrl,
22                 success: function (res) {
23                     // console.log(res);
24                     that.res = JSON.parse(res);
25                     if (that.res.code) {
26                         alert(that.res.msg);
27                     } else {
28                         // console.log(that.res);
29                         that.display();
30                     }
31                 }
32             });
33         }
34     display() {
35             // console.log(this.res.length);
36             var str = "";
37             for (var i = 0; i < this.res.length; i++) {
38                 str += `<tr>
39                 <td>${this.res[i].Id}</td>
40                 <td>${this.res[i].name}</td>
41                 <td>${this.res[i].machine}</td>
42                 <td>${this.res[i].examination}</td>
43                 <td><span class="btn btn-primary btn-info" ly="delete">删除</span></td>
44                 <td><button type="button" class="btn btn-primary btn-info" data-toggle="modal"
45                     data-target="#exampleModal" data-whatever="@fat" ly="update">修改</button></td>
46             </tr> `
47             }
48             this.tbody.innerHTML=str;
49         }
50     }
51     new Project();
52 })();

function () {
class Project {
constructor() {
// 获取元素this);
this);
this);
this);
this);
this);
// console.log(this.addBtn);this;
this.select();
  }
select() {
varthis;
ajax({
this.selectUrl,
function (res) {
// console.log(res); JSON.parse(res);
if (that.res.code) {
alert(that.res.msg);
else {
// console.log(that.res); that.display();
}
}
});
}
display() {
// console.log(this.res.length);var;
forvarthis) {
thisthisthisthis }
thisstr;
}
}
new Project();

上面的是js部分的代码,封装了ajax所以我直接调用了。再看下php的部分吧!

 1 <?php
 2     $link=@new mysqli("localhost:3306","root","root","test");
 3     if($link->connect_error){
 4         $err = array("code"=>1,"msg"=>$link->connect_error);
 5         die(json_encode($err));
 6     }
 7     $select="SELECT * FROM stu";
 8     $res=$link->query($select);
 9     if($res){
10         $str="";
11         while ($arr=$res->fetch_assoc()) {
12            $str=$str.json_encode($arr).",";
13         }
14         die ("[".substr($str,0,-1)."]");
15     }else{
16         $err = array("code"=>2,"msg"=>"失败");
17         die(json_encode($err));
18     }
19 ?>
 1 <?php
 2     $link=@new mysqli("localhost:3306","root","root","test");
 3     if($link->connect_error){
 4         $err = array("code"=>1,"msg"=>$link->connect_error);
 5         die(json_encode($err));
 6     }
 7     $select="SELECT * FROM stu";
 8     $res=$link->query($select);
 9     if($res){
10         $str="";
11         while ($arr=$res->fetch_assoc()) {
12            $str=$str.json_encode($arr).",";
13         }
14         die ("[".substr($str,0,-1)."]");
15     }else{
16         $err = array("code"=>2,"msg"=>"失败");
17         die(json_encode($err));
18     }
19 ?>

1php
2$linknew);
3if$linkconnect_error){
4$errarray$linkconnect_error);
5die$err));
6 }
7$select;
8$res$link$select);
9if$res){
10$str;
11while$arr$resfetch_assoc()) {
12$str$str$arr;
13 }
14diesubstr$str);
15else{
16$errarray);
17die$err));
18 }
19

 刷新页面的时候就会自动获取数据库中的数据渲染到页面上。再是添加和修改数据,因为使用了一个模态框,所以同时写,因为模态框中的提交按钮需判断是添加按钮触发的还是修改按钮触发的,就需要一个标识。同上,代码感受!

  1 ; (function () {
  2     class Project {
  3         constructor() {
  4             // 获取元素
  5             this.tbody=document.querySelector("tbody");
  6             this.addBtn=document.querySelector("#insert");
  7             this.submit=document.querySelector("#send");
  8             this.name = document.getElementById("name");
  9             this.cpt = document.getElementById("cpt");
 10             this.pen = document.getElementById("pen");
 11             // console.log(this.addBtn);
 12             this.selectUrl = "http://localhost/test/project/php/select.php";
 13             this.insertUrl="http://localhost/test/project/php/insert.php";
 14             this.updateUrl="http://localhost/test/project/php/update.php";
 15             
 16 
 17             this.type=0;
 18             this.select();
 19             this.addEvent();
 20         }
 21         select() {
 22             var that = this;
 23             ajax({
 24                 url: this.selectUrl,
 25                 success: function (res) {
 26                     // console.log(res);
 27                     that.res = JSON.parse(res);
 28                     if (that.res.code) {
 29                         alert(that.res.msg);
 30                     } else {
 31                         // console.log(that.res);
 32                         that.display();
 33                     }
 34                 }
 35             });
 36         }
 37         addEvent(){
 38             var that=this;
 39             this.addBtn.addEventListener("click",function(){
 40                 that.type=0;
 41             });
 42             this.tbody.addEventListener("click",function(eve){
 43                 var e = eve || window.event;
 44                 that.target = e.target || e.srcElement;
 45                 if(that.target.getAttribute("y") === "update"){
 46                     that.type = 1;
 47                     that.id=that.target.parentNode.parentNode.children[0].innerHTML;
 48                     that.name.value=that.target.parentNode.parentNode.children[1].innerHTML;
 49                     that.cpt.value=that.target.parentNode.parentNode.children[2].innerHTML;
 50                     that.pen.value=that.target.parentNode.parentNode.children[3].innerHTML;
 51                 }
 52             });
 53             this.submit.addEventListener("click",function(){
 54                 that.n=that.name.value;
 55                 that.c=that.cpt.value;
 56                 that.p=that.pen.value;
 57                 if(that.type==0){
 58                     that.name.value=that.cpt.value=that.pen.value="";
 59                     that.insertLoad();
 60                 }else{
 61                     // console.log();
 62                    that.updateLoad();
 63                 }
 64             })
 65         }
 66         insertLoad(){
 67             var that=this;
 68             ajax({
 69                 url:this.insertUrl,
 70                 data:{
 71                     name:this.n,
 72                     cpt:this.c,
 73                     pen:this.p
 74                 },
 75                 success:function(res){
 76                     // console.log(res);
 77                     that.res=JSON.parse(res);
 78                     if(that.res.code){
 79                         alert(that.res.msg);
 80                     }else{
 81                         that.display();
 82                     }
 83                 }
 84             });
 85         }
 86         updateLoad(){
 87             var that=this;
 88             ajax({
 89                 url:this.updateUrl,
 90                 data:{
 91                     id:this.id,
 92                     name:this.n,
 93                     cpt:this.c,
 94                     pen:this.p
 95                 },
 96                 success:function (res) {
 97                     that.res=JSON.parse(res);
 98                     if(that.res.code){
 99                         alert(that.res.msg);
100                     }else{
101                         that.display();
102                     }
103                 }
104             })
105         }
106         display() {
107             // console.log(this.res.length);
108             var str = "";
109             for (var i = 0; i < this.res.length; i++) {
110                 str += `<tr>
111                 <td>${this.res[i].Id}</td>
112                 <td>${this.res[i].name}</td>
113                 <td>${this.res[i].machine}</td>
114                 <td>${this.res[i].examination}</td>
115                 <td><span class="btn btn-primary btn-info" ly="delete">删除</span></td>
116                 <td><button type="button" class="btn btn-primary btn-info" data-toggle="modal"
117                     data-target="#exampleModal" data-whatever="@fat" ly="update">修改</button></td>
118             </tr> `
119             }
120             this.tbody.innerHTML=str;
121         }
122     }
123     new Project();
124 })();
  1 ; (function () {
  2     class Project {
  3         constructor() {
  4             // 获取元素
  5             this.tbody=document.querySelector("tbody");
  6             this.addBtn=document.querySelector("#insert");
  7             this.submit=document.querySelector("#send");
  8             this.name = document.getElementById("name");
  9             this.cpt = document.getElementById("cpt");
 10             this.pen = document.getElementById("pen");
 11             // console.log(this.addBtn);
 12             this.selectUrl = "http://localhost/test/project/php/select.php";
 13             this.insertUrl="http://localhost/test/project/php/insert.php";
 14             this.updateUrl="http://localhost/test/project/php/update.php";
 15             
 16 
 17             this.type=0;
 18             this.select();
 19             this.addEvent();
 20         }
 21         select() {
 22             var that = this;
 23             ajax({
 24                 url: this.selectUrl,
 25                 success: function (res) {
 26                     // console.log(res);
 27                     that.res = JSON.parse(res);
 28                     if (that.res.code) {
 29                         alert(that.res.msg);
 30                     } else {
 31                         // console.log(that.res);
 32                         that.display();
 33                     }
 34                 }
 35             });
 36         }
 37         addEvent(){
 38             var that=this;
 39             this.addBtn.addEventListener("click",function(){
 40                 that.type=0;
 41             });
 42             this.tbody.addEventListener("click",function(eve){
 43                 var e = eve || window.event;
 44                 that.target = e.target || e.srcElement;
 45                 if(that.target.getAttribute("y") === "update"){
 46                     that.type = 1;
 47                     that.id=that.target.parentNode.parentNode.children[0].innerHTML;
 48                     that.name.value=that.target.parentNode.parentNode.children[1].innerHTML;
 49                     that.cpt.value=that.target.parentNode.parentNode.children[2].innerHTML;
 50                     that.pen.value=that.target.parentNode.parentNode.children[3].innerHTML;
 51                 }
 52             });
 53             this.submit.addEventListener("click",function(){
 54                 that.n=that.name.value;
 55                 that.c=that.cpt.value;
 56                 that.p=that.pen.value;
 57                 if(that.type==0){
 58                     that.name.value=that.cpt.value=that.pen.value="";
 59                     that.insertLoad();
 60                 }else{
 61                     // console.log();
 62                    that.updateLoad();
 63                 }
 64             })
 65         }
 66         insertLoad(){
 67             var that=this;
 68             ajax({
 69                 url:this.insertUrl,
 70                 data:{
 71                     name:this.n,
 72                     cpt:this.c,
 73                     pen:this.p
 74                 },
 75                 success:function(res){
 76                     // console.log(res);
 77                     that.res=JSON.parse(res);
 78                     if(that.res.code){
 79                         alert(that.res.msg);
 80                     }else{
 81                         that.display();
 82                     }
 83                 }
 84             });
 85         }
 86         updateLoad(){
 87             var that=this;
 88             ajax({
 89                 url:this.updateUrl,
 90                 data:{
 91                     id:this.id,
 92                     name:this.n,
 93                     cpt:this.c,
 94                     pen:this.p
 95                 },
 96                 success:function (res) {
 97                     that.res=JSON.parse(res);
 98                     if(that.res.code){
 99                         alert(that.res.msg);
100                     }else{
101                         that.display();
102                     }
103                 }
104             })
105         }
106         display() {
107             // console.log(this.res.length);
108             var str = "";
109             for (var i = 0; i < this.res.length; i++) {
110                 str += `<tr>
111                 <td>${this.res[i].Id}</td>
112                 <td>${this.res[i].name}</td>
113                 <td>${this.res[i].machine}</td>
114                 <td>${this.res[i].examination}</td>
115                 <td><span class="btn btn-primary btn-info" ly="delete">删除</span></td>
116                 <td><button type="button" class="btn btn-primary btn-info" data-toggle="modal"
117                     data-target="#exampleModal" data-whatever="@fat" ly="update">修改</button></td>
118             </tr> `
119             }
120             this.tbody.innerHTML=str;
121         }
122     }
123     new Project();
124 })();

1function () {
2 class Project {
3 constructor() {
4// 获取元素 5this);
6this);
7this);
8this);
9this);
10this);
11// console.log(this.addBtn); 12this;
13this;
14this;
15 16 17this;
18this.select();
19this.addEvent();
20 }
21 select() {
22varthis;
23 ajax({
24this.selectUrl,
25function (res) {
26// console.log(res); 27 JSON.parse(res);
28if (that.res.code) {
29 alert(that.res.msg);
30else {
31// console.log(that.res); 32 that.display();
33 }
34 }
35 });
36 }
37 addEvent(){
38varthis;
39thisfunction(){
40;
41 });
42thisfunction(eve){
43var window.event;
44 e.srcElement;
45if){
46;
47].innerHTML;
48].innerHTML;
49].innerHTML;
50].innerHTML;
51 }
52 });
53thisfunction(){
54that.name.value;
55that.cpt.value;
56that.pen.value;
57if){
58;
59 that.insertLoad();
60else{
61// console.log(); 62 that.updateLoad();
63 }
64 })
65 }
66 insertLoad(){
67varthis;
68 ajax({
69this.insertUrl,
70 data:{
71this.n,
72this.c,
73this.p
74 },
75function(res){
76// console.log(res); 77JSON.parse(res);
78if(that.res.code){
79 alert(that.res.msg);
80else{
81 that.display();
82 }
83 }
84 });
85 }
86 updateLoad(){
87varthis;
88 ajax({
89this.updateUrl,
90 data:{
91this.id,
92this.n,
93this.c,
94this.p
95 },
96function (res) {
97JSON.parse(res);
98if(that.res.code){
99 alert(that.res.msg);
100else{
101 that.display();
102 }
103 }
104 })
105 }
106 display() {
107// console.log(this.res.length);108var;
109forvarthis) {
110111this112this113this114this115116117118119 }
120thisstr;
121 }
122 }
123new Project();
124

下面是添加按钮所对应的的php代码!

 1 <?php
 2     $link=@new mysqli("localhost:3306","root","root","test");
 3     if($link->connect_error){
 4         $err = array("code"=>1,"msg"=>$link->connect_error);
 5         die(json_encode($err));
 6     }
 7     $n=@$_REQUEST["name"];
 8     $c=@$_REQUEST["cpt"];
 9     $p=@$_REQUEST["pen"];
10     $insert="INSERT stu (name,machine,examination) VALUES('".$n."',".$c.",".$p.")";
11     $q=$link->query($insert);
12     if($q){
13        echo select();
14     }else{
15         $err = array("code"=>3,"msg"=>"添加失败");
16         die(json_encode($err));
17     }
18     function select(){
19         global $link;
20         $select="SELECT * FROM stu";
21         $res=$link->query($select);
22         if($res){
23             $str="";
24             while ($arr=$res->fetch_assoc()) {
25                $str=$str.json_encode($arr).",";
26             }
27             die ("[".substr($str,0,-1)."]");
28         }else{
29             $err = array("code"=>2,"msg"=>"失败");
30             die(json_encode($err));
31         }
32     }
33 ?>
 1 <?php
 2     $link=@new mysqli("localhost:3306","root","root","test");
 3     if($link->connect_error){
 4         $err = array("code"=>1,"msg"=>$link->connect_error);
 5         die(json_encode($err));
 6     }
 7     $n=@$_REQUEST["name"];
 8     $c=@$_REQUEST["cpt"];
 9     $p=@$_REQUEST["pen"];
10     $insert="INSERT stu (name,machine,examination) VALUES('".$n."',".$c.",".$p.")";
11     $q=$link->query($insert);
12     if($q){
13        echo select();
14     }else{
15         $err = array("code"=>3,"msg"=>"添加失败");
16         die(json_encode($err));
17     }
18     function select(){
19         global $link;
20         $select="SELECT * FROM stu";
21         $res=$link->query($select);
22         if($res){
23             $str="";
24             while ($arr=$res->fetch_assoc()) {
25                $str=$str.json_encode($arr).",";
26             }
27             die ("[".substr($str,0,-1)."]");
28         }else{
29             $err = array("code"=>2,"msg"=>"失败");
30             die(json_encode($err));
31         }
32     }
33 ?>

1php
2$linknew);
3if$linkconnect_error){
4$errarray$linkconnect_error);
5die$err));
6 }
7$n$_REQUEST];
8$c$_REQUEST];
9$p$_REQUEST];
10$insert$n$c$p;
11$q$link$insert);
12if$q){
13echo select();
14else{
15$errarray);
16die$err));
17 }
18function select(){
19global$link;
20$select;
21$res$link$select);
22if$res){
23$str;
24while$arr$resfetch_assoc()) {
25$str$str$arr;
26 }
27diesubstr$str);
28else{
29$errarray);
30die$err));
31 }
32 }
33

下面是修改按钮所对应的的php代码!

 1 <?php
 2     $link=@new mysqli("localhost:3306","root","root","test");
 3     if($link->connect_error){
 4         $err = array("code"=>1,"msg"=>$link->connect_error);
 5         die(json_encode($err));
 6     }
 7     $id=@$_REQUEST["id"];
 8     $n=@$_REQUEST["name"];
 9     $c=@$_REQUEST["cpt"];
10     $p=@$_REQUEST["pen"];
11     $update="UPDATE stu SET name='".$n."',machine=".$c.",examination=".$p." WHERE Id=".$id;
12     $q=$link->query($update);
13     if($q){
14         echo select();
15     }else{
16         $err = array("code"=>3,"msg"=>"添加失败");
17         die(json_encode($err));
18     }
19     function select(){
20         global $link;
21         $select="SELECT * FROM stu";
22         $res=$link->query($select);
23         if($res){
24             $str="";
25             while ($arr=$res->fetch_assoc()) {
26                $str=$str.json_encode($arr).",";
27             }
28             die ("[".substr($str,0,-1)."]");
29         }else{
30             $err = array("code"=>2,"msg"=>"失败");
31             die(json_encode($err));
32         }
33     }
34 ?>
 1 <?php
 2     $link=@new mysqli("localhost:3306","root","root","test");
 3     if($link->connect_error){
 4         $err = array("code"=>1,"msg"=>$link->connect_error);
 5         die(json_encode($err));
 6     }
 7     $id=@$_REQUEST["id"];
 8     $n=@$_REQUEST["name"];
 9     $c=@$_REQUEST["cpt"];
10     $p=@$_REQUEST["pen"];
11     $update="UPDATE stu SET name='".$n."',machine=".$c.",examination=".$p." WHERE Id=".$id;
12     $q=$link->query($update);
13     if($q){
14         echo select();
15     }else{
16         $err = array("code"=>3,"msg"=>"添加失败");
17         die(json_encode($err));
18     }
19     function select(){
20         global $link;
21         $select="SELECT * FROM stu";
22         $res=$link->query($select);
23         if($res){
24             $str="";
25             while ($arr=$res->fetch_assoc()) {
26                $str=$str.json_encode($arr).",";
27             }
28             die ("[".substr($str,0,-1)."]");
29         }else{
30             $err = array("code"=>2,"msg"=>"失败");
31             die(json_encode($err));
32         }
33     }
34 ?>

1php
2$linknew);
3if$linkconnect_error){
4$errarray$linkconnect_error);
5die$err));
6 }
7$id$_REQUEST];
8$n$_REQUEST];
9$c$_REQUEST];
10$p$_REQUEST];
11$update$n$c$p$id;
12$q$link$update);
13if$q){
14echo select();
15else{
16$errarray);
17die$err));
18 }
19function select(){
20global$link;
21$select;
22$res$link$select);
23if$res){
24$str;
25while$arr$resfetch_assoc()) {
26$str$str$arr;
27 }
28diesubstr$str);
29else{
30$errarray);
31die$err));
32 }
33 }
34

添加,修改操作完成就是删除,删除是比较简单的,只要获取点击删除的所对应的的数据即可!

  1 ; (function () {
  2     class Project {
  3         constructor() {
  4             // 获取元素
  5             this.tbody=document.querySelector("tbody");
  6             this.addBtn=document.querySelector("#insert");
  7             this.submit=document.querySelector("#send");
  8             this.name = document.getElementById("name");
  9             this.cpt = document.getElementById("cpt");
 10             this.pen = document.getElementById("pen");
 11             // console.log(this.addBtn);
 12             this.selectUrl = "http://localhost/test/project/php/select.php";
 13             this.insertUrl="http://localhost/test/project/php/insert.php";
 14             this.updateUrl="http://localhost/test/project/php/update.php";
 15             this.deleteUrl="http://localhost/test/project/php/delect.php";
 16 
 17             this.type=0;
 18             this.select();
 19             this.addEvent();
 20         }
 21         select() {
 22             var that = this;
 23             ajax({
 24                 url: this.selectUrl,
 25                 success: function (res) {
 26                     // console.log(res);
 27                     that.res = JSON.parse(res);
 28                     if (that.res.code) {
 29                         alert(that.res.msg);
 30                     } else {
 31                         // console.log(that.res);
 32                         that.display();
 33                     }
 34                 }
 35             });
 36         }
 37         addEvent(){
 38             var that=this;
 39             this.addBtn.addEventListener("click",function(){
 40                 that.type=0;
 41             });
 42             this.tbody.addEventListener("click",function(eve){
 43                 var e = eve || window.event;
 44                 that.target = e.target || e.srcElement;
 45                 if(that.target.getAttribute("ly") === "update"){
 46                     that.type = 1;
 47                     that.id=that.target.parentNode.parentNode.children[0].innerHTML;
 48                     that.name.value=that.target.parentNode.parentNode.children[1].innerHTML;
 49                     that.cpt.value=that.target.parentNode.parentNode.children[2].innerHTML;
 50                     that.pen.value=that.target.parentNode.parentNode.children[3].innerHTML;
 51                 }else if(that.target.getAttribute("ly") === "delete"){
 52                     that.i=that.target.parentNode.parentNode.children[0].innerHTML;
 53                     that.na=that.target.parentNode.parentNode.children[1].innerHTML;
 54                     that.ma=that.target.parentNode.parentNode.children[2].innerHTML;
 55                     that.ex=that.target.parentNode.parentNode.children[3].innerHTML;
 56                     
 57                     that.deleteLoad();
 58                 }
 59             });
 60             this.submit.addEventListener("click",function(){
 61                 that.n=that.name.value;
 62                 that.c=that.cpt.value;
 63                 that.p=that.pen.value;
 64                 if(that.type==0){
 65                     that.name.value=that.cpt.value=that.pen.value="";
 66                     that.insertLoad();
 67                 }else{
 68                     // console.log();
 69                    that.updateLoad();
 70                 }
 71             })
 72         }
 73  93 113         deleteLoad(){
114             var that=this;
115             ajax({
116                 url:this.deleteUrl,
117                 data:{
118                     id:this.i,
119                     name:this.na,
120                     cpt:this.ma,
121                     pen:this.ex,
122                 },
123                 success:function(res){
124                     that.res=JSON.parse(res);
125                     if(that.res.code){
126                         alert(that.res.msg);
127                     }else{
128                         that.display();
129                     }
130                 }
131             })
132         }
133         display() {
134             // console.log(this.res.length);
135             var str = "";
136             for (var i = 0; i < this.res.length; i++) {
137                 str += `<tr>
138                 <td>${this.res[i].Id}</td>
139                 <td>${this.res[i].name}</td>
140                 <td>${this.res[i].machine}</td>
141                 <td>${this.res[i].examination}</td>
142                 <td><span class="btn btn-primary btn-info" ly="delete">删除</span></td>
143                 <td><button type="button" class="btn btn-primary btn-info" data-toggle="modal"
144                     data-target="#exampleModal" data-whatever="@fat" ly="update">修改</button></td>
145             </tr> `
146             }
147             this.tbody.innerHTML=str;
148         }
149     }
150     new Project();
151 })();
  1 ; (function () {
  2     class Project {
  3         constructor() {
  4             // 获取元素
  5             this.tbody=document.querySelector("tbody");
  6             this.addBtn=document.querySelector("#insert");
  7             this.submit=document.querySelector("#send");
  8             this.name = document.getElementById("name");
  9             this.cpt = document.getElementById("cpt");
 10             this.pen = document.getElementById("pen");
 11             // console.log(this.addBtn);
 12             this.selectUrl = "http://localhost/test/project/php/select.php";
 13             this.insertUrl="http://localhost/test/project/php/insert.php";
 14             this.updateUrl="http://localhost/test/project/php/update.php";
 15             this.deleteUrl="http://localhost/test/project/php/delect.php";
 16 
 17             this.type=0;
 18             this.select();
 19             this.addEvent();
 20         }
 21         select() {
 22             var that = this;
 23             ajax({
 24                 url: this.selectUrl,
 25                 success: function (res) {
 26                     // console.log(res);
 27                     that.res = JSON.parse(res);
 28                     if (that.res.code) {
 29                         alert(that.res.msg);
 30                     } else {
 31                         // console.log(that.res);
 32                         that.display();
 33                     }
 34                 }
 35             });
 36         }
 37         addEvent(){
 38             var that=this;
 39             this.addBtn.addEventListener("click",function(){
 40                 that.type=0;
 41             });
 42             this.tbody.addEventListener("click",function(eve){
 43                 var e = eve || window.event;
 44                 that.target = e.target || e.srcElement;
 45                 if(that.target.getAttribute("ly") === "update"){
 46                     that.type = 1;
 47                     that.id=that.target.parentNode.parentNode.children[0].innerHTML;
 48                     that.name.value=that.target.parentNode.parentNode.children[1].innerHTML;
 49                     that.cpt.value=that.target.parentNode.parentNode.children[2].innerHTML;
 50                     that.pen.value=that.target.parentNode.parentNode.children[3].innerHTML;
 51                 }else if(that.target.getAttribute("ly") === "delete"){
 52                     that.i=that.target.parentNode.parentNode.children[0].innerHTML;
 53                     that.na=that.target.parentNode.parentNode.children[1].innerHTML;
 54                     that.ma=that.target.parentNode.parentNode.children[2].innerHTML;
 55                     that.ex=that.target.parentNode.parentNode.children[3].innerHTML;
 56                     
 57                     that.deleteLoad();
 58                 }
 59             });
 60             this.submit.addEventListener("click",function(){
 61                 that.n=that.name.value;
 62                 that.c=that.cpt.value;
 63                 that.p=that.pen.value;
 64                 if(that.type==0){
 65                     that.name.value=that.cpt.value=that.pen.value="";
 66                     that.insertLoad();
 67                 }else{
 68                     // console.log();
 69                    that.updateLoad();
 70                 }
 71             })
 72         }
 73  93 113         deleteLoad(){
114             var that=this;
115             ajax({
116                 url:this.deleteUrl,
117                 data:{
118                     id:this.i,
119                     name:this.na,
120                     cpt:this.ma,
121                     pen:this.ex,
122                 },
123                 success:function(res){
124                     that.res=JSON.parse(res);
125                     if(that.res.code){
126                         alert(that.res.msg);
127                     }else{
128                         that.display();
129                     }
130                 }
131             })
132         }
133         display() {
134             // console.log(this.res.length);
135             var str = "";
136             for (var i = 0; i < this.res.length; i++) {
137                 str += `<tr>
138                 <td>${this.res[i].Id}</td>
139                 <td>${this.res[i].name}</td>
140                 <td>${this.res[i].machine}</td>
141                 <td>${this.res[i].examination}</td>
142                 <td><span class="btn btn-primary btn-info" ly="delete">删除</span></td>
143                 <td><button type="button" class="btn btn-primary btn-info" data-toggle="modal"
144                     data-target="#exampleModal" data-whatever="@fat" ly="update">修改</button></td>
145             </tr> `
146             }
147             this.tbody.innerHTML=str;
148         }
149     }
150     new Project();
151 })();

1function () {
2 class Project {
3 constructor() {
4// 获取元素 5this);
6this);
7this);
8this);
9this);
10this);
11// console.log(this.addBtn); 12this;
13this;
14this;
15this;
16 17this;
18this.select();
19this.addEvent();
20 }
21 select() {
22varthis;
23 ajax({
24this.selectUrl,
25function (res) {
26// console.log(res); 27 JSON.parse(res);
28if (that.res.code) {
29 alert(that.res.msg);
30else {
31// console.log(that.res); 32 that.display();
33 }
34 }
35 });
36 }
37 addEvent(){
38varthis;
39thisfunction(){
40;
41 });
42thisfunction(eve){
43var window.event;
44 e.srcElement;
45if){
46;
47].innerHTML;
48].innerHTML;
49].innerHTML;
50].innerHTML;
51elseif){
52].innerHTML;
53].innerHTML;
54].innerHTML;
55].innerHTML;
56 57 that.deleteLoad();
58 }
59 });
60thisfunction(){
61that.name.value;
62that.cpt.value;
63that.pen.value;
64if){
65;
66 that.insertLoad();
67else{
68// console.log(); 69 that.updateLoad();
70 }
71 })
72 }
73 93113 deleteLoad(){
114varthis;
115 ajax({
116this.deleteUrl,
117 data:{
118this.i,
119this.na,
120this.ma,
121this.ex,
122 },
123function(res){
124JSON.parse(res);
125if(that.res.code){
126 alert(that.res.msg);
127else{
128 that.display();
129 }
130 }
131 })
132 }
133 display() {
134// console.log(this.res.length);135var;
136forvarthis) {
137138this139this140this141this142143144145146 }
147thisstr;
148 }
149 }
150new Project();
151

删除的php代码!

 1 <?php
 2     $link=@new mysqli("localhost:3306","root","root","test");
 3     if($link->connect_error){
 4         $err = array("code"=>1,"msg"=>$link->connect_error);
 5         die(json_encode($err));
 6     }
 7     $id=@$_REQUEST["id"];
 8     $n=@$_REQUEST["name"];
 9     $c=@$_REQUEST["cpt"];
10     $p=@$_REQUEST["pen"];
11     $delete="DELETE FROM stu WHERE Id=".$id;
12     $q=$link->query($delete);
13     if($q){
14         echo select();
15     }else{
16         $err = array("code"=>3,"msg"=>"添加失败");
17         die(json_encode($err));
18     }
19     function select(){
20         global $link;
21         $select="SELECT * FROM stu";
22         $res=$link->query($select);
23         if($res){
24             $str="";
25             while ($arr=$res->fetch_assoc()) {
26                $str=$str.json_encode($arr).",";
27             }
28             die ("[".substr($str,0,-1)."]");
29         }else{
30             $err = array("code"=>2,"msg"=>"失败");
31             die(json_encode($err));
32         }
33     }
34 ?>
 1 <?php
 2     $link=@new mysqli("localhost:3306","root","root","test");
 3     if($link->connect_error){
 4         $err = array("code"=>1,"msg"=>$link->connect_error);
 5         die(json_encode($err));
 6     }
 7     $id=@$_REQUEST["id"];
 8     $n=@$_REQUEST["name"];
 9     $c=@$_REQUEST["cpt"];
10     $p=@$_REQUEST["pen"];
11     $delete="DELETE FROM stu WHERE Id=".$id;
12     $q=$link->query($delete);
13     if($q){
14         echo select();
15     }else{
16         $err = array("code"=>3,"msg"=>"添加失败");
17         die(json_encode($err));
18     }
19     function select(){
20         global $link;
21         $select="SELECT * FROM stu";
22         $res=$link->query($select);
23         if($res){
24             $str="";
25             while ($arr=$res->fetch_assoc()) {
26                $str=$str.json_encode($arr).",";
27             }
28             die ("[".substr($str,0,-1)."]");
29         }else{
30             $err = array("code"=>2,"msg"=>"失败");
31             die(json_encode($err));
32         }
33     }
34 ?>

1php
2$linknew);
3if$linkconnect_error){
4$errarray$linkconnect_error);
5die$err));
6 }
7$id$_REQUEST];
8$n$_REQUEST];
9$c$_REQUEST];
10$p$_REQUEST];
11$delete$id;
12$q$link$delete);
13if$q){
14echo select();
15else{
16$errarray);
17die$err));
18 }
19function select(){
20global$link;
21$select;
22$res$link$select);
23if$res){
24$str;
25while$arr$resfetch_assoc()) {
26$str$str$arr;
27 }
28diesubstr$str);
29else{
30$errarray);
31die$err));
32 }
33 }
34

以上就是交互案例的所有代码了,可以看看,感受下是怎么一回事吧!其实只要理清之间的关系即可,我们做的只是将数据发送给后端并接受后端返回的数据即可!

» 本文来自:前端开发者 » 《ajax交互案例_含真_前端开发者》
» 本文链接地址:https://www.rokub.com/73181.html
» 您也可以订阅本站:https://www.rokub.com
赞(0)
64K

评论 抢沙发

评论前必须登录!