<?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>