Home > php教程 > php手册 > xml全国城市导入数据库

xml全国城市导入数据库

WBOY
Release: 2016-06-06 19:36:56
Original
1140 people have browsed it

xml全国城市导入数据库 无 $string = XML?xml version="1.0" encoding="UTF-8"?!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"plist version="1.0"arraystring北京市/stringstring天津市/stringstri

xml全国城市导入数据库
$string = <<<XML
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<array>
	<string>北京市</string>
	<string>天津市</string>
	<string>上海市</string>
	<string>重庆市</string>
	<string>合川市</string>
	<string>永川市</string>
	<string>江津市</string>
	<string>南川市</string>
	<string>石家庄市</string>
	<string>辛集市</string>
	<string>藁城市</string>
	<string>晋州市</string>
	<string>新乐市</string>
	<string>鹿泉市</string>
	<string>张家口市</string>
	<string>承德市</string>
	<string>秦皇岛市</string>
	<string>唐山市</string>
	<string>遵化市</string>
	<string>迁安市</string>
	<string>廊坊市</string>
	<string>霸州市</string>
	<string>三河市</string>
	<string>保定市</string>
	<string>定州市</string>
	<string>涿州市</string>
	<string>安国市</string>
	<string>高碑店市</string>
	<string>衡水市</string>
	<string>冀州市</string>
	<string>深州市</string>
	<string>河间市</string>
	<string>黄骅市</string>
	<string>任丘市</string>
	<string>泊头市</string>
	<string>沧州市</string>
	<string>沙河市</string>
	<string>南宫市</string>
	<string>邢台市</string>
	<string>武安市</string>
	<string>邯郸市</string>
	<string>古交市</string>
	<string>太原市</string>
	<string>朔州市</string>
	<string>大同市</string>
	<string>阳泉市</string>
	<string>潞城市</string>
	<string>长治市</string>
	<string>高平市</string>
	<string>晋城市</string>
	<string>原平市</string>
	<string>忻州市</string>
	<string>介休市</string>
	<string>晋中市</string>
	<string>霍州市</string>
	<string>侯马市</string>
	<string>临汾市</string>
	<string>汾阳市</string>
	<string>孝义市</string>
	<string>吕梁市</string>
	<string>河津市</string>
	<string>永济市</string>
	<string>运城市</string>
	<string>呼和浩特市</string>
	<string>包头市</string>
	<string>乌海市</string>
	<string>霍林郭勒市</string>
	<string>通辽市</string>
	<string>额尔古纳市</string>
	<string>根河市</string>
	<string>牙克石市</string>
	<string>扎兰屯市</string>
	<string>满洲里市</string>
	<string>呼伦贝尔市</string>
	<string>鄂尔多斯市</string>
	<string>丰镇市</string>
	<string>乌兰察布市</string>
	<string>巴彦淖尔市</string>
	<string>阿尔山市</string>
	<string>乌兰浩特市</string>
	<string>二连浩特市</string>
	<string>锡林浩特市</string>
	<string>新民市</string>
	<string>沈阳市</string>
	<string>凌源市</string>
	<string>北票市 </string>
	<string>朝阳市</string>
	<string>阜新市</string>
	<string>开原市</string>
	<string>调兵山市</string>
	<string>铁岭市</string>
	<string>抚顺市</string>
	<string>本溪市</string>
	<string>灯塔市</string>
	<string>辽阳市</string>
	<string>海城市</string>
	<string>鞍山市</string>
	<string>东港市</string>
	<string>凤城市</string>
	<string>丹东市</string>
	<string>庄河市</string>
	<string>普兰店市</string>
	<string>瓦房店市</string>
	<string>大连市</string>
	<string>盖州市</string>
	<string>大石桥市</string>
	<string>营口市</string>
	<string>盘锦市</string>
	<string>北宁市</string>
	<string>凌海市</string>
	<string>锦州市</string>
	<string>兴城市</string>
	<string>葫芦岛市</string>
	<string>榆树市</string>
	<string>九台市</string>
	<string>德惠市</string>
	<string>长春市</string>
	<string>洮南市</string>
	<string>大安市</string>
	<string>白城市</string>
	<string>松原市</string>
	<string>舒兰市</string>
	<string>桦甸市</string>
	<string>蛟河市</string>
	<string>磐石市</string>
	<string>吉林市</string>
	<string>公主岭市</string>
	<string>双辽市</string>
	<string>四平市</string>
	<string>辽源市</string>
	<string>集安市</string>
	<string>梅河口市</string>
	<string>通化市</string>
	<string>临江市</string>
	<string>白山市</string>
	<string>和龙市</string>
	<string>龙井市</string>
	<string>珲春市</string>
	<string>敦化市</string>
	<string>图们市</string>
	<string>延吉市</string>
	<string>阿城市</string>
	<string>五常市</string>
	<string>尚志市</string>
	<string>双城市</string>
	<string>哈尔滨市</string>
	<string>七台河市</string>
	<string>讷河市</string>
	<string>齐齐哈尔市</string>
	<string>五大连池市</string>
	<string>北安市</string>
	<string>黑河市</string>
	<string>大庆市</string>
	<string>鹤岗市</string>
	<string>铁力市</string>
	<string>伊春市</string>
	<string>富锦市</string>
	<string>同江市 </string>
	<string>佳木斯市</string>
	<string>双鸭山市</string>
	<string>密山市</string>
	<string>虎林市</string>
	<string>鸡西市</string>
	<string>宁安市</string>
	<string>海林市 </string>
	<string>绥芬河市</string>
	<string>穆棱市</string>
	<string>牡丹江市</string>
	<string>海伦市</string>
	<string>肇东市</string>
	<string>安达市</string>
	<string>绥化市</string>
	<string>南京市</string>
	<string>新沂市</string>
	<string>邳州市</string>
	<string>徐州市</string>
	<string>连云港市</string>
	<string>宿迁市</string>
	<string>淮安市</string>
	<string>大丰市</string>
	<string>东台市</string>
	<string>盐城市</string>
	<string>高邮市</string>
	<string>江都市</string>
	<string>仪征市</string>
	<string>扬州市</string>
	<string>兴化市</string>
	<string>姜堰市</string>
	<string>泰兴市</string>
	<string>靖江市</string>
	<string>泰州市</string>
	<string>如皋市</string>
	<string>通州市</string>
	<string>启东市</string>
	<string>海门市</string>
	<string>南通市</string>
	<string>句容市</string>
	<string>丹阳市</string>
	<string>扬中市</string>
	<string>镇江市</string>
	<string>溧阳市</string>
	<string>金坛市</string>
	<string>常州市</string>
	<string>宜兴市</string>
	<string>江阴市</string>
	<string>无锡市</string>
	<string>张家港市</string>
	<string>常熟市</string>
	<string>太仓市</string>
	<string>昆山市</string>
	<string>吴江市</string>
	<string>苏州市</string>
	<string>建德市</string>
	<string>富阳市</string>
	<string>临安市</string>
	<string>杭州市</string>
	<string>湖州市</string>
	<string>桐乡市</string>
	<string>海宁市</string>
	<string>平湖市</string>
	<string>嘉兴市</string>
	<string>舟山市</string>
	<string>奉化市</string>
	<string>余姚市</string>
	<string>慈溪市</string>
	<string>宁波市</string>
	<string>嵊州市</string>
	<string>上虞市</string>
	<string>诸暨市</string>
	<string>绍兴市</string>
	<string>江山市</string>
	<string>衢州市</string>
	<string>东阳市</string>
	<string>义乌市</string>
	<string>永康市</string>
	<string>兰溪市</string>
	<string>金华市</string>
	<string>温岭市</string>
	<string>临海市</string>
	<string>台州市</string>
	<string>乐清市</string>
	<string>瑞安市</string>
	<string>温州市</string>
	<string>龙泉市</string>
	<string>丽水市</string>
	<string>合肥市</string>
	<string>宿州市</string>
	<string>淮北市</string>
	<string>亳州市</string>
	<string>界首市</string>
	<string>阜阳市</string>
	<string>蚌埠市</string>
	<string>淮南市</string>
	<string>天长市</string>
	<string>明光市</string>
	<string>滁州市</string>
	<string>马鞍山市</string>
	<string>芜湖市</string>
	<string>铜陵市</string>
	<string>桐城市</string>
	<string>安庆市</string>
	<string>黄山市</string>
	<string>六安市</string>
	<string>巢湖市</string>
	<string>池州市</string>
	<string>宁国市</string>
	<string>宣城市</string>
	<string>长乐市</string>
	<string>福清市</string>
	<string>福州市</string>
	<string>建阳市</string>
	<string>建瓯市</string>
	<string>武夷山市</string>
	<string>邵武市</string>
	<string>南平市</string>
	<string>莆田市</string>
	<string>永安市</string>
	<string>三明市</string>
	<string>南安市</string>
	<string>晋江市</string>
	<string>石狮市</string>
	<string>泉州市</string>
	<string>厦门市</string>
	<string>龙海市</string>
	<string>漳州市</string>
	<string>漳平市</string>
	<string>龙岩市</string>
	<string>福鼎市</string>
	<string>福安市</string>
	<string>宁德市</string>
	<string>南昌市</string>
	<string>瑞昌市</string>
	<string>九江市</string>
	<string>乐平市</string>
	<string>景德镇市</string>
	<string>贵溪市</string>
	<string>鹰潭市</string>
	<string>新余市</string>
	<string>萍乡市</string>
	<string>南康市</string>
	<string>瑞金市</string>
	<string>赣州市</string>
	<string>德兴市</string>
	<string>上饶市</string>
	<string>抚州市</string>
	<string>高安市</string>
	<string>樟树市</string>
	<string>丰城市</string>
	<string>宜春市</string>
	<string>吉安市</string>
	<string>章丘市</string>
	<string>济南市</string>
	<string>临清市</string>
	<string>聊城市</string>
	<string>禹城市</string>
	<string>乐陵市</string>
	<string>德州市</string>
	<string>东营市</string>
	<string>淄博市</string>
	<string>寿光市</string>
	<string>诸城市</string>
	<string>青州市</string>
	<string>高密市</string>
	<string>昌邑市 </string>
	<string>安丘市</string>
	<string>潍坊市</string>
	<string>招远市</string>
	<string>蓬莱市</string>
	<string>莱州市</string>
	<string>莱阳市</string>
	<string>龙口市</string>
	<string>海阳市</string>
	<string>栖霞市</string>
	<string>烟台市</string>
	<string>文登市</string>
	<string>乳山市</string>
	<string>荣成市</string>
	<string>威海市</string>
	<string>莱西市</string>
	<string>胶南市</string>
	<string>平度市</string>
	<string>即墨市</string>
	<string>胶州市</string>
	<string>青岛市</string>
	<string>日照市</string>
	<string>临沂市</string>
	<string>滕州市</string>
	<string>枣庄市</string>
	<string>邹城市</string>
	<string>兖州市</string>
	<string>曲阜市</string>
	<string>济宁市</string>
	<string>肥城市</string>
	<string>新泰市</string>
	<string>泰安市</string>
	<string>莱芜市</string>
	<string>滨州市</string>
	<string>菏泽市</string>
	<string>济源市</string>
	<string>荥阳市</string>
	<string>巩义市</string>
	<string>新密市</string>
	<string>登封市</string>
	<string>新郑市</string>
	<string>郑州市</string>
	<string>灵宝市</string>
	<string>义马市</string>
	<string>三门峡市</string>
	<string>偃师市</string>
	<string>洛阳市</string>
	<string>沁阳市</string>
	<string>孟州市</string>
	<string>焦作市</string>
	<string>辉县市</string>
	<string>卫辉市</string>
	<string>新乡市</string>
	<string>鹤壁市</string>
	<string>林州市</string>
	<string>安阳市</string>
	<string>濮阳市</string>
	<string>开封市</string>
	<string>永城市</string>
	<string>商丘市</string>
	<string>长葛市</string>
	<string>禹州市</string>
	<string>许昌市</string>
	<string>漯河市</string>
	<string>汝州市</string>
	<string>舞钢市</string>
	<string>平顶山市</string>
	<string>邓州市</string>
	<string>南阳市</string>
	<string>信阳市</string>
	<string>项城市</string>
	<string>周口市</string>
	<string>驻马店市</string>
	<string>潜江市</string>
	<string>天门市</string>
	<string>仙桃市</string>
	<string>武汉市</string>
	<string>丹江口市</string>
	<string>十堰市</string>
	<string>宜城市</string>
	<string>枣阳市</string>
	<string>老河口市 </string>
	<string>襄樊市</string>
	<string>钟祥市</string>
	<string>荆门市</string>
	<string>汉川市</string>
	<string>安陆市</string>
	<string>应城市</string>
	<string>黄冈市</string>
	<string>鄂州市</string>
	<string>大冶市</string>
	<string>黄石市</string>
	<string>赤壁市</string>
	<string>咸宁市</string>
	<string>松滋市</string>
	<string>洪湖市</string>
	<string>石首市</string>
	<string>荆州市</string>
	<string>当阳市</string>
	<string>宜都市</string>
	<string>枝江市</string>
	<string>宜昌市</string>
	<string>广水市</string>
	<string>随州市</string>
	<string>利川市</string>
	<string>恩施市</string>
	<string>浏阳市</string>
	<string>长沙市</string>
	<string>张家界市</string>
	<string>津市市</string>
	<string>常德市</string>
	<string>沅江市</string>
	<string>益阳市</string>
	<string>临湘市</string>
	<string>汨罗市</string>
	<string>岳阳市</string>
	<string>醴陵市</string>
	<string>株洲市</string>
	<string>韶山市</string>
	<string>湘乡市</string>
	<string>湘潭市</string>
	<string>耒阳市</string>
	<string>常宁市</string>
	<string>衡阳市</string>
	<string>资兴市</string>
	<string>郴州市</string>
	<string>永州市</string>
	<string>武冈市</string>
	<string>邵阳市</string>
	<string>洪江市</string>
	<string>怀化市</string>
	<string>涟源市</string>
	<string>冷水江市</string>
	<string>娄底市</string>
	<string>吉首市</string>
	<string>从化市</string>
	<string>增城市 </string>
	<string>广州市</string>
	<string>连州市</string>
	<string>英德市</string>
	<string>清远市</string>
	<string>南雄市</string>
	<string>乐昌市</string>
	<string>韶关市</string>
	<string>河源市</string>
	<string>兴宁市</string>
	<string>梅州市</string>
	<string>潮州市</string>
	<string>汕头市</string>
	<string>普宁市</string>
	<string>揭阳市</string>
	<string>陆丰市</string>
	<string>汕尾市</string>
	<string>惠州市</string>
	<string>东莞市</string>
	<string>深圳市</string>
	<string>珠海市</string>
	<string>中山市</string>
	<string>鹤山市</string>
	<string>开平市</string>
	<string>台山市</string>
	<string>恩平市</string>
	<string>江门市</string>
	<string>佛山市</string>
	<string>四会市</string>
	<string>高要市</string>
	<string>肇庆市</string>
	<string>罗定市</string>
	<string>云浮市</string>
	<string>阳春市</string>
	<string>阳江市</string>
	<string>高州市</string>
	<string>信宜市</string>
	<string>化州市</string>
	<string>茂名市</string>
	<string>廉江市</string>
	<string>雷州市</string>
	<string>吴川市</string>
	<string>湛江市</string>
	<string>南宁市</string>
	<string>桂林市</string>
	<string>柳州市</string>
	<string>岑溪市</string>
	<string>梧州市</string>
	<string>桂平市</string>
	<string>贵港市</string>
	<string>北流市</string>
	<string>玉林市</string>
	<string>钦州市</string>
	<string>北海市</string>
	<string>东兴市</string>
	<string>防城港市</string>
	<string>凭祥市</string>
	<string>崇左市</string>
	<string>百色市</string>
	<string>宜州市</string>
	<string>河池市</string>
	<string>合山市</string>
	<string>来宾市</string>
	<string>贺州市</string>
	<string>儋州市</string>
	<string>东方市</string>
	<string>五指山市</string>
	<string>万宁市</string>
	<string>琼海市</string>
	<string>文昌市</string>
	<string>海口市</string>
	<string>三亚市</string>
	<string>崇州市</string>
	<string>邛崃市 </string>
	<string>彭州市</string>
	<string>都江堰市</string>
	<string>成都市</string>
	<string>广元市</string>
	<string>江油市</string>
	<string>绵阳市</string>
	<string>绵竹市</string>
	<string>广汉市</string>
	<string>什邡市</string>
	<string>德阳市</string>
	<string>阆中市</string>
	<string>南充市</string>
	<string>华蓥市</string>
	<string>广安市</string>
	<string>遂宁市</string>
	<string>内江市</string>
	<string>峨眉山市</string>
	<string>乐山市</string>
	<string>自贡市</string>
	<string>泸州市</string>
	<string>宜宾市</string>
	<string>攀枝花市</string>
	<string>巴中市</string>
	<string>万源市</string>
	<string>达州市</string>
	<string>简阳市</string>
	<string>资阳市</string>
	<string>眉山市</string>
	<string>雅安市</string>
	<string>西昌市</string>
	<string>清镇市</string>
	<string>贵阳市</string>
	<string>六盘水市</string>
	<string>仁怀市</string>
	<string>赤水市</string>
	<string>遵义市</string>
	<string>毕节市</string>
	<string>铜仁市</string>
	<string>凯里市</string>
	<string>福泉市</string>
	<string>都匀市</string>
	<string>兴义市</string>
	<string>安宁市</string>
	<string>昆明市</string>
	<string>宣威市</string>
	<string>曲靖市</string>
	<string>玉溪市</string>
	<string>保山市</string>
	<string>昭通市</string>
	<string>丽江市</string>
	<string>思茅市</string>
	<string>临沧市</string>
	<string>瑞丽市</string>
	<string>潞西市</string>
	<string>大理市</string>
	<string>楚雄市</string>
	<string>开远市</string>
	<string>个旧市</string>
	<string>景洪市</string>
	<string>拉萨市</string>
	<string>日喀则市</string>
	<string>西安市</string>
	<string>延安市</string>
	<string>铜川市</string>
	<string>韩城市</string>
	<string>华阴市</string>
	<string>渭南市</string>
	<string>兴平市</string>
	<string>咸阳市</string>
	<string>宝鸡市</string>
	<string>汉中市</string>
	<string>榆林市</string>
	<string>安康市</string>
	<string>商洛市</string>
	<string>兰州市</string>
	<string>嘉峪关市</string>
	<string>金昌市</string>
	<string>白银市</string>
	<string>天水市</string>
	<string>武威市</string>
	<string>敦煌市</string>
	<string>玉门市 </string>
	<string>酒泉市</string>
	<string>张掖市</string>
	<string>庆阳市</string>
	<string>平凉市</string>
	<string>定西市</string>
	<string>陇南市</string>
	<string>临夏市</string>
	<string>合作市</string>
	<string>西宁市</string>
	<string>德令哈市格尔木市</string>
	<string>灵武市</string>
	<string>银川市</string>
	<string>石嘴山市</string>
	<string>青铜峡市</string>
	<string>吴忠市</string>
	<string>固原市</string>
	<string>中卫市</string>
	<string>五家渠市</string>
	<string>图木舒克市</string>
	<string>阿拉尔市</string>
	<string>石河子市</string>
	<string>乌鲁木齐市</string>
	<string>克拉玛依市</string>
	<string>喀什市</string>
	<string>阿克苏市</string>
	<string>和田市</string>
	<string>吐鲁番市</string>
	<string>哈密市</string>
	<string>阿图什市</string>
	<string>博乐市</string>
	<string>米泉市</string>
	<string>阜康市</string>
	<string>昌吉市</string>
	<string>库尔勒市</string>
	<string>奎屯市</string>
	<string>伊宁市</string>
	<string>乌苏市</string>
	<string>塔城市</string>
	<string>阿勒泰市</string>
	<string>香港市</string>
	<string>澳门市</string>
	<string>高雄市</string>
	<string>台北市</string>
	<string>嘉义市</string>
	<string>新竹市</string>
	<string>台南市</string>
	<string>台中市</string>
	<string>基隆市</string>
</array>
</plist>

XML;

$xml = simplexml_load_string($string);
// print_r($xml);
$login = $xml->array;//这里返回的依然是个SimpleXMLElement对象
///print_r($login);
// $login = (string) $xml->array;//在做数据比较时,注意要先强制转换
// print_r($login);
function objectToArray($e){  // 对象转换成数组
    $e=(array)$e;
    foreach($e as $k=>$v){
        if( gettype($v)=='resource' ) return;
        if( gettype($v)=='object' || gettype($v)=='array' )
            $e[$k]=(array)objectToArray($v);
    }
    return $e;
}
$arr=objectToArray($login);
//  print_r($arr['string']);
	foreach($arr['string'] as $val){
		mysql_query("insert into p_city(`name`)values('$val')");		
	}
	$s=mysql_errno();
	echo "{\"s\":$s}";	
Copy after login
Related labels:
source:php.cn
Statement of this Website
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
Popular Recommendations
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template