";
}*/
$titre="Importation de la liste des inscriptions";include("enTete.php");
$requete="INSERT INTO inscription (joueur, categorie) VALUES ";
include("conf.php");
include("mysql_compat.php");
include ("conf.php");
$db_connection=mysql_connect($db_host,$db_user,$password);
mysql_select_db($db_name,$db_connection);
$premier=1;
$au_moins_une=0;
$file_joueur=fopen($fichier,"r");
while (!feof ($file_joueur)) {
$buffer = fgets($file_joueur, 4096);
if ($buffer[0]!='*'){//on saute la liste des categories.
list($nom,$prenom,$inscription)=explode(";",$buffer);
$requete2="SELECT id_joueur FROM joueur WHERE UPPER(nom)=UPPER('".$nom."') AND UPPER(prenom)=UPPER('".$prenom."') ;";
$reponse2= mysql_query($requete2,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
");
$reptab2=mysql_fetch_array($reponse2);
for ($i=0;$i<32;$i++){
//echo $i."='".$inscription[$i]."'-->";
if ($categorie[$i] and $inscription[$i] and $['']){
$requete3="SELECT id_inscription FROM inscription WHERE joueur='".$['']."' AND categorie='".$categorie[$i]."' ;";
$reponse3= mysql_query($requete3,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
");
$reptab3=mysql_fetch_array($reponse3);
//echo $['']."
";
if (!$['']){
if (!$premier) {
$requete=$requete.", ";
}
$premier=0;
$au_moins_une++;
$insertion="('".$['']."','".$categorie[$i]."')";
//echo $insertion."
";
$requete=$requete.$insertion;
}
}
}
//echo "
";
}
}
fclose($file_joueur);
$requete=$requete.";";
//echo $requete;
if ($au_moins_une) $reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
");
mysql_close($db_connection);
echo "La liste des inscriptions a ete importee";
include("piedDePage.php");
?>