destoon8.0批量循环查询地区插件

<?php
require './common.inc.php';

// 循环areaid从1到34
for ($areaid = 1; $areaid <= 34; $areaid++) {
    $result = $db->query("SELECT arrchildid, areaname FROM ktcms_area WHERE areaid = {$areaid}");
    $r = $db->fetch_array($result);
    
    // 检查是否存在该地区数据
    if ($r) {
        $arrchildid = $r['arrchildid'];
        $areaname = $r['areaname'];
        
        // 拆分ID为数组
        $idArray = explode(',', $arrchildid);
        foreach ($idArray as $id) {
            // 跳过空值
            if (empty($id)) continue;
            
            $resultid = $db->query("SELECT areaname, parentid FROM ktcms_area WHERE areaid = {$id}");
            $rid = $db->fetch_array($resultid);
            
            if ($rid) {
                $district = $rid['areaname']; 
                // 输出更新SQL语句
                //echo "UPDATE ktcms_company SET areaid = {$id} WHERE address LIKE '%{$district}%' AND business LIKE '%{$areaname}%';\n";
				if ($district!==$areaname) {
					echo "UPDATE ktcms_company SET areaid = {$id} WHERE address LIKE '%{$district}%' AND address LIKE '%{$areaname}%';\n";
				}
				//echo "UPDATE ktcms_company SET areaid = {$id} WHERE address LIKE '%{$district}%' AND company LIKE '%{$areaname}%';\n";
				//echo "UPDATE ktcms_company SET areaid = {$id} WHERE address LIKE '%{$district}%';\n";
				//echo "UPDATE ktcms_company SET areaid = {$id} WHERE address LIKE '%{$district}%' AND company LIKE '%{$district}%';\n";
            }
        }
    }

   //echo "UPDATE ktcms_company SET areaid = {$id} WHERE address LIKE '%$areaname%' AND company LIKE '%$areaname%';\n";
   //echo "UPDATE ktcms_company SET areaid = {$id} WHERE address LIKE '%$areaname%';\n";

}
?>

　　用处为批量生成根据地区id，查询公司地址对应地区

效果如下：学校查询平台 - 涵盖全学段学校信息，按地区快速查找