<?php
	require(fonctions.php");
   	$host = "Bibli";
   	$user = "etd";
   	$password = "etd";  
   	$conn = odbc_connect($host,$user,$password) or die ("raté");
   	$Mdp = crypte($Mdp);
   	$query = "Select NumPersonne from Personnes where Nom ='".$Nom."' and MdP ='".$Mdp."'";
	$succ = odbc_exec($conn,$query);
	if (odbc_fetch_row($succ))
	{
		$Code = odbc_result($succ,1);
		$Loc = "Location: Page.php?";
		mt_srand((double)microtime()*100000000);
		$sessid = DecHex(mt_rand(0,mt_getrandmax()));
		$sessid = $sessid.DecHex(mt_rand(0,mt_getrandmax()));
		$sessid = $sessid.DecHex(mt_rand(0,mt_getrandmax()));
		$sessid = 'ID='.$sessid;
		$aujourdhui = getdate(time()+1200);
		$heure = $aujourdhui['hours'];
		$minute = $aujourdhui['minutes'];
		$seconde = $aujourdhui['seconds'];
		$mois = $aujourdhui['mon'];
		$mjour = $aujourdhui['mday'];
		$annee = $aujourdhui['year'];
		$fin = "$mjour/$mois/$annee $heure:$minute:$seconde";
		$query = "Insert into Sessions (IDSession,NumPersonne,Acces,Type,Date_Fin) values ('".$sessid."',".$Code.",'Valide','".$Type."','".$fin."')";
		$result = odbc_exec($conn,$query);
		$Loc = $Loc.$sessid;
		header($Loc);
	}
	else
	{
		header("Location: default.htm");
	}
?>