<?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();
foreach ($listeQPrev as $question) {
?>
<option selected="selected" name="answers<?php
echo $question['id'];
?>
" value="<?php
echo $question['id'];
?>
" stud_name ="<?php
echo $question['question'];
?>
">
<?php
<?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;
?>
</div>
<div class="container panel-body">
<form class="form-horizontal" role="form" method="post" action="../creationPDF/createurPDF.php" >
Nom du client : <input type="text" name="client"/>
<!--Tu affiches la question-->
<div id='question1' class="question-container contenu media-body">
<div class="questionDyn media-heading">
<?php
echo "<h4>" . $question["question"] . "</h4>";
?>
</div>
<!--Tu me liste ses réponses-->
<?php
$Rep = $forms->runQuery("SELECT id, reponse, nextQuestionId, classe FROM answers WHERE questionId=" . $question['id'] . " AND classe = 1");
$Rep->bindParam(':question["id"]', $question['id'], PDO::PARAM_INT);
$Rep->execute();
$reprow = $Rep->fetchAll();
$Rep2 = $forms->runQuery("SELECT id, reponse, nextQuestionId, classe FROM answers WHERE questionId=" . $question['id'] . " AND classe = 2");
$Rep2->bindParam(':question["id"]', $question['id'], PDO::PARAM_INT);
$Rep2->execute();
$reprow2 = $Rep2->fetchAll();
$Rep3 = $forms->runQuery("SELECT id, reponse, nextQuestionId, classe FROM answers WHERE questionId=" . $question['id'] . " AND classe = 3");
$Rep3->bindParam(':question["id"]', $question['id'], PDO::PARAM_INT);
$Rep3->execute();
$reprow3 = $Rep3->fetchAll();
?>
<!--Tu m'affiches ses réponses-->
<div class="reponseDyn">
<select id="data-secteur" class="col-md-7 col-xs-8 col-sm-8 col-lg-7 selectpicker" data-show-subtext="true" data-live-search="true">
<?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">
