<?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">