php与js数据交互.docx

第一种方法2011-10-01 22:06:05|分类：javascript运用|标签：jsonphpjs|字号订阅本练习涉及数据库，可以在网上下载mysql的地址数据表php部份：header(content-type:text/html;charset=utf-8);try $db = new mysqli(localhost,abc,123,space); if($db-connect_errno) throw new Exception(数据库链接出错); catch(Exception $dbcon) echo 错误：; exit;$query = SELECT id,name,fId FROM location;try $db-query(set names utf8); $result = $db-query($query); if(!$result) throw new Exception(读取数据库出错); catch(Exception $dbres) echo 错误：; exit;$address = array();while($row = $result-fetch_assoc() if($rowfId = null) $arr = $rowname; $arr = 海外;/因下载的数据表中没有海外这一行，发觉外将就在php中添加进去吧。 if($rowfId =1) $address$rowname = $rowid; if($rowfId = end($address) & !empty($address)/应该可以不用empty判断null的转化，而是在end()用全等= $arrkey($address) = $rowname; $result-close();$db-close();unset($address);$json_add = json_encode($arr);echo var json_text = .$json_add.;/窃以为在这里将json赋值给变量好过在js用eval()?html + js部份：json-php测试 - - /json数据通过读取php文件传进来 var getcountry = document.getElementById(country); var getprovince = document.getElementById(province); var getcity = document.getElementById(city); var i = j = 0; for(key in json_text) j+; if(!isNaN(parseInt(key)/因为“中国”、“海外”这两行数据是数字索引，通过判断键是否为数字而把它们分辨出来，注意 i+;/经过php函数json_encode()转化的json形式键与值都是字符串形式的，isNaN()返回真时为非数字。 getcountry.length = i; getprovince.length = j - i + 1; function country_province_show() var z = 0; var k = 1; for(key in json_text) if(!isNaN(parseInt(key) getcountry.optionsz = new Option(json_textkey,c+z);/new Option(text,value) z+; else getprovince.optionsk = new Option(key,p+k); k+; function city_show() var theprovince = getprovincegetprovince.selectedIndex.text; for(key in json_text) if(key = theprovince) getcity.length = json_textkey.length; for(x=0; xgetcity.length; x+) getcity.optionsx = new Option(json_textkeyx,city+x); if(getprovince.options0.selected=true)/这段用于当选“省”第一行（显示为“-”）时禁止市可选 getcity.options.length = 0; getcity.disabled = true; else getcity.disabled = false; function country_show() var thecountry = getcountrygetcountry.selectedIndex.index; if(thecountry !=0) getprovince.options.length = 0;/将options数组清空 getprovince.disabled = true; getcity.options.length = 0; getcity.disabled = true; else country_province_show(); getprovince.disabled = false; getcity.disabled = false; getcountry.onchange = country_show; getprovince.onchange = city_show;第二种方法 $(.login).live(click,function() var username=$(.input_user).val(); var password=$(.input_ps).val(); if(username=) alert(用户名不能为空); return false; if(password=) alert(密码不能为空); return false; var URL=checkLogin.php?; var DATA=&username=+username+&password=+password; $.getJSON(URL+DATA,function(json) if(json.username=true_u&json.password=true_p) /alert(json.username+|+username+.