if (isset($eleves[$i]["scolarite_an_dernier"]["code_commune_insee"])) {
if ($cpt_debut_requete > 0) {
$sql .= ", ";
}
// *****************************************
// PROBLEME: code_commune_insee!=code_postal
// *****************************************
$sql .= "cp='" . mysqli_real_escape_string($GLOBALS["mysqli"], maj_min_comp($eleves[$i]["scolarite_an_dernier"]["code_commune_insee"])) . "'";
$cpt_debut_requete++;
}
// COMMUNE
if (isset($eleves[$i]["scolarite_an_dernier"]["ll_commune_insee"])) {
if ($cpt_debut_requete > 0) {
$sql .= ", ";
}
$sql .= "ville='" . mysqli_real_escape_string($GLOBALS["mysqli"], maj_min_comp($eleves[$i]["scolarite_an_dernier"]["ll_commune_insee"])) . "'";
$cpt_debut_requete++;
}
//echo "$sql<br />";
$res_insert_etab = mysqli_query($GLOBALS["mysqli"], $sql);
if (!$res_insert_etab) {
echo "<span style='color:red'><strong>Erreur lors de la requête</strong> {$sql}</span><br />\n";
$nb_err_etab++;
flush();
} else {
$stat_etab++;
}
}
}
}
}
/*
if(isset($eleves[$i]["scolarite_an_dernier"]["code_commune_insee"])){
echo $eleves[$i]["scolarite_an_dernier"]["code_commune_insee"];
$chaine.=$eleves[$i]["scolarite_an_dernier"]["code_commune_insee"];
}
else{
*/
echo " ";
//}
echo "</td>\n";
$chaine .= ";";
// COMMUNE
echo "<td>";
if (isset($eleves[$i]["scolarite_an_dernier"]["ll_commune_insee"])) {
echo maj_min_comp($eleves[$i]["scolarite_an_dernier"]["ll_commune_insee"]);
$chaine .= maj_min_comp($eleves[$i]["scolarite_an_dernier"]["ll_commune_insee"]);
} else {
echo " ";
}
echo "</td>\n";
$chaine .= ";";
echo "</tr>\n";
}
$chaine = mb_substr($chaine, 0, strlen($chaine) - 1);
fwrite($fich, $chaine . "\n");
}
}
//}
$i++;
}
echo "</table>\n";
