<?php
function valide($Id,$conn)
{
	$query = "Select NumPersonne, DATEDIFF(minute,GetDate(), Date_Fin) as Valide from Sessions where IDSession='ID=".$Id."'";
	$succ = odbc_exec($conn,$query);
	if (!(odbc_fetch_row($succ))) return 0 ; 
	else 
	{
		$Code=odbc_result($succ,1);
		if (odbc_result($succ,2)<0) header("Location: default.htm");
		return $Code;
	}
}
function User($Id,$conn)
{
	$query = "Select Type from Sessions where IDSession='ID=".$Id."'";
	$succ = odbc_exec($conn,$query);
	if (!(odbc_fetch_row($succ))) return 0 ; 
	else 
	{
		$Type=odbc_result($succ,1);
		return $Type;
	}
}
$host = "IUT";
$user = "sa";
$password = "123go!";  
$conn = odbc_connect($host,$user,$password) or die ("raté");
if (!isset($ID)) header("Location: default.htm");
$CodePers=Valide($ID,$conn);

?>
