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 codeThe code is as follows:

{$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 Regionn ";

$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/Districtn";
$text.="County-level city/countyn";
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:< ?php 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.htmlTechArticleAbsolutely 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...

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：Starting a PHP session using MySQL_PHP TutorialNext article：Starting a PHP session using MySQL_PHP Tutorial

Related articles

See more

• How to use cURL to implement Get and Post requests in PHP
• How to use cURL to implement Get and Post requests in PHP
• How to use cURL to implement Get and Post requests in PHP
• How to use cURL to implement Get and Post requests in PHP
• All expression symbols in regular expressions (summary)

• Home

• Course

• Q&A

• My

• Home
• Course
• Article
• Q&A
• Dictionary
• Manual
• Download
• Topic

Home

Article

Q&A

Course

Topic

Download

Game

Dictionary

简体中文（ZH-CN）English（EN）繁体中文（ZH-TW）日本語（JA）한국어（KO）Melayu（MS）Français（FR）Deutsch（DE）