This time I will show you how to implement ajax's three-level linkage menu bar. What are theprecautionsfor the implementation of ajax's three-level linkage menu bar? The following is a practical case, let's take a look.

The example in this article shares the specific code for ajax three-level linkage display for your reference. The specific content is as follows

1. test.php

   
  
三级联动
 
  

2. sanji.js

// JavaScript Document $(document).ready(function(e) { //找到ID=SANJI的p，造三个下拉扔进去 $("#sanji").html(""); //加载省的数据 LoadSheng(); //加载市的数据 LoadShi(); //加载区的数据 LoadQu(); //给省的下拉加点击事件 $("#sheng").click(function(){ //重新加载市 LoadShi(); //重新加载区 LoadQu(); }) //给市的下拉加点击事件 $("#shi").click(function(){ //重新加载区 LoadQu(); }) }); //加载省份的方法 function LoadSheng() { //省的父级代号 var pcode = "0001"; $.ajax({ async:false, url:"chuli.php", data:{pcode:pcode}, type:"POST", dataType:"TEXT", success: function(data){ var hang = data.trim().split("|"); var str = ""; for(var i=0;i"+lie[1]+""; } $("#sheng").html(str); } }); } //加载市的方法 function LoadShi() { //找市的父级代号 var pcode = $("#sheng").val(); $.ajax({ async:false, url:"chuli.php", data:{pcode:pcode}, type:"POST", dataType:"TEXT", success: function(data){ var hang = data.trim().split("|"); var str = ""; for(var i=0;i"+lie[1]+""; } $("#shi").html(str); } }); } //加载区的方法 function LoadQu() { //找区的父级代号 var pcode = $("#shi").val(); $.ajax({ url:"chuli.php", data:{pcode:pcode}, type:"POST", dataType:"TEXT", success: function(data){ var hang = data.trim().split("|"); var str = ""; for(var i=0;i"+lie[1]+""; } $("#qu").html(str); } }); }

3. chuli.php

StrQuery($sql);

The method in the referenced encapsulation class that returnsstring

host,$this->uid,$this->pwd,$this->dbname); $result = $db->query($sql); if($type) { //如果是查询，显示数据 return $result->fetch_all(); } else { //如果是增删改，返回true或者false return $result; } } //返回字符串的方法 public function strquery($sql,$type=1) { $db = new MySQLi($this->host,$this->uid,$this->pwd,$this->dbname); $result = $db->query($sql); $arr = $result->fetch_all(); $str=""; foreach($arr as $v) { $str = $str.implode("^",$v)."|"; } $str = substr($str,0,strlen($str)-1); return $str; } //返回JSON function JSONQuery($sql,$type=1) { $db = new MySQLi($this->host,$this->uid,$this->pwd,$this->dbname); $r = $db->query($sql); if($type==1) { return json_encode($r->fetch_all(MYSQLI_ASSOC)); } else { return $r; } } }

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 make the browser remember ajax requests and control the browser to move forward and backward

AJAX in Detect the entered user name without refreshing

The above is the detailed content of How to implement the three-level linkage menu bar of ajax. For more information, please follow other related articles on the PHP Chinese website!