SQL-insert文の一括生成

";
$content = file_get_contents($file);
preg_match_all("/(\d+)\s/", $content, $multiIdPreg);
if (empty($multiIdPreg[1])) {
    exit('       ');
}

preg_match_all("/\[\[.*?\]\]/", $content, $preg);

$count = count($preg[0]);

foreach ($preg[0] as $key =?> &$value) {
    $value = trim($value);
    $sqlInfo = preg_replace("/\[(\d+\.\d+)\,(\d+\.\d+)\]/", '{"lng":${1},"lat":${2}}', $value);

    if (($count - 1) == $key) {
        $suffix = ";";
    } else {
        $suffix = ",
";
    }

    $sql .= "(" . $store_id . "," . $multiIdPreg[1][$key] . ',2,' . $fee . ',\'' . $sqlInfo . '\'' . ")" . $suffix;
}

file_put_contents($file, $sql);