1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
| session_start();
include_once('cnx.php');
error_reporting(0);
if(!empty($_POST["log"])&& !empty($_POST["mdp"]))
{
$mdp=($_POST["mdp"]);
$lg=($_POST["log"]);
$sql="select * from utilisateurs1 where login= '".$lg."' and motdepasse= '".md5($mdp)."'";
//$sql="select * from utilisateurs where login= '".$lg."' and m_pass= '".$mdp."'";
$params = array();
$options = array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
$stmt = sqlsrv_query( $conn, $sql, $params, $options);
$num = sqlsrv_num_rows($stmt);
$user = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC);
if($num!=0) {
if($user['type']=="mareyeur"){
$_SESSION["connect"] = true;
$_SESSION["nom"]=$user['nom'].' '.$user['prenom'];
header('location:espace_mareyeur.php');
}
elseif($user['type']=="dpm"){
$_SESSION["connect"] = true;
$_SESSION["nom"]=$user['nom'].' '.$user['prenom'];
header('location:espace_dpm.php');
}
elseif($user['type']=="admin"){
$_SESSION["connect"] = true;
$_SESSION["nom"]=$user['nom'].' '.$user['prenom'];
header('location:espace_admin.php');
}
}
else{
header('location:index.php?msg=1');
}
}
else{
header('location:index.php?msg=2');
} |