<?php
require_once "../librairies/user.php";
$questionNext = new QUESTION();
$stmt = $questionNext->runQuery("SELECT q.id, q.question FROM questions AS q, answers AS a WHERE a.nextQuestionId = q.id AND a.id=" . $_POST["repId"]);
$stmt->execute();
$question = $stmt->fetch();
$stmt2 = $questionNext->runQuery("SELECT id, reponse, nextQuestionId FROM answers WHERE questionId=" . $question['id']);
$stmt2->bindParam(':question["id"]', $question['id'], PDO::PARAM_INT);
$stmt2->execute();
$reprow = $stmt2->fetchAll();
$question['reprow'] = $reprow;
echo json_encode($question);
return $reprow;
exit;
?>
<?php
require "../librairies/user.php";
$recupform = new QUESTION();
$question = $recupform->getQuestion(1);
?>
<!DOCTYPE>
<html>
<?php
include 'headerQuestion.php';
?>
<body>
<?php
include 'navbarAdmin.php';
?>
<div class ="row row-centered signin-form question">
<div class="col-lg-8 col-md-8 col-xs-8 col-sm-8 col-lg-6 col-centered">
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title">Ajout de question dans le formulaire</h3>
</div>
<div class="container panel-body">
<form class="form-horizontal" role="form" method="post" id="ajout_question" action="questionAjout.php">
<div class="question_precedente question-container">
<p>Question précédente :</p>
<select id='questionSelect' name='questionPrevious' size='1' class="col-md-7 col-xs-8 col-sm-8 col-lg-7 selectpicker" data-show-subtext="true" data-live-search="true">
<?php
$stmt = $recupform->runQuery("SELECT question,id FROM questions");
$stmt->execute();
$listeQPrev = $stmt->fetchAll();
<?php
require "../librairies/user.php";
$recupform = new QUESTION();
echo " <p>question precedante:</p><form>";
echo "<SELECT name='questionPrevious' size='1'>";
$stmt = $recupform->runQuery("SELECT question,id FROM questions");
$stmt->execute();
$listeQPrev = $stmt->fetchAll();
foreach ($listeQPrev as $question) {
echo "<option value=" . $question[1] . ">" . $question[0] . "</option>";
}
echo "</select>";
echo "<p>Champ de la questions ?</p>";
echo "<input type='text' name='question' />";
echo " <p>question suivante:</p><form>";
echo "<SELECT name='questionNext' size='1'>";
$stmt = $recupform->runQuery("SELECT question,id FROM questions WHERE");
$stmt->execute();
$listeQ = $stmt->fetchAll();
foreach ($listeQ as $question) {
echo "<option value=" . $question[1] . ">" . $question[0] . "</option>";
}
echo "</select>";
echo "</form>";
<?php
require_once '../librairies/user.php';
$forms = new QUESTION();
$user = new USER();
$question = $forms->getQuestion(1);
$score = $forms->getScore(106);
if (isset($_POST['btn-sub'])) {
$uname = strip_tags($_POST['client']);
if ($uname == "") {
$error[] = "Il manque le nom du client !";
} else {
try {
/*if ($user->addClient($uname, $upass, $ustatut)) {
$user->redirect('creerUser.php?joined');
}*/
} catch (PDOException $e) {
echo $e->getMessage();
}
}
}
?>
<html>
<?php
include 'headerQuestion.php';
?>
<body>
<?php
include 'navbarUser.php';
?>
<div class ="row row-centered signin-form question">
<?php
require_once "../librairies/user.php";
$questionNext = new QUESTION();
extract($_POST);
$stmt = $questionNext->runQuery("INSERT INTO questions(question) VALUES (:question_add)");
$stmt->bindparam(":question_add", $_POST['question_add']);
$stmt = $questionNext->runQuery("INSERT INTO answers(questionId, reponse, nextQuestionId) VALUES (:question_add)");
$stmt->bindparam(":question_add", $_POST['question_add']);
$stmt->execute();
<?php
require 'tfpdf.php';
require "../librairies/user.php";
$recupform = new QUESTION();
$pdf = new tFPDF();
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->AddFont('DejaVu', '', 'DejaVuSansCondensed.ttf', true);
$score = 0;
$scoreMax = 0;
$scoreTempQuestion = 0;
$classScore = 1;
//recuperation id max dans la bdd questions
$stmt = $recupform->runQuery("SELECT id FROM questions ORDER BY id DESC LIMIT 1");
$stmt->execute();
$liste = $stmt->fetch();
$idmax = $liste[0];
extract($_POST);
$answerClasse = $_POST["secteur"];
$stmt = $recupform->runQuery("SELECT question FROM questions WHERE id = 1");
$stmt->execute();
$liste = $stmt->fetch();
$question = $liste[0];
$stmt2 = $recupform->runQuery("SELECT reponse FROM answers WHERE id={$answerClasse}");
$stmt2->execute();
$liste2 = $stmt2->fetch();
$reponse = $liste2[0];
$pdf->SetPoliceQuestion();
$pdf->Write(5, $question);
$pdf->Ln();
<?php
require_once "../librairies/user.php";
$auth_question = new QUESTION();
$stmt = $auth_question->runQuery("SELECT * FROM pdf ORDER BY updated_date");
$stmt->execute();
$sondages = $stmt->fetchAll();
?>
<!DOCTYPE>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="../bootstrap/css/bootstrap.min.css" rel="stylesheet" media="screen">
<link href="../bootstrap/css/bootstrap-theme.min.css" rel="stylesheet" media="screen">
<script type="text/javascript" src="../script/jquery.js"></script>
<link rel="stylesheet" href="../css/styleSign.css" type="text/css" />
<title>Liste des sondages</title>
</head>
<body>
<?php
include 'navbarAdmin.php';
?>
<div class ="row row-centered signin-form question">
<div class="container panel-body">
<table class="panel table table-responsive table-condensed table-bordered table-hover">
<caption class="panel-heading tab-panel panel-title text-center">
Liste des sondages
</caption>
<thead class="tab-panel panel-heading">
