Dreistufiges Verknüpfungsmenü der Provinzen und Gemeinden (mit Datenbank)-PHP-Tutorial-php.cn

http-equiv="Content-Type"
c/span>"text/html; charset=utf-8" /> >

" text/javascript ">

< ;/head>
>$conn
"localhost"
"root", "");//Datenbank verknüpfen mysql_select_db("novel");//Datenbank auswählen
mysql_query("set name 'utf8'" );//Zeichensatz festlegen
$sql="select * from Province"
//Abfrage die Provinztabelle der Datenbank, die die Provinz $result=mysql_query( ist $sql
//Weisen Sie die Ausführungsanweisung der Variablen ?> zu > 'form1'> >
'city'> 🎜> > 🎜>
>
[php] Klartext anzeigen
2. $provincecode=$ _GET['provincecode'];//Provinzschlüsselwert erhalten
3. $citycode=$_GET['citycode' ];//Stadtschlüsselwert empfangen
4. $conn=mysql_connect("localhost","root",""); //Mit dem Host verbinden
5. mysql_select_db("novel"); //Datenbank auswählen
6. mysql_query("setnamen 'utf8'");
7. if($provincecode!="" ){//Wenn der übergebene Wert nicht leer ist, führen Sie
8. $sql<🎜 aus >="select * from city where Provincecode=$provincecode";//Fragen Sie die Stadt ab, die mit dem Feld übereinstimmt, das zu der oben übergebenen Provinz gehört
9. $result=mysql_query($sql) ; //SQL-Abfrageanweisung ausführen
10. $row
12. ; } ?> >
13. [xhtml] Klartext anzeigen
  
  -- phpMyAdmin SQL Dump
  
  -- Version 2.11.2
  
  -- http://www.phpmyadmin.net
  
  --
  
  -- Host: localhost
  
  -- Erstellt am: 11. Juli 2008 00:45
  
  -- Serverversion: 5.0.27
  
  -- PHP-Version: 5.2.0
  
  SET SQL_MODE= "NO_AUTO_VALUE_ON_ZERO "; >-- Datenbank: `Roman`
  
  --
  
  DATENBANK ERSTELLEN `Roman` STANDARDZEICHENSATZ utf8 COLLATE utf8_general_ci;
  
  USE `novel`; ------ -------------------------------------------- -
  
  --
  
  -- Tabellenstruktur „Bereich“
  
  --
  
  TABELLE ERSTELLEN, WENN „Bereich“ NICHT EXISTIERT (
  
  `id` int(11) NOT NULL auto_increment,
  
  `code` varchar(6) NOT NULL,
  
  `name` varchar( 20) NOT NULL,
  
  `citycode` varchar(6) NOT NULL,
  
  PRIMARY KEY (`id` )
  
  ) ENGINE
  =
  MyISAM
  DEFAULT
  CHARSET
  =
  utf8
  
  AUTO_INCREMENT
  =
  3145 ; -- -- Exportieren Sie die Daten in die Tabelle „Bereich“ --
  
  INSERT INTO `area` (`id`, `code`, `name `, `citycode`) VALUES
  
  (1, '110101', 'Dongcheng District', '110100'),
  
  (2 , '110102', ' Bezirk Xicheng', '110100'),
  
  (3, '110103', 'Bezirk Chongwen', '110100'),
  
  (4, '110104', 'Xuanwu District', '110100'),
  
  (5, '110105', 'Chaoyang District', '110100' ),
  
  (6, '110106', 'Bezirk Fengtai', '110100'),
  
  (7, '110107', 'Shijingshan District', ' 110100'),
  
  (8, '110108', 'Haidian District', '110100'),
  
  (9, '110109 ', 'Bezirk Mentougou', '110100'),
  
  (10, '110111', 'Bezirk Fangshan', '110100'),
  
  (11, '110112', 'Bezirk Tongzhou', '110100'),
  
  (12, '110113', 'Bezirk Shunyi', '110100'),
  
  (13, '110114', 'Changping District', '110100'),
  
  (14, ' 110115', 'Daxing District', '110100'),
  
  (15, '110116', 'Huairou District', '110100'),
  
  (16 , '110117', 'Pinggu District', '110100'),
  
  (17, '110228', 'Miyun County', '110200'),
  
  (18, '110229', 'Yanqing County', '110200'),
  
  (19, '120101', 'Heping Bezirk', '120100' ),
  
  (20, '120102', 'Hedong Bezirk', '120100'),
  
  ( 21, '120103', 'Hexi District', '120100'),
  
  (22, '120104', 'Nankai District', '120100'),
  
  (23, '120105', 'Bezirk Hebei', '120100'),
  
  (24, '120106', 'Bezirk Hongqiao', '120100 '),
  
  (25, '120107', 'Tanggu District', '120100'),
  
  (26, '120108' , 'Hangu District' , '120100'),
  
  (27, '120109', 'Dagang District', '120100'),
  
  (28, '120110', 'Dongli District', '120100'),
  
  (29, '120111', 'Xiqing District', '120100'),
  
  (30, '120112', 'Jinnan District', '120100 ' ),
  
  (31, '120113', 'Bezirk Beichen', '120100'),
  
  (32, '120114' , 'Wuqing District', '120100'),
  
  (33, '120115', 'Baodi District', '120100'),
  
  (34, '120221', 'Ninghe County', '120200'),
  
  (35, '120223', 'Jinghai County', '120200'),
  
  (36, '120225', 'Ji County', '120200'),
  
  (37, '130101', 'Gemeindebezirk', '130100'),
  
  (38, '130102', 'Chang'an District', '130100'),
  
  (39 , '130103', 'Qiaodong District', '130100'),
  
  (40, '130104', 'Qiaoxi District', '130100'),
  
  (41, '130105', 'Xinhua District', '130100'),
  
  (42, '130107', 'Jingxing Mining District', '130100 '),
  
  (43, '130108', 'Yuhua District', '130100'),
  
  (44, '130121 ' , 'Jingxing County', '130100'),
  
  (45, '130123', 'Zhengding County', '130100'),
  
  (46, '130124', 'Luancheng County', '130100'),
  
  (47, '130125', 'Xingtang County', '130100') ,
  
  (48, '130126', 'Lingshou County', '130100'),
  
  (49, '130127', 'Gaoyi County' , '130100'),
  
  (50, '130128', 'Shenze County', '130100'),
  
  (51, '130129', 'Zanhuang County', '130100'),
  
  (52, '130130', 'Wuji County', '130100'),
  
  (53, '130131', 'Pingshan County', '130100'),
  
  (54, '130132', '元Shi County', '130100' ),
  
  (55, '130133', 'Zhao County', '130100'),
  
  (56, '130181', 'Xinji City', '130100'),
  
  (57, '130182', 'Gaocheng City', '130100'),
  
  (58, '130183', 'Jinzhou City', '130100'),
  
  (59, '130184', 'Xinle City', '130100'),
  
  (60, '130185', 'Luquan City', '130100'),
  
  (61 , '130201', 'Gemeindebezirk', '130200'),
  
  (62, '130202', 'Lunan District', '130200'),
  
  (63, ' 130203', 'Lubei District', '130200'),
  
  (64, '130204', 'Guye District', '130200'),
  
  (65, '130205', 'Bezirk Kaiping', '130200'),
  
  (66, ' 130207', 'Bezirk Fengnan', '130200'),
  
  (67, '130208', 'Fengrun District', '130200'),
  
  (68, '130223', 'Luannan County', '130200'),
  
  (69, '130224', 'Luannan County', '130200' ),
  
  ( 70, '130225', 'Leting County', '130200'),
  
  (71, '130227', 'Qianxi County', '130200'),
  
  (72, '130229', 'Yutian County', '130200'),
  
  (73, '130230', 'Tanghai County', '130200 '),
  
  (74, '130281', 'Zunhua City', '130200') ,
  
  (75, '130283' , 'Qian'an City', '130200'),
  
  (76, '130301', 'Gemeindebezirk', '130300'),
  
  (77, '130302', 'Bezirk Haigang', '130300'),
  
  (78, '130303', 'Bezirk Shanhaiguan', '130300'),
  
  (79, '130304', 'Beidaihe District', '130300'),
  
  (80, '130321', 'Qinglong Autonomer Kreis Mandschu‘, ‚130300‘),
  
  (81, ‚130322‘, ‚Kreis Changli‘, ‚130300‘),
  
  (82, '130323', 'Funing County', '130300'),
  
  (83, '130324', 'Lulong County', '130300'),
  
  (84, '130401', 'Gemeindebezirk', '130400'),
  
  (85, '130402', 'Hanshan District', '130400'),
  
  (86, '130403', 'Congtai District', '130400'),
  
  (87, '130404', 'Fuxing District', '130400 ' ),
  
  (88, '130406', 'Fengfeng Mining Area', '130400'),
  
  (89, '130421 ' , 'Handan County', '130400'),
  
  (90, '130423', 'Linzhang County', '130400'),
  
  (91, '130424', 'Cheng'an County', '130400'),
  
  (92, '130425', 'Daming County', '130400'),
  
  (93, '130426', 'She County', '130400'),
  
  (94, '130427', 'Magnetic County‘, ‚130400‘),
  
  (95, ‚130428‘, ‚Feixiang County‘, ‚130400‘),
  
  ( 96, '130429', 'Yongnian County', '130400'),
  
  (97, '130430', 'Qiu County', '130400'),
  
  (98, '130431', 'Jize County', '130400'),
  
  (99, '130432', 'Guangping County', '130400 '),
  
  (100, '130433', 'Guantao County', '130400'),
  
  (101 , '130434' , 'Weixian', '130400'),
  
  (102, '130435', 'Quzhou County', '130400'),
  
  (103, '130481', 'Wu'an City', '130400'),
  
  (104, '130501', 'Municipal District', '130500 '),
  
  (105, '130502', 'Bezirk Qiaodong', '130500'),
  
  (106, '130503', 'Bezirk Qiaoxi ', '130500'),
  
  (107, '130521', 'Xingtai County', '130500'),
  
  (108 , '130522', 'Lincheng County', '130500'),
  
  (109, '130523', 'Neiqiu County', '130500') ,
  
  (110, '130524', 'Kreis Baixiang', '130500'),
  
  (111, '130525', 'Kreis Longyao', '130500' ),
  
  (112, '130526', 'Ren County', '130500'),
  
  (113, '130527', 'Nanhe County', '130500'),
  
  (114, '130528', 'Ningjin County', '130500'),
  
  (115, '130529', 'Julu County', '130500'),
  
  (116, '130530', ' Xinhe County', '130500'),
  
  (117, '130531', 'Guangzong County', '130500'),
  
  (118, '130532', 'Pingxiang County', '130500'),
  
  (119, '130533', 'Wei County', '130500'),
  
  (120, ' 130534', 'Qinghe County', '130500'),
  
  (121, '130535', 'Linxi County', '130500'),
  
  (122, '130581', 'Nangong City', '130500'),
  
  ( 123, '130582', 'Shahe City', '130500'),
  
  (124, '130601', 'Gemeindebezirk', '130600'),
  
  (125, '130602', 'Neu Urban District', '130600'),
  
  (126, '130603', 'Northern Urban District', ' 130600'),
  
  (127, '130604', 'South City', '130600'),
  
  (128, ' 130621', 'Mancheng County', '130600'),
  
  (129, '130622', 'Qingyuan County', '130600'),
  
  (130, '130623', 'Laishui County', '130600'),
  
  (131, '130624', 'Fuping County', ' 130600'),
  
  (132, ' 130625', 'Xushui County', '130600'),
  
  (133, ' 130626', 'Dingxing County', '130600'),
  
  (134, '130627', 'Tang County', '130600'),
  
  (135, '130628', 'Gaoyang County', '130600'),
  
  (136, '130629', 'Rongcheng County', '130600' ),
  
  (137, '130630', 'Laiyuan Landkreis“, „130600“),
  
  (138, „130631“, „Wangdu Landkreis“, „130600“),
  
  ( 139, '130632', 'Anxin County', '130600'),
  
  (140, '130633', 'Yixian', '130600'),
  
  (141, '130634', 'Quyang County', '130600'),
  
  (142, '130635', 'Li County', '130600'),
  
  (143, '130636', 'Shunping County', '130600 ' ),
  
  (144, '130637', 'Boye County', '130600'),
  
  (145, '130638 ', 'Xiong County', '130600'),
  
  (146, '130681', 'Zhuozhou City', '130600'),
  
  (147, '130682', 'Dingzhou City', '130600'),
  
  (148, '130683', 'Anguo City', '130600'),
  
  (149, '130684', 'Gaobeidian City', '130600'),
  
  (150, '130701', 'Gemeindebezirk', '130700'),
  
  (151, '130702', 'Qiaodong District', '130700'),
  
  (152, ' 130703', 'Qiaoxi District', '130700'),
  
  (153, '130705', 'Xuanhua District', '130700'),
  
  (154, '130706', 'Xiahuayuan District', '130700'),
  
  (155, '130721', 'Xuanhua County', '130700'),
  
  (156, '130722', 'Zhangbei County', '130700'),
  
  ( 157, '130723', 'Kangbao Landkreis“, „130700“),
  
  (158, „130724“, „Guyuan Landkreis“, „130700“),
  
  ( 159, '130725', 'Shangyi County', '130700'),
  
  (160, '130726', 'Yuxian County', '130700'),
  
  (161, '130727', 'Yangyuan County', '130700'),
  
  (162 , '130728', 'Huaian County', '130700 '),
  
  (163, '130729', 'Wanquan County', '130700'),
  
  (164, '130730' , 'Huailai County', '130700'),
  
  (165, '130731', 'Zhuolu County', ' 130700'),
  
  (166, '130732', 'Chicheng County', '130700'),
  
  (167, '130733 ', 'Chongli County', '130700'),
  
  (168, '130801', 'Gemeindebezirk', '130800'),
  
  (169, '130802', 'Shuangqiao District' , '130800'),
  
  (170, '130803', 'Shuangluan District', '130800' ),
  
  (171, '130804', 'Yingshouyingzi Mining Area', '130800'),
  
  (172, ' 130821', 'Chengde County', '130800'),
  
  (173, '130822', 'Xinglong County', '130800'),
  
  (174, '130823', 'Pingquan County', '130800' ),
  
  (175, '130824', 'Luanping County', '130800') ,
  
  (176, '130825', 'Longhua County', '130800'),
  
  (177, '130826', 'Fengning Manchu Autonomous County', '130800'),
  
  (178, '130827', 'Autonomer Kreis Kuancheng Mandschu', '130800'),
  
  (179, '130828', 'Autonomer Kreis Weichang Mandschu und Mongolei', '130800'),
  
  (180, '130901', 'Gemeindebezirk', ' 130900'),
  
  (181, ' 130902', 'Xinhua District', '130900'),
  
  (182, '130903 ', 'Canal District', '130900'),
  
  (183, '130921', 'Cang County', '130900'),
  
  (184, '130922', 'Qing County', '130900'),
  
  (185, '130923', 'Dongguang County', '130900'),
  
  (186, '130924', 'Haixing County', '130900'),
  
  (187, '130925', ' Yanshan County', '130900'),
  
  ( 188, '130926', 'Suning County', '130900'),
  
  (189, '130927', 'Nanpi County', '130900'),
  
  (190, '130928', 'Wuqiao County', '130900'),
  
  (191, '130929', 'Xian County', '130900 '),
  
  (192, '130930', 'Autonomer Kreis Mengcun Hui', '130900'),
  
  (193, ' 130981', 'Botou City', '130900'),
  
  (194, '130982', 'Renqiu City', '130900'),
  
  (195, '130983', 'Huanghua City', '130900'),
  
  (196, '130984', 'Hejian City', '130900'),
  
  (197, '131001', 'Gemeindebezirk', '131000'),
  
  (198, '131002', 'Anci District', '131000'),
  
  (199, '131003', 'Guangyang District', ' 131000' ),
  
  (200, '131022', 'Gu'an County', '131000'),
  
  (201, '131023 ', 'Yongqing County', '131000'),
  
  (202, '131024', 'Xianghe County', '131000'),
  
  (203, '131025', 'Dacheng County', '131000'),
  
  (204, '131026', 'Wen'an County', '131000') ,
  
  (205, '131028', 'Autonomer Kreis Dachang Hui', '131000'),
  
  (206, '131081' , 'Bazhou City', '131000'),
  
  (207, '131082', 'Sanhe City', '131000'),
  
  (208, '131101', 'Municipal District', '131100'),
  
  (209, '131102', 'Taocheng District', '131100'),
  
  (210, '131121', 'Zaoqiang County', '131100'),
  
  (211, '131122', 'Wuyi County' , '131100'),
  
  (212, '131123', 'Wuqiang County', '131100'),
  
  (213, '131124', 'Raoyang County', '131100'),
  
  (214, '131125', 'Anping County', '131100'),
  
  (215, '131126', 'Gucheng County', '131100'),
  
  (216, '131127', 'Jing County', '131100') ,
  
  (217, '131128', 'Fucheng County', '131100'),
  
  (218 , '131181', ' Jizhou City', '131100'),
  
  (219, '131182', 'Shenzhou City', '131100'),
  
  (220, '140101', 'Municipal District', '140100'),
  
  (221, '140105', 'Small Store District', ' 140100'),
  
  (222, '140106', 'Yingze District', '140100'),
  
  (223, ' 140107', 'Xinghualing District', '140100'),
  
  (224, '140108', 'Jiancaoping District', '140100'),
  
  (225, ' 140109', 'Wanbalin District', '140100'),
  
  (226, '140110', 'Jinyuan District', '140100'),
  
  (227, '140121', 'Qingxu County', '140100'),
  
  (228, '140122', 'Yangqu County', '140100'),
  
  (229, '140123', 'Loufan County', '140100'),
  
  (230, '140181', 'Gujiao Stadt“, „140100“),
  
  (231, „140201“, „Gemeindebezirk“, „140200“),
  
  ( 232, '140202', 'Stadt', '140200'),
  
  (233, '140203', 'Bergbaugebiet', '140200'),
  
  (234, '140211', 'Südliche Vororte', '140200'),
  
  (235, '140212', 'Xinrong District', '140200' ),
  
  (236, '140221', 'Yanggao County', '140200'),
  
  (237, '140222', 'Tianzhen County', '140200'),
  
  (238, '140223', 'Guangzhou Ling County', '140200'),
  
  (239, '140224', 'Lingqiu County', '140200'),
  
  (240, '140225', 'Hunyuan County', '140200'),
  
  (241, '140226', 'Zuoyun County', '140200'),
  
  (242, '140227', 'Datong County' , '140200'),
  
  (243, '140301', 'Gemeindebezirk ', '140300'),
  
  (244, '140302', 'Stadt', '140300'),
  
  (245, '140303', 'Bergbaugebiet', '140300'),
  
  (246, '140311', 'Suburban', '140300'),
  
  (247, '140321', 'Pingding County', '140300'),
  
  (248, '140322', 'Yuxian County', '140300'),
  
  (249, '140401', 'Gemeindebezirk ', '140400'),
  
  (250, '140402', 'Stadtgebiet' , '140400'),
  
  (251 , '140411', 'Suburban', '140400'),
  
  (252, ' 140421', 'Changzhi County', '140400'),
  
  (253, '140423', 'Xiangyuan County', '140400'),
  
  (254, '140424', 'Tunliu County', '140400'),
  
  (255, '140425', 'Pingshun County', '140400 ' ),
  
  (256, '140426', 'Licheng County', '140400'),
  
  (257, '140427 ', 'Huguan County', '140400'),
  
  (258, '140428', 'Changzi County', '140400'),
  
  (259, '140429', 'Wuxiang County', '140400'),
  
  (260, '140430', 'Qin County', '140400') ,
  
  (261, '140431', 'Qinyuan County', '140400'),
  
  (262, '140481', 'Lucheng City', '140400'),
  
  (263, '140501', 'Gemeindebezirk', '140500'),
  
  (264, ' 140502', 'Stadt', '140500'),
  
  (265, '140521', 'Qinshui County', '140500'),
  
  (266, '140522', 'Yangcheng County', '140500'),
  
  (267, '140524', 'Lingchuan County', '140500'),
  
  (268, '140525', 'Zezhou County', '140500'),
  
  ( 269, '140581', 'Gaoping City ', '140500'),
  
  (270, '140601', 'Gemeindebezirk', '140600'),
  
  (271 , '140602', 'Shocheng District', '140600'),
  
  (272, '140603', 'Pinglu District', ' 140600'),
  
  (273, '140621', 'Shanyin County', '140600'),
  
  (274, ' 140622', 'Ying County', '140600' ),
  
  (275, '140623', 'Youyu County', '140600'),
  
  (276, '140624', 'Huairen County', '140600'),
  
  (277, '140701', 'Municipal District', '140700' ),
  
  (278, '140702', 'Yuci District', '140700'),
  
  (279, '140721', 'Yushe County', '140700'),
  
  (280, '140722', 'Zuoquan County', '140700'),
  
  (281, '140723', 'Heshun County', '140700'),
  
  (282, '140724', 'Xiyang County', '140700'),
  
  (283, ' 140725', 'Shouyang County', '140700'),
  
  (284, '140726', ' Taigu County', '140700'),
  
  (285, '140727', 'Qi County', '140700'),
  
  (286, '140728', 'Pingyao County', '140700'),
  
  (287, '140729', 'Lingshi County', '140700'),
  
  (288, '140781', 'Jiexiu Stadt“, „140700“),
  
  (289, „140801“, „Gemeindebezirk“, „140800“),
  
  ( 290, '140802', 'Salt Lake District', '140800'),
  
  (291, '140821', 'Linyi County', '140800'),
  
  (292, '140822', 'Wanrong County', '140800'),
  
  (293, '140823', 'Wenxi County', ' 140800'),
  
  (294, '140824', 'Jishan County', ' 140800'),
  
  (295, '140825 ', 'Xinjiang County', '140800'),
  
  (296, ' 140826', 'Jiangxian County', '140800'),
  
  (297, '140827', 'Yuanqu County', '140800'),
  
  (298, '140828', 'Xia County', '140800'),
  
  (299, '140829', 'Pinglu County', '140800' ),
  
  (300, '140830', 'Ruicheng County ', '140800'),
  
  (301, '140881' , 'Yongji City', '140800'),
  
  (302 , '140882', 'Hejin City', '140800'),
  
  (303, '140901', 'Gemeindebezirk', '140900'),
  
  (304, '140902', 'Xinfu District', '140900'),
  
  (305, '140921', 'Dingxiang County', '140900' ),
  
  (306, '140922', ' Wutai County', '140900'),
  
  (307, '140923', 'Dai County', '140900'),
  
  (308, '140924', 'Fanzhi County', '140900'),
  
  (309, '140925', 'Ningwu County', '140900'),
  
  (310, '140926', 'Jingle County', '140900'),
  
  (311, '140927', 'Shenchi County', '140900 ' ),
  
  (312, '140928', 'Wuzhai County', '140900'),
  
  (313, '140929 ', 'Kelan County', '140900'),
  
  (314, '140930', 'Hequ County', '140900'),
  
  (315, '140931', 'Baode County', '140900'),
  
  (316, '140932', 'Pianguan County', '140900' ),
  
  (317, '140981', 'Yuanping City', '140900'),
  
  (318, '141001', 'Gemeindebezirk', '141000'),
  
  (319, '141002', '尧都区', '141000'),
  
  (320, '141021', 'Quwo County', '141000'),
  
  (321, '141022', 'Yicheng County', '141000'),
  
  (322, '141023', 'Xiangfen County', '141000'),
  
  (323, '141024', 'Hongdong County', '141000') ,
  
  (324, '141025', 'Gu County', '141000'),
  
  (325, '141026', ' Anze County', '141000'),
  
  (326, '141027', 'Fushan County', '141000'),
  
  (327, '141028', 'Ji County', '141000'),
  
  (328, '141029', 'Xiangning County', '141000'),
  
  (329, '141030', 'Daning County', '141000'),
  
  (330, '141031', '隰县', ' 141000'),
  
  (331, '141032', 'Yonghe County', '141000'),
  
  (332, '141033 ', 'Pu County', '141000'),
  
  (333, '141034', 'Fanxi County', '141000' ),
  
  (334, '141081', 'Houma City', '141000'),
  
  (335, '141082', 'Huozhou City', '141000'),
  
  (336, '141101', 'Municipal District', '141100'),
  
  (337, '141102', 'Lishi District ', '141100'),
  
  (338, '141121', 'Wenshui County', '141100') ,
  
  (339 , '141122', 'Jiaocheng County', '141100'),
  
  (340, '141123', 'Xingxian', '141100'),
  
  (341, '141124', 'Linxian', '141100'),
  
  (342, '141125', 'Liulin County', '141100'),
  
  (343, '141126', 'Shilou County', '141100'),
  
  (344, '141127', 'Lan County', '141100'),
  
  (345, '141128', 'Fangshan County', '141100'),
  
  ( 346, '141129', 'Zhongyang County', '141100'),
  
  (347, '141130', 'Jiaokou County', '141100'),
  
  (348, '141181', 'Xiaoyi City', '141100'),
  
  (349, '141182', 'Fenyang City', '141100 '),
  
  (350, '150101', 'Gemeindebezirk' , '150100'),
  
  (351, '150102' , 'Bezirk Xincheng', '150100'),
  
  (352, '150103', 'Bezirk Huimin', '150100'),
  
  (353, '150104', 'Yuquan District', '150100'),
  
  (354, '150105', 'Saihan District', '150100'),
  
  (355, '150121', 'Tumut Left Banner', '150100'),
  
  (356, '150122', 'Toketo County ', '150100'),
  
  (357 , '150123', 'Helinger County', '150100'),
  
  (358 , '150124', 'Qingshuihe County', '150100'),
  
  (359, '150125', 'Wuchuan County', '150100'),
  
  (360, '150201', 'Gemeindebezirk', '150200'),
  
  (361, '150202', 'Donghe District', '150200' ),
  
  (362 , '150203', 'Kundulun District', '150200'),
  
  (363, '150204', 'Qingshan District', '150200'),
  
  (364, '150205', 'Shiguai District', '150200'),
  
  (365, '150206', 'Baiyun Mining District', '150200'),
  
  (366, '150207', 'Jiuyuan District', '150200'),
  
  (367, '150221', 'Tumut Right Banner', '150200 '),
  
  (368, '150222', 'Guyang County', '150200'),
  
  (369 , '150223' , 'Darkhan Maoming'an United Banner', '150200'),
  
  (370, '150301', 'Municipal District', '150300'),
  
  (371, '150302', 'Haibo Bay District', '150300'),
  
  (372, '150303', 'Hainan District', '150300 '),
  
  (373, '150304', 'Wuda District', '150300'),
  
  (374, '150401' , 'Gemeindebezirk', '150400'),
  
  (375, '150402', 'Hongshan District', '150400'),
  
  (376, '150403', 'Yuanbaoshan District', '150400'),
  
  (377, '150404', 'Songshan District', ' 150400'),
  
  (378, '150421', 'Aruhorqin Banner', '150400'),
  
  (379, '150422', 'Bahrain Left Banner ', '150400'),
  
  (380, '150423', 'Bahrain Right Banner', '150400'),
  
  ( 381, '150424', 'Linxi County', '150400'),
  
  (382, '150425', 'Keshiketeng Banner', '150400'),
  
  (383, '150426', 'Wengniute-Banner', '150400'),
  
  (384, '150428', 'Kalaqin-Banner', '150400 '),
  
  (385, '150429', 'Ningcheng County', '150400'),
  
  (386, '150430' , 'Aohan Banner', '150400'),
  
  (387, '150501', 'City Jurisdiction', '150500'),
  
  (388, '150502', 'Horqin District', '150500'),
  
  ( 389, '150521', 'Horqin-Flagge links in der Mitte', '150500'),
  
  (390, '150522', 'Horqin linke hintere Flagge', '150500'),
  
  (391, '150523', „Kailu County“, „150500“),
  
  (392, „150524“, „Kulun-Flagge“, „150500“),
  
  (393, '150525', 'Naiman-Flagge', '150500'),
  
  (394, '150526', 'Zalut-Banner', '150500'),
  
  (395, '150581', 'Holingol City', '150500'),
  
  (396, '150602', 'Dongsheng District', '150600'),
  
  (397, '150621', 'Dala-Sonderflagge', '150600'),
  
  (398, '150622', 'Zhungar-Banner', '150600'),
  
  (399, '150623', 'Etuoke-Banner', '150600'),
  
  (400, '150624', 'Etuoke Banner', '150600 '),
  
  (401, '150625', 'Hang Jinqi', '150600') ,
  
  (402, '150626' , 'Wushen-Banner', '150600'),
  
  (403, '150627', ' Yijinhuoluo Banner', '150600'),
  
  (404, '150701', 'Municipal District', '150700'),
  
  (405, '150702', 'Hailaer District', '150700' ),
  
  (406, '150721', 'Arong Banner', '150700'),
  
  (407, '150722', ' Molidawa Da'er Autonomous Banner', '150700'),
  
  (408, '150723', 'Oroqen Autonomes Banner', '150700'),
  
  (409, '150724', 'Ewenki Autonomes Banner', '150700'),
  
  (410, '150725', 'Chen Balhu Banner' ', '150700'),
  
  (411, '150726', 'New Balhu Left Banner', '150700') ,
  
  (412, '150727', 'New Barhu Right Banner', '150700'),
  
  (413, '150781' , 'Manzhouli City', '150700'),
  
  (414, '150782', 'Yakeshi City', '150700'),
  
  (415, '150783', 'Zhalantun City', '150700'),
  
  (416, '150784', 'Ergun City', '150700'),
  
  (417, '150785', 'Genhe City', '150700'),
  
  (418, '150801', 'Gemeindebezirk' , '150800 '),
  
  (419, '150802', 'Linhe District', '150800'),
  
  (420, '150821', 'Wuyuan County', '150800'),
  
  (421, '150822', 'Dengkou County', ' 150800' ),
  
  (422, '150823', 'Urad Front Banner', '150800'),
  
  (423, '150824' , 'Urad Middle Banner', '150800'),
  
  (424, '150825', 'Urad Back Banner', '150800'),
  
  (425, '150826', 'Hangjinhou-Banner', '150800'),
  
  (426, '150901', 'Gemeindebezirk', ' 150900'),
  
  (427, '150902', 'Jining District', '150900'),
  
  (428, ' 150921', 'Zhuozi County', '150900'),
  
  (429, '150922', 'Huade County', '150900'),
  
  ( 430, '150923', 'Shangdu County', '150900'),
  
  (431, '150924', 'Xinghe County', '150900 '),
  
  (432, '150925', 'Liangcheng County', '150900'),
  
  (433, '150926 ', 'Chahar Right Front Flag', '150900'),
  
  (434, '150927', 'Chahar Right Center Flag', '150900'),
  
  (435 , '150928', 'Chahar Right Rear Flag', '150900'),
  
  (436, '150929' , 'Siziwang Banner', '150900'),
  
  (437, '150981', 'Fengzhen City', '150900'),
  
  (438, '152201', 'Ulanhot City', ' 152200'),
  
  (439, '152202', 'Aershan City', '152200'),
  
  (440, '152221 ', 'Horqin Right Front Flag', '152200'),
  
  (441, '152222', ' Horqin Right Center Banner', '152200'),
  
  (442, '152223', 'Zhalaite Banner', '152200'),
  
  (443, '152224', 'Tuquan County', '152200 '),
  
  (444, '152501', 'Erenhot City', '152500') ,
  
  (445, '152502' , 'Xilinhot City', '152500'),
  
  (446, '152522', ' Abaga Banner', '152500'),
  
  (447, '152523', 'Sunit Left Banner', '152500'),
  
  (448, '152524', 'Sunit Right Banner', '152500'),
  
  (449, '152525', 'Eastern Ujimqin flag', '152500'),
  
  (450, '152526', ' West-Ujimqin-Banner‘, ‚152500‘),
  
  (451, ‚152527‘, ‚Taipu-Tempelflagge‘, ‚152500‘),
  
  (452, '152528', 'Xianhuang-Flagge', '152500'),
  
  (453, '152529', 'Weiße Flagge', '152500'),
  
  (454, '152530', 'True Blue' flag', '152500'),
  
  (455, '152531', 'Duolun County“, „152500“),
  
  (456, „152921“, „Alxa Left Banner“, „152900“),
  
  (457, '152922', 'Rechtes Alxa-Banner', '152900'),
  
  (458, '152923', 'Ejina-Banner', '152900'),
  
  (459, '210101', 'Stadtgerichtsbarkeit', '210100'),
  
  (460, '210102', 'Heping District', '210100'),
  
  ( 461, '210103', 'Chenhe District', '210100'),
  
  (462, ' 210104', 'Bezirk Dadong', '210100'),
  
  (463, '210105', 'Bezirk Huanggu', '210100'),
  
  (464, '210106', 'Bezirk Tiexi', '210100'),
  
  (465, '210111', 'Bezirk Sujiatun', '210100'),
  
  (466 , '210112', 'Donngling District', '210100'),
  
  (467, '210113', 'Xinchengzi Bezirk', '210100'),
  
  (468, '210114', 'Yuhong Bezirk', '210100'),
  
  ( 469, '210122', 'Liaozhong County', '210100'),
  
  (470, '210123', 'Kangping County', '210100'),
  
  (471, '210124', 'Faku County', '210100'),
  
  (472, '210181', 'Xinmin City', '210100 '),
  
  (473, '210201', 'Gemeindebezirk', '210200'),
  
  (474, '210202', 'Zhongshan District', '210200'),
  
  (475, '210203', 'Xigang District', '210200 ' ),
  
  (476, '210204', 'Bezirk Shahekou', '210200'),
  
  (477, '210211' , 'Ganjingzi District', '210200'),
  
  (478, '210212', 'Lushunkou District', '210200'),
  
  (479, '210213', 'Jinzhou District', '210200'),
  
  (480, '210224', 'Changhai County', '210200') ,
  
  (481, '210281', 'Wafangdian City', '210200'),
  
  (482, '210282' , 'Pulandian City', '210200'),
  
  (483, '210283', 'Zhuanghe City', '210200'),
  
  (484, ' 210301', 'Municipal District', '210300'),
  
  (485, '210302', 'Tiedong District', '210300'),
  
  (486, '210303', 'Bezirk Tiexi', '210300'),
  
  (487, '210304', 'Bezirk Lishan', '210300'),
  
  (488, '210311', 'Qianshan District', '210300'),
  
  (489, '210321', 'Taian Landkreis‘, ‚210300‘),
  
  (490, ‚210323‘, ‚Autonomer Landkreis Xiuyan Manchu‘, ‚210300‘),
  
  (491, '210381', 'Haicheng City', '210300'),
  
  (492, '210401', 'Municipal District', '210400'),
  
  (493, '210402', 'Xinfu District', '210400'),
  
  (494 , '210403', 'Dongzhou District', '210400'),
  
  (495, '210404', 'Wanghua District', '210400'),
  
  (496, ' 210411', 'Shuncheng District', '210400'),
  
  (497, '210421', 'Fushun County', '210400 '),
  
  (498, '210422', 'Autonomer Kreis der Mandschu Xinbin', '210400'),
  
  (499, ' 210423', 'Autonomer Kreis der Mandschu Qingyuan', ' 210400'),
  
  (500, '210501', 'Gemeindebezirk', '210500'),
  
  (501, '210502 ', 'Bezirk Pingshan', '210500'),
  
  (502, '210503', 'Bezirk Xihu', '210500') ,
  
  (503, '210504', 'Mingshan District', '210500'),
  
  (504, '210505', ' Nanfen District', '210500'),
  
  (505, '210521', 'Autonomer Kreis Benxi der Mandschu', '210500'),
  
  (506, '210522', ' Autonomer Kreis Huanren der Mandschu“, „210500“),
  
  (507, „210601“, „Von der Stadt verwalteter Bezirk“, „210600“),
  
  (508, '210602', 'Yuanbao District', '210600'),
  
  (509, '210603', 'Zhenxing District', '210600'),
  
  (510, '210604', 'Zhen'an District', '210600'),
  
  ( 511, '210624', „Autonomer Kreis Kandian Manchu“, „210600“),
  
  (512, „210681“, „Donggang City“, „210600“),
  
  (513, '210682', 'Stadt Fengcheng', '210600'),
  
  (514, '210701', 'Gemeindebezirk', '210700'),
  
  (515, '210702', 'Guta District', '210700'),
  
  (516, '210703', 'Linghe District ', '210700'),
  
  (517, '210711', 'Taihe District', '210700'),
  
  (518 , '210726', 'Heishan County', '210700'),
  
  (519, '210727', 'Yi County', '210700 '),
  
  (520, '210781', 'Linghai City', '210700'),
  
  (521, '210782 ', 'Bac Ninh City', '210700 '),
  
  (522, '210801', 'Gemeindebezirk', '210800'),
  
  (523, '210802' , 'Zhanqian District', '210800'),
  
  (524, '210803', 'Western District', '210800') ,
  
  (525, '210804', 'Bayuquan District', '210800'),
  
  (526, '210811', 'Laobian District', '210800'),
  
  (527, '210881', 'Gaizhou City', '210800'),