Lagging behind the first php+mysql province, city, prefecture level 3 linkage non-refresh menu source code using ajax technology_PHP tutorial

Absolutely original Test address: http://www.mlmm.cn/mypage/?name=ceshi

Test page code:

Copy code The code is as follows: php+ajax dynamically generates a drop-down menu {$regionss(People's Republic of China)} regionss Function code: QUOTE: Copy code The code is as follows: //Province and city 3-level linkage drop-down menu function regionss province.city.region function regionss($country="People's Republic of China") { global $db; $i = 1; $text=" Province/City/Autonomous Region n ";

$result = $db->query("SELECT province FROM ".TABLE_PROVINCE." WHERE country='$country' ORDER BY provinceid"); while($r = $db ->fetch_array($result)) "; $i++; } } $text.=" "; id="select2" name= "select2" onchange="startRequesta()" style="width:90px;"> City/County/District n"; $text.=" County-level city/county n"; return $text;

} regions.js code:

Copy code The code is as follows: //var ab = new Array(); var xmlHttp; var xmlHttpa; function createXMLHttpRequest() { if (window.ActiveXObject) { xmlHttp = new ActiveXObject("Microsoft.XMLHTTP"); } else if (window.XMLHttpRequest) { xmlHttp = new XMLHttpRequest(); } } function createXMLHttpRequesta() { if (window.ActiveXObject) { xmlHttpa = new ActiveXObject("Microsoft.XMLHTTP"); } else if (window.XMLHttpRequest) { xmlHttpa = new XMLHttpRequest(); } }

function startRequest() { createXMLHttpRequest(); createXMLHttpRequesta(); xmlHttp.onreadystatechange = handleStateChange; xmlHttpa.onreadystatechange = handleStateChangearea; document.getElementById('select2').options.length = 0; document.getElementById('select3').options.length = 0; var url = document.form1.select1.value; var qurl = "/regions.php?province="+url+"&time="+new Date().getTime(); xmlHttp.open("GET", qurl, true); xmlHttp.send(null); //setTimeout("startRequest()",2000); }

function handleStateChange() { if(xmlHttp.readyState == 4) { if(xmlHttp.status == 200) { var obj = document.getElementById('select2'); //将服务器返回的字符串写到页面中ID为select2的区域 obja = document.getElementById('select3'); //将服务器返回的字符串写到页面中ID为select3的区域 eval(xmlHttp.responseText);

} } } function handleStateChangearea() { eval(xmlHttpa.responseText); } //var ab = new Array();

function startRequesta() { createXMLHttpRequesta(); xmlHttpa.onreadystatechange = handleStateChangea; document.getElementById('select3').options.length = 0; var url = document.form1.select2.value; var qurl = "/regions.php?city="+url+"&time="+new Date().getTime(); xmlHttpa.open("GET", qurl, true); xmlHttpa.send(null); //setTimeout("startRequest()",2000); }

function handleStateChangea() { if(xmlHttpa.readyState == 4) { if(xmlHttpa.status == 200) { var obja = document.getElementBy Id('select3' ); eval(xmlHttpa.responseText); //Write the string returned by the server to the area with the ID select3 on the page

} 🎜> Data Island regions.php page code

Copy code The code is as follows: require "common.php"; $city = $city ? $city : ""; $area = $area ? $area : ""; if($province && $city==''){ global $db; $i = 1;

$result = $db->query("SELECT DISTINCT city FROM ".TABLE_CITY." WHERE province=' $province' ORDER BY cityid"); while($r = $db->fetch_array($result)) { $r[city]=iconv('gb2312','UTF- 8',$r[city]); echo "obj.options[obj.options.length] = new Option('".$r[city]."','".$r[city]. "');n"; $i++; } $resultarea = $db->query("SELECT DISTINCT city FROM ".TABLE_CITY." WHERE province='$province' ORDER BY cityid "); $r = $db->fetch_array($resultarea); $city = $r[city]; $resulta = $db->query("SELECT DISTINCT area FROM ".TABLE_CITY." WHERE city='$city' ORDER BY cityid"); while($ra = $db->fetch_array($resulta)) { $ra[area]= iconv('gb2312','UTF-8',$ra[area]); echo "obja.options[obja.options.length] = new Option('".$ra[area]."', '".$ra[area]."');n"; $i++; }

} if($city && $province=='' ){ global $db; $i = 1;

$result = $db->query("SELECT DISTINCT area FROM ".TABLE_CITY." WHERE city='$city' ORDER BY cityid "); while($r = $db->fetch_array($result)) { $r[area]=iconv('gb2312','UTF-8',$r[ area]); echo "obja.options[obja.options.length] = new Option('".$r[area]."','".$r[area]."');n" ; $i++; } } ?> No changes have been made

This program can be used directly in phpcms3.0. If used elsewhere, please modify it yourself

http://www.bkjia.com/PHPjc/317597.html

www.bkjia.com true

http: //www.bkjia.com/PHPjc/317597.html TechArticle Absolutely original test address: http://www.mlmm.cn/mypage/?name=ceshi test page code : Copy the code as follows: html head metahttp-equiv="Content-Type"content="text/html;charset=gb2...

Php8, I'm coming too

Learn website layout in 30 minutes

Shangguan Oracle Beginner to Proficient Video Tutorial

Your first line of UNI-APP code

Flutter from scratch to app launch

Brother Lian New Linux Video Tutorial

AXURE 9 Video Tutorial (Suitable for Product Manager Interactive Product Design UI)

Zero Basic Proficiency PS Video Tutorial

16 day UI video tutorial to get you started

PS Techniques and Slicing Techniques Video Tutorial

Alibaba Cloud Environment Construction and Project Launch Video Tutorial

Overview of Computer Networks - Basic Knowledge that Programmers Must Master

Essential Tutorial for Programmers - HTTP Protocol Explanation

Websocket Video Tutorial

Lagging behind the first php+mysql province, city, prefecture level 3 linkage non-refresh menu source code using ajax technology_PHP tutorial