BE/Inscription.php at main · IlyasLilus/BE · GitHub

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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
<?php
session_start();
if (isset($_POST["submit"])) {
    $host = 'localhost';
    $db = 'Compte';
    $user = 'postgres';
    $pass = '123';
    $port = '5432';
    $username = $_POST["username"];
    $mail = $_POST["mail"];
    $password1 = $_POST["password1"];
    $password2 = $_POST["password2"];
    $dsn = "pgsql:host=$host;port=$port;dbname=$db";
    $role = "user";
    try {
        $pdo = new PDO($dsn, $user, $pass);
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        // Vérifier si l'email existe déjà
        $sql_check_email = "SELECT * FROM Utilisateur WHERE adressemail = ?";
        $stmt_check_email = $pdo->prepare($sql_check_email);
        $stmt_check_email->execute([$mail]);

        if ($stmt_check_email->rowCount() > 0) {
            echo '<p class="erreur">Un compte avec cet email existe déjà.</p>';
        } else {
            if ($password1 != $password2) {
                echo '<p class="erreur">Les mots de passe ne correspondent pas.</p>';
            } else {
                $sql = "INSERT INTO Utilisateur (Pseudonyme, Userpassword, adressemail, Userrole) VALUES (?, ?, ?, ?)";
                $stmt = $pdo->prepare($sql);

                // Exécution de la requête avec les valeurs récupérées à partir de $_POST
                $stmt->execute([$username, $password1, $mail, $role]);
                session_destroy();
                echo '<p class="success">Votre compte est créé avec succès</p>';
                echo '<script>
                        setTimeout(function(){
                            window.location.href = "Connexion.php";
                        }, 3000);
                      </script>';
            }
        }
    } catch (PDOException $e) {
        echo "Erreur de connexion à la base de données : " . $e->getMessage();
    }
}
?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Inscription</title>
    <link rel="stylesheet" href="style/style_inscription.css">
    <link href="https://fonts.googleapis.com/css2?family=Poppins:wght@800&family=Teko:wght@300;600&display=swap" rel="stylesheet">
</head>

<body>

    <style>
        .success {
            color: greenyellow;
            position: absolute;
            font-weight: bold;
            font-size: 18px;
            top: 65%;
            right: 42%;
        }

        .erreur {
            color: red;
            position: absolute;
            font-weight: bold;
            font-size: 18px;
            top: 65%;
            right: 42%;

        }
    </style>
    <header class="header" id="header">
        <nav>
            <ul>
                <li class="go"><a href="Accueil.php">Accueil</a></li>
                <li class="go"><a href="Contact.php">Support</a></li>
                <li class="go"><a href="propos.php">About</a></li>

            </ul>
        </nav>
        <div class="cont-header">
            <div href=""><a href="Inscription.php"><img class="logo" src="image/netvision.png" alt=""></a></div>
            <button class="connexion"><a href="Connexion.php">Connexion</a></button>
            <button class="commencer"><a href="Inscription.php">S'inscrire</a></button>
        </div>
    </header>

    <h1 class="title">Bienvenue sur notre</h1>
    <h1 class="title2">Plateforme!</h1>


    <div class="container">
        <div class="formulaire">
            <form id="fom" action="" method="post">

                <div>
                    <input class="username" type="text" placeholder="Nom d'utilisateur" name="username" required>
                </div>
                <div>
                    <input class="date" type="email" name="mail" placeholder="Email" required>
                </div>
                <div>
                    <input class="password" placeholder="Mot de passe" name="password1" type="password" autocomplete="current-password" required>
                    <input type="password" name="password2" placeholder="confirmer votre mot de passe" name="passc" required>
                </div>

                <p class="membre">Déjà membre? <a class="connect" href="Connexion.php">Connectez Vous</a></p>
                <input type="submit" class="submit" name="submit" value="S'inscrire">
            </form>
        </div>
    </div>
    <footer>
        <div class="footer">
            <p>Copyright NetVision - Mention légal -Politique de confidentialité</p>
        </div>

    </footer>
</body>

</html>