require_once("connection.PHP");
$sql = "INSERT INTO results (id,swim_rank) VALUES ";
for ($i = 0; $i < 7; $i++) {
$sql .= "('".$id1[$i]."','".$timeRank1[$i]."'),";
}
$sql = rtrim($sql, ',');
// run your query here
您还会注意到,我将您对数据库连接的包含移到了循环之外。无需重复拨打该电话。