XMl各地区天气情况的详细信息,并将解析的数据入库
1、关于DOM
创新互联-专业网站定制、快速模板网站建设、高性价比惠阳网站开发、企业建站全套包干低至880元,成熟完善的模板库,直接使用。一站式惠阳网站制作公司更省心,省钱,快速模板网站建设找我们,业务覆盖惠阳地区。费用合理售后完善,十余年实体公司更值得信赖。
文件名:city.php
//实现将各地区的天气情况入库
load($url); //读取最外层的节点 $city=$dom->getElementsByTagName("city"); //print_r($city);die; $len = $city->length; for($i=0;$i<$len;$i++){ $item = $city->item($i); $quName = $item->getAttribute("quName"); //print_r($quName);die; $pyName = $item->getAttribute("pyName"); $cityname = $item->getAttribute("cityname"); $state1 = $item->getAttribute("state1"); $state2 = $item->getAttribute("state2"); $stateDetailed = $item->getAttribute("stateDetailed"); $tem1 = $item->getAttribute("tem1"); $tem2 = $item->getAttribute("tem2"); $windState = $item->getAttribute("windState"); //拼写添加sql语句 $sql = "insert into weather(quName,pyName,cityname,state1,state2,stateDetailed,tem1,tem2,windState)values('".$quName."','".$pyName."','".$cityname."','".$state1."','".$state2."','".$stateDetailed."','".$tem1."','".$tem2."','".$windState."')"; //执行sql语句 set_time_limit(0);//取消脚本执行时间限制 $res = $pdo->exec($sql); //获取省份信息 $dom1=new DOMDocument(); @$dom1->load("http://flash.weather.com.cn/wmaps/xml/".$pyName.".xml"); $citys=$dom1->getElementsByTagName("city"); $leng = $citys->length; for($j=0;$j<$leng;$j++){ $item1 = $citys->item($j); $cityX = $item1->getAttribute("cityX"); $cityY = $item1->getAttribute("cityY"); $cityname = $item1->getAttribute("cityname"); $centername = $item1->getAttribute("centername"); $fontColor = $item1->getAttribute("fontColor"); $pyName = $item1->getAttribute("pyName"); $state1 = $item1->getAttribute("state1"); $state2 = $item1->getAttribute("state2"); $stateDetailed = $item1->getAttribute("stateDetailed"); $tem1 = $item1->getAttribute("tem1"); $tem2 = $item1->getAttribute("tem2"); $temNow = $item1->getAttribute("temNow"); $windState = $item1->getAttribute("windState"); $windDir = $item1->getAttribute("windDir"); $windPower = $item1->getAttribute("windPower"); $humidity = $item1->getAttribute("humidity"); $time = $item1->getAttribute("time"); $url = $item1->getAttribute("url"); //var_dump($humidity);die; $sql1 = "insert into sheng(cityX,cityY,cityname,centername,fontColor,pyName,state1,state2,stateDetailed,tem1,tem2,temNow,windState,windDir,windPower,humidity,time,url)values('".$cityX."','".$cityY."','".$cityname."','".$centername."','".$fontColor."','".$pyName."','".$state1."','".$state2."','".$stateDetailed."','".$tem1."','".$tem2."','".$temNow."','".$windState."','".$windDir."','".$windPower."','".$humidity."','".$time."','".$url."')"; set_time_limit(0);//取消脚本执行时间限制 //$data = $pdo->exec($sql1); //获取市的天气信息 $dom2=new DOMDocument(); @$dom2->load("http://flash.weather.com.cn/wmaps/xml/".$pyName.".xml"); $city1=$dom2->getElementsByTagName("city"); $length = $city1->length; //print_r($length); for($s=0;$s<$length;$s++){ $item2 = $city1->item($s); $cityX = $item2->getAttribute("cityX"); $cityY = $item2->getAttribute("cityY"); $cityname = $item2->getAttribute("cityname"); $centername = $item2->getAttribute("centername"); $fontColor = $item2->getAttribute("fontColor"); $pyName = $item2->getAttribute("pyName"); $state1 = $item2->getAttribute("state1"); $state2 = $item2->getAttribute("state2"); $stateDetailed = $item2->getAttribute("stateDetailed"); $tem1 = $item2->getAttribute("tem1"); $tem2 = $item2->getAttribute("tem2"); $temNow = $item2->getAttribute("temNow"); $windState = $item2->getAttribute("windState"); $windDir = $item2->getAttribute("windDir"); $windPower = $item2->getAttribute("windPower"); $humidity = $item2->getAttribute("humidity"); $time = $item2->getAttribute("time"); $url = $item2->getAttribute("url"); $sql2 = "insert into sheng(cityX,cityY,cityname,centername,fontColor,pyName,state1,state2,stateDetailed,tem1,tem2,temNow,windState,windDir,windPower,humidity,time,url)values('".$cityX."','".$cityY."','".$cityname."','".$centername."','".$fontColor."','".$pyName."','".$state1."','".$state2."','".$stateDetailed."','".$tem1."','".$tem2."','".$temNow."','".$windState."','".$windDir."','".$windPower."','".$humidity."','".$time."','".$url."')"; set_time_limit(0);//取消脚本执行时间限制 $data1 = $pdo->exec($sql2); } } } ?>
2、XML基于事件,循环出各地区天气信息:jiexi.php
$name,"attrs"=>$attrs); array_push($stack,$tag); } function cdata($parser, $cdata) { global $stack,$i; if(trim($cdata)) { $stack[count($stack)-1]['cdata']=$cdata; } } function endTag($parser, $name) { global $stack; $stack[count($stack)-2]['children'][] = $stack[count($stack)-1]; array_pop($stack); } $xml_parser = xml_parser_create(); xml_set_element_handler($xml_parser, "startTag", "endTag"); xml_set_character_data_handler($xml_parser, "cdata"); $data = xml_parse($xml_parser,file_get_contents($file)); if(!$data) { die(sprintf("XML error: %s at line %d", xml_error_string(xml_get_error_code($xml_parser)), xml_get_current_line_number($xml_parser))); } xml_parser_free($xml_parser); print("\n"); print_r($stack); print("\n"); ?>
本文题目:XMl各地区天气情况的详细信息,并将解析的数据入库
文章URL:http://scyanting.com/article/jesegh.html