control_bd.php

  
 <?php
include("sql_connect.php");
$data =array();
//$requete = "SELECT * from test.users where email LIKE '".$_GET["username"]."' and pass LIKE '".$_GET["passwd"]."' ;";
$requete = "SELECT * from test.users where (pass = '".$_GET["passwd"]."' and email= '".$_GET["username"]."')";
$req = mysqli_query($conn, $requete) or die("SQL Error <br>".$requete."<br>".mysqli_error($conn));
if(mysqli_num_rows($req)){
    while($result = mysqli_fetch_assoc($req)){
        $data = $result;
    }
}
else{
    $success = 'no_account';
    header("location: /index.php?success=".$success);
}


// closing connection
$conn->close();
//echo 'username = '.$_GET["username"].' et password = '.$_GET["passwd"];
?>

<!DOCTYPE html>
<html>
<body>
        <div style="margin-left:25px">
            <h2><center>Profil :  </center></h2>
            <br><br>
            <hr>
            <h3>Welcome <?php echo $data["nom"]." ". $data["prenom"]; ?></h3>
            <br><br>
            <div>
                <label for="">Nom : </label>
                <span><?php echo $data["nom"]; ?></span>
            </div>
            <br>
            <div>
                <label for="">Prenom : </label>
                <span><?php echo $data["prenom"]; ?></span>
            </div>
            <br>
            <div>
                <label for="">email : </label>
                <span><?php echo $data["email"]; ?></span>
            </div>
            <br>
            <div>
                <label for="">Diplôme en cours : </label>
                <span><?php if(empty($data["diplome"])) echo "--Empty--"; else echo $data["diplome"]; ?></span>
            </div>
            <br>
            <div>
                <label for="">Ce dont tu rêves : </label>
                <span><?php if(empty($data["reve"])) echo "--Empty--"; else echo $data["reve"]; ?></span>
            </div>
            <br>
            <div>
            <br><br>
            <hr>
            <p><b>Disconnect</b></p>
            <button onclick="window.location.href='/index.php'">Disconnect</button>
        </div>


</body>
</html>