$areaArr = json_decode($area,true);
$id = 1;
$provinceL = count($areaArr['address']['province']);
$province = $areaArr['address']['province'];
for ($i=0; $i < $provinceL; $i++) {
$sql = 'INSERT INTO tb_area (id,name,pid,type,level) VALUES ('.$id.',"'.$province[$i]['name'].'",0,1,0);';
file_put_contents('area.sql',$sql."\r\n",FILE_APPEND);
$pid = $id;
$id ++;
$cityL = count($province[$i]['city']);
$city = $province[$i]['city'];
for ($j=0; $j < $cityL; $j++) {
$sql = 'INSERT INTO tb_area (id,name,pid,type,level) VALUES ('.$id.',"'.$city[$j]['name'].'",'.$pid.',2,1);';
file_put_contents('area.sql',$sql."\r\n",FILE_APPEND);
$pids = $id;
$id ++;
$countyL = count($city[$j]['county']);
$county = $city[$j]['county'];
for ($k=0; $k < $countyL; $k++) {
$sql = 'INSERT INTO tb_area (id,name,pid,type,level) VALUES ('.$id.',"'.$county[$k]['name'].'",'.$pids.',3,2);';
file_put_contents('area.sql',$sql."\r\n",FILE_APPEND);
$id ++;
}
}
}
