<?php // Display Error ini_set('display_errors', 1); session_start(); // Require require 'data/Affichage.class.php'; require 'data/Questionnaire.class.php'; require 'data/Survey.class.php'; require 'data/User.class.php'; require_once 'data/Mysql.class.php'; // Connect to Database try { Database::openDB('questionnaire', 'root', 'root', 'localhost', 3306, 'mysql'); } catch (PDOException $e) { die('Erreur : ' . $e->getMessage()); } $affichage = new Affichage();
<?php require_once 'db.php'; $db = new Database(); $conn = $db->openDB(); if ($conn == null) { die; } $query = "SELECT guestid, guestname, isheadofhousehold, isconfirmed from guest where guestpassword = :guestpassword limit 1;"; $stmt = $conn->prepare($query); $guestpassword = $_POST['guestpassword']; $stmt->bindParam('guestpassword', $guestpassword); $stmt->execute(); $row = $stmt->fetch(); $loginSuccessful = $stmt->rowCount() == 1; $db->closeDB(); if ($loginSuccessful && session_start()) { $_SESSION['isLoggedIn'] = $loginSuccessful; $_SESSION['guestid'] = $row['guestid']; $_SESSION['isconfirmed'] = $row['isconfirmed']; $_SESSION['guestname'] = $row['guestname']; $_SESSION['isheadofhousehold'] = $row['isheadofhousehold']; // configuration options: $_SESSION['ENABLE_MEAL_SELECTION'] = false; //some users will not want meal selection as an RSVP option header('location:../welcome.php'); } else { // write to log-in attempt table on log-in failure $conn = $db->openDB(); $query = "INSERT INTO login_attempt (user_ip_address, guestpassword, login_attempt_date) VALUES (:user_ip_address, :guestpassword, now());"; $stmt = $conn->prepare($query);