<?php


if(isset($_POST['submit'])){
    $servername="localhost";
    $username="root";
    $password="";
    $dbname="orphelins";

    $nom_d_utilisateur=$mot_de_pass=$passmd5='';

    $conn= mysqli_connect($servername,$username,$password,$dbname);

    if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
    }

    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $nom_d_utilisateur= $_POST["nom_d_utilisateur"];
        $mot_de_pass= $_POST["mot_de_pass"];

    }
    $passmd5=md5($mot_de_pass);


   $sql= "SELECT nom_d_utilisateur,mot_de_pass FROM user WHERE nom_d_utilisateur ='$nom_d_utilisateur' AND mot_de_pass='$mot_de_pass' ";
    $result = mysqli_query($conn, $sql);

    if ($result) {

        }else{
            die("database query failed".mysqli_error($conn));
        }


    if(mysqli_num_rows($result) > 0){
        $row = mysqli_fetch_assoc($result);
        session_start();
        $_SESSION['nom_d_utilisateur'] = $row["nom_d_utilisateur"];
        $_SESSION['mot_de_pass'] = $row["mot_de_pass"];
        $_SESSION['logged'] = TRUE;
        mysqli_close($conn);
        header("Location: admin.php"); // Modify to go to the page you would like
        exit;
    }
    else{

       header("Location: adherent.php");
        exit;
   }

    }
    else{    //If the form button wasn't submitted go to the index page, or login page
    header("Location: index.php");
    exit;

}
?>