session_start();
// Authetification
include "./espaces/inc/public.inc";
if (isset($_POST['test']))
{
$conn = mysql_connect($db_hostname, $db_user, $db_pass);
if (!$conn) {
echo 'Pb de connexion a la base';
}
if (!mysql_select_db($db_name, $conn)) {
echo 'Pb de selection de la base';
}
//filtrage par section pour le simulateur
$esse=array(21,20,18);
$eu_esse=array(19,22,23);
$strSQL = "SELECT etat.cle, etat.nom, etat.prenom, etat.email_el, classe.nom AS classe,etat.section,classe.cle AS cle_classe FROM (etat INNER JOIN classe ON etat.classe = classe.cle) WHERE etat.id_pass = '".$_POST['id_eleve']."' AND etat.el_pass = '".$_POST['pwd_eleve']."'";
if($_POST['id_eleve'] == 'sebann'){ echo $strSQL."
";}
$req_verif_select = mysql_query($strSQL, $conn);
$data = mysql_fetch_array($req_verif_select);
echo $data['cle']."
";
if ($data['cle']) // Compte valide.
{
$_SESSION['UserCle'] = $data['cle'];
$_SESSION['UserType'] = 'eleve';
$_SESSION['UserPrenom'] = $data['prenom'];
$_SESSION['UserNom'] = $data['nom'];
$_SESSION['UserMail'] = $data['email_el'];
$_SESSION['UserClasse'] = $data['classe'];
$_SESSION['UserClasseCle'] = $data['cle_classe'];
$_SESSION['UserMainMenu'] = 'eleve_menu.php';
if(array_search($data['section'],$esse)){
$_SESSION["niveau"]="S";
}else if(array_search($data['section'],$eu_esse)){
$_SESSION["niveau"]="ES";
}else{
$_SESSION["niveau"]=-1;
}
session_write_close();
header('Location: '.$localisation.'espaces/eleve_menu.php');
}
}
//else {
?>