Example #1
0
<?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();
Example #2
0
<?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);