"Ecole","c"=>"Collège","l"=>"Lycée");
$clesetabs=array_keys($etabs);
$parts=array(
"m24"=>"Mardi 24 matin",
"a24"=>"Mardi 24 après-midi",
"m25"=>"Mercredi 25 matin",
"a25"=>"Mercredi 25 après-midi",
);
include("titres.php");
mysql_connect("localhost","ajaccio","spqr0797");
$title="Inscriptions Forum des Mathématiques Ajaccio 24-25 Mai 2011";
$enr=0;
$err=0;
$msg="";
$valider=$_POST["valider"];
if ($valider == "Valider")
{
// foreach ($_POST as $k => $v) echo "$k => $v
\n";
$nom=$_POST["nom"];
$prenom=$_POST["prenom"];
$mail=$_POST["mail"];
$tel=$_POST["tel"];
$etab=$_POST["etab"];
$niveau=$_POST["niveau"];
$nometab=$_POST["nometab"];
$ville=$_POST["ville"];
$nb=$_POST["nb"];
$conf=$_POST["conf"];
$comment=$_POST["comment"];
$jour="";
foreach ($parts as $j => $v)
{
$v=$_POST[$j];
if ($v == "on") $jour .= $j;
}
// verification
if (($nom == "") or ($etab =="") or ($jour == "") or (($mail =="") and ($tel ==""))) { $err=2; $msg="Renseignez les champs obligatoires *";}
// echo "$nom $prenom $etab $j
\n";
else
/*
if (!is_int($nb)) { $err=3; $msg="Entrez une valeur numérique correcte";}
else
*/
{
$dateinsc=date("Y-m-d H:i",time());
$sql="insert inscriptions (nom,prenom,mail,tel,etab,nometab,ville,niveau,nb,conf,jour,comment,dateinsc) ";
$sql .= "values (\"$nom\",\"$prenom\",\"$mail\",\"$tel\",\"$etab\",\"$nometab\",\"$ville\",\"$niveau\",\"$nb\",\"$conf\",\"$jour\",\"$comment\",\"$dateinsc\")";
// echo "$sql\n";
$res=mysql_db_query("ajaccio",$sql);
if ($msg=mysql_error()) $err=1;
}
if ($err == 0) $enr=1;
}
echo "\n";
echo "";
echo "";
echo "";
echo "\n";
echo "$title\n";
echo "\n";
echo "\n";
echo "$title
\n";
echo "Participation par demi-journée :
\n";
foreach ($parts as $cle => $val)
{
$resn=mysql_db_query("ajaccio","select sum(nb) from inscriptions where jour like \"%$cle%\"");
$lignen=mysql_fetch_array($resn);
$ne=$lignen[0];
echo "$val : $ne élèves
\n";
}
echo "\n";
if ($err != 0) echo "
$msg
\n";
if ($enr) echo "Inscription enregistrée
\n";
echo "\n";
?>