public function insert($post)
{
extract($post);
$ip = $_SERVER['REMOTE_ADDR'];
$verification = DATABASE::DB()->prepare("SELECT * FROM result WHERE ip = :id");
$verification->bindvalue(':id', $ip, PDO::PARAM_STR);
$verification->execute();
$correspondance = $verification->fetch();
if (!$correspondance) {
$query = "\n\t\t\tINSERT INTO result (\n\t\t\tip,question_1, question_2, question_3, question_4, question_5, question_6, \n\t\t\tquestion_7, question_8, question_9, question_10_1, question_10_2, question_10_3, \n\t\t\tquestion_11, question_12) \n\t\t\tVALUES (\n\t\t\t:ip,:question_1, :question_2, :question_3, :question_4, :question_5, :question_6, \n\t\t\t:question_7, :question_8, :question_9, :question_10_1, :question_10_2, :question_10_3, \n\t\t\t:question_11, :question_12)";
$insert = DATABASE::DB()->prepare($query);
$insert->bindvalue(':ip', $ip, PDO::PARAM_STR);
$insert->bindvalue(':question_1', $question_1, PDO::PARAM_STR);
$insert->bindvalue(':question_2', $question_2, PDO::PARAM_STR);
$insert->bindvalue(':question_3', $question_3, PDO::PARAM_STR);
$insert->bindvalue(':question_4', $question_4, PDO::PARAM_STR);
$insert->bindvalue(':question_5', $question_5, PDO::PARAM_STR);
$insert->bindvalue(':question_6', $question_6, PDO::PARAM_STR);
$insert->bindvalue(':question_7', $question_7, PDO::PARAM_STR);
$insert->bindvalue(':question_8', $question_8, PDO::PARAM_STR);
$insert->bindvalue(':question_9', $question_9, PDO::PARAM_STR);
$insert->bindvalue(':question_10_1', $question_10_1, PDO::PARAM_STR);
$insert->bindvalue(':question_10_2', $question_10_2, PDO::PARAM_STR);
$insert->bindvalue(':question_10_3', $question_10_3, PDO::PARAM_STR);
$insert->bindvalue(':question_11', $question_11, PDO::PARAM_STR);
$insert->bindvalue(':question_12', $question_12, PDO::PARAM_STR);
$insert->execute();
return $info = "GOOD";
} else {
return $info = "ERROR_IP";
}
}
public function connect($post)
{
extract($post);
$finalpass = base64_encode(sha1($password, true));
$select = DATABASE::DB()->prepare("SELECT * FROM users WHERE name = :name AND password = :password");
$select->bindvalue(':name', $username, PDO::PARAM_STR);
$select->bindvalue(':password', $finalpass, PDO::PARAM_STR);
$select->execute();
$correspondance = $select->fetch();
if ($correspondance) {
$_SESSION['login'] = '******';
$_SESSION['id'] = $correspondance['id'];
$_SESSION['name'] = $correspondance['name'];
$_SESSION['nb_survey'] = $correspondance['nb_survey'];
}
}
public function add_survey($post)
{
extract($post);
isset($choice_1) ? $choice_1 = $choice_1 : ($choice_1 = '');
isset($choice_2) ? $choice_2 = $choice_2 : ($choice_2 = '');
isset($choice_3) ? $choice_3 = $choice_3 : ($choice_3 = '');
isset($choice_4) ? $choice_4 = $choice_4 : ($choice_4 = '');
isset($choice_5) ? $choice_5 = $choice_5 : ($choice_5 = '');
$insert = DATABASE::DB()->prepare("INSERT INTO surveys (id_user, name, description, choice_1, choice_2, choice_3, choice_4, choice_5) VALUES (:id_user, :name, :description, :choice_1, :choice_2, :choice_3, :choice_4, :choice_5)");
$insert->bindvalue(':id_user', $_SESSION['id'], PDO::PARAM_INT);
$insert->bindvalue(':name', $name, PDO::PARAM_STR);
$insert->bindvalue(':description', $description, PDO::PARAM_STR);
$insert->bindvalue(':choice_1', $choice_1, PDO::PARAM_STR);
$insert->bindvalue(':choice_2', $choice_2, PDO::PARAM_STR);
$insert->bindvalue(':choice_3', $choice_3, PDO::PARAM_STR);
$insert->bindvalue(':choice_4', $choice_4, PDO::PARAM_STR);
$insert->bindvalue(':choice_5', $choice_5, PDO::PARAM_STR);
$insert->execute();
}
