Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- $DB_DSN = 'mysql:host=matcha.antoinevideau.pro;dbname=matcha';
- $DB_USER = 'matcha';
- $DB_PASSWORD = 'CvTWtaVg2VYgJcur';
- try {
- $pdo = new PDO($DB_DSN, $DB_USER, $DB_PASSWORD);
- } catch (PDOException $e) {
- die ('Échec lors de la connexion : ' . $e->getMessage());
- }
- $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- if ($_POST) {
- $localid = $_POST['password'];
- $localemail = $_POST['email'];
- $query = $pdo->prepare("SELECT * FROM users WHERE password_digest = :password AND email = :email");
- -- ou --
- $query = $pdo->prepare("SELECT * FROM users WHERE password_digest = ? AND email = ?");
- $query->bindParam('password', $localemail, PDO::PARAM_STR);
- $query->bindParam('email', $localemail, PDO::PARAM_STR);
- $array = array($localid, $localemail);
- $query->execute($array);
- $data = $query->fetch();
- if ($data) {
- $_SESSION['user_id'] = $data['id'];
- }
- }
- ?>
- SESSION : <?php echo $_SESSION['user_id']; ?>
- <form class="" action="" method="post">
- <input type="text" name="password" placeholder="password" value="">
- <input type="text" name="email" placeholder="email" value="">
- <input type="submit">
- </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement