Detailed explanation of ajax data processing steps (with code)

This time I will bring you a detailed explanation of the ajax data processing steps (with code), what are the precautions for ajax data processing, the following is a practical case, let's take a look.

It should be noted that the encapsulated database called and the jQuery storage address

1. Registration

(1) Write a text box to verify the user name

<input type="text" id="uid" />
<span id="tishi"></span> //这个使用来显示提示信息的

(2) Use jQuery Write the statement: The username cannot be used if it exists. The username can be

$("#uid").blur(function(){
　　//取用户名
　　var uid = $(this).val();
　　//查数据库，调ajax
　　$.ajax({  //ajax方法中必须是json格式
  url: "zhucecl.php",  //处理页面的地址
  data:{u:uid},  //这里是Json的格式:u是起的个名字，uid才是值
  type:"POST", //数据提交方式
  dataType:"TEXT",  //返回的数据格式:字符串格式
  success:function(data){  //成功的话返回匿名函数（回调函数）
      //执行处理页面成功后的语句
      var str = "";
                 
      if(data=="OK")
      {
      　　str = "用户名可以使用";
      　　$("#tishi").css("color","green");
      }
      else
      {
      　　str = "已有用户名";  
      　　$("#tishi").css("color","red");
      }
      $("#tishi").text(str);
    　　}
　　　　　　});     
})

(3) Registration processing page: I have written this many times, no more sentences. Sentence explanation

<?php
//调封装好的类：注意保存位置
include("DBDA.class.php");
$db = new DBDA();
 
//传的值起的名字
$uid = $_POST["u"];
$sql = "select count(*) from renyuan where username=&#39;{$uid}&#39;";
 
//调用封装的函数
$attr =$db->Query($sql);
 
//判断用户名是否存在
if($attr[0][0]>0)
{
　　echo "NO"; //有重复的用户名
}
else
{
　　echo "OK";  //没有重复的用户名
}
 
?>

## 2. Login

(1) Write the text box and login button

<p>账号：<input type="text" id="uid" /></p>
<p>密码：<input type="password" id="pwd" /></p>
<input type="button" value="登录" id="btn" />

##(2) Write the jQuery statement　

$("#btn").click(function(){
　　var uid=$("#uid").val(); //找到用户
　　var pwd=$("#pwd").val(); //找到密码
 
　　//调ajax方法，里面要用json格式
　　$.ajax({
  url:"denglucl.php", //登陆的处理页面
  data:{uid:uid,pwd:pwd}, 
  type:"POST",
  dataType:"text",
  success: function(data)
  {
    if(data.trim()=="OK")
    {
      window.location.href="zhuce.php" rel="external nofollow" ; //用户名密码正确，进入一个页面
    }
    else
    {
      alert("用户名密码输入错误");
    }
  }
　　})
       
})

(3) Login processing page: I have written it many times, so I won’t explain it sentence by sentence

<?php
include("DBDA.class.php");
$db = new DBDA();
 
$uid = $_POST["uid"];
$pwd = $_POST["pwd"];
 
$sql = "select mima from huiyuan where yonghu=&#39;{$uid}&#39;";
$attr = $db->Query($sql);
 
if(!empty($pwd) && !empty($attr) && $attr[0][0]==$pwd) //密码不为空，数组不为空，输入密码和查出的密码是否相同
{
　　echo "OK";  
}
else
{
　　echo "ON";  
}

　

Successful login:

3. Ajax data processing

(1) First display the name line, then edit it normally. The content you want to display

<table width="100%" border="1" cellpadding="0" cellspacing="0">
　　<tr>
    <td>代号</td>
    <td>名称</td>
    <td>价格</td>
    <td>产地</td>
    <td>库存</td>
    <td>操作</td>
　　</tr>
</table>

(2) Write a table to display the content

<tbody id="bg">
　　//里面放遍历的某个表中的数据内容
</tbody>

(3) Write jQuery and execute it after the page is loaded

$(document).ready(function(e) {
　　$.ajax({
  url:"xianshicl.php",  
  dataType:"TEXT",
  success: function(data){
    //处理页面处理完成后执行的
    　　 });

(4) Write display data processing page (two methods)

include("DBDA.class.php"); //调用封装好的类：注意存在位置
$db = new DBDA(); //造新对象
   
$sql = "select * from fruit"; //写sql语句
   
echo $db->StrQuery($sql);  //1.调用封装好的拼接数组为字符串的方法
/* //2.
$attr = $db->Query($sql); //调用封装类中的方法来执行sql语句
$str = "";
foreach($attr as $v)
{
　　$str .= implode("^",$v)."|"; //拼接数组为字符串
}
       
echo substr($str,0,strlen($str)-1); //截取字符串：最后的拼接符不显示<br>*/

(5) After processing the page , write the statement after the end of the processing page in the ajax success method of the main page

success: function(data){
　　var hang = data.split("|"); //拆分字符“|”串：显示行
           
　　var str = "";
　　for(var i=0;i<hang.length;i++)
　　{
  var lie = hang[i].split("^"); //拆分字符串“^”:显示列
  str += "<tr><td>"+lie[0]+"</td><td>"+lie[1]+"</td><td>"+lie[2]+"</td><td>"+lie[3]+"</td><td>"+lie[5]+"</td><td>操作</td></tr>";  //显示的行和单元格
　　}
           
　　$("#bg").html(str);
}

This will display:

I believe you have mastered the method after reading the case in this article. For more exciting information, please pay attention to other related articles on the php Chinese website!

Recommended reading:

How to use Django Ajax

How to let the browser remember the ajax request and control the browser to move forward and back

The above is the detailed content of Detailed explanation of ajax data processing steps (with code). For more information, please follow other related articles on the PHP Chinese website!