File manager

File manager - Edit - /home/missmand/public_html/learning/maia/questionnaire.php

Back
<?php include '../lib/init.php'; Utilisateur::verif_connect(); /* Déclaration des variables / $type = 5; / Attention à bien modifier cette variable à l'ajout d'un nouveau type de formation / $formationId = Tool::getId($_GET['formation'],'../formation/formation.php'); Auth::formationAuth($bdd,$formationId, $type); / Verification de l'accès à la formation / $utilisateurId = $_SESSION['utilisateur']['id']; $erreur = array(); / Information sur la formation / $sql = $bdd->query("SELECT maiaNom, maiaQuestionnaire FROM formation_maia WHERE maiaId = $formationId "); $data = $sql->fetchObject(); $nomFormation = $data->maiaNom; $questionnaireId = $data->maiaQuestionnaire; / Récéption du formulaire / if(isset($_POST['add'])){ / Supprimer la derniére entrée du tableau / $unset = end(array_keys($_POST)); unset($_POST[$unset]); $count = 1; foreach ($_POST as $key => $value) { if(empty($value)) array_push($erreur, questionnaireErreurNumero.$count); $count ++; } if(empty($erreur)){ //Ajout en BDD foreach ($_POST as $key => $value) { $sql = $bdd->query("SELECT FROM questionnaire_question WHERE questionId = $key "); $data = $sql->fetchObject(); $question = $data->questionQuestion; $sql = $bdd->prepare("INSERT INTO questionnaire_reponse (reponseCreated, reponseUtilisateur, reponseFormation, reponseType, reponseQuestion, reponseReponse) VALUES (:created, :utilisateur, :formation, :type, :question, :reponse) "); $sql->execute(array( "created" => time(), "utilisateur" => $utilisateurId, "formation" => $formationId, "type" => $type, "question" => $question, "reponse" => $value ) ); } /* Mise à jour de l'etat de la formation / Formation::updateEtat($bdd, 2, $formationId, $type); //Redirection setFlash(questionnaireSucces); header('location:'.BASEFRONT.'formation/formation.php'); } } ?> <!doctype html> <html lang="fr"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=320"> <meta name="viewport" content="width=device-width; initial-scale=0.8; maximum-scale=0.8;"> <title><?php echo questionnaireTitle ?></title> <link rel="icon" type="image/png" href="<?php echo BASEFRONT ?>img/favicon.png" /> <link href="<?php echo BASEFRONT ?>css/reset.css" rel="stylesheet" type="text/css" /> <link href="<?php echo BASEFRONT ?>css/template.css" rel="stylesheet" type="text/css" /> <link href="<?php echo BASEFRONT ?>css/questionnaire.css" rel="stylesheet" type="text/css" /> <link href="<?php echo BASEFRONT ?>css/mobile.css" rel="stylesheet" type="text/css" /> <link href='http://fonts.googleapis.com/css?family=Open+Sans:300italic,400italic,600italic,700italic,400,300,600,700,800' rel='stylesheet' type='text/css'> <!--[if lt IE 9]> <script src="<?php echo BASEFRONT ?>js/html5.js"></script> <![endif]--> </head> <body> <div id="main"> <?php / Menu principal / include '../include/menu.php'; ?> <div id="conteneur"> <header id="header"> <div id="btnMenu"></div> <ul id="retour"> <li><a href="<?php echo BASEFRONT ?>maia/afficheFormation.php?formation=<?php echo $formationId ?>"><?php echo questionnaireRetourRevenir.$nomFormation ?></a></li> <li class="separation"> \| </li> <li><?php echo questionnaireRetour ?></li> </ul> <?php include '../include/portrait.php'; ?> </header> <?php if(!empty($erreur)){ echo'<div id="erreur" class="big">'; echo Tool::afficheErreur($erreur); echo'</div>'; } ?> <div id="contenu"> <h2><?php echo questionnaireTitre ?></h2> <div id="questionnaire"> <?php $sql = $bdd->query("SELECT FROM questionnaire_question WHERE questionQuestionnaire = $questionnaireId AND questionEtat = 1 ORDER BY questionId ASC "); /* si il y'a des questions/ if($sql->rowCount() != 0){ / Formulaire dynamique du questionnaire / echo'<form action="#" method="post">'; while($data = $sql->fetchObject()){ if(isset($_POST[$data->questionId])) $value = $_POST[$data->questionId]; else $value = ''; echo '<label> - '.$data->questionQuestion.'</label>'; echo '<textarea name="'.$data->questionId.'">'.$value.'</textarea>'; } echo'<div class="clear"></div>'; / Boutons en bas du formulaire / echo'<div id="btnBottom">'; echo '<a href="'.BASEFRONT.'maia/afficheFormation.php?formation='.$formationId.'" id="btnRetour">'.questionnaireRetourFormation.'</a>'; echo '<input type="submit" value="'.questionnaireTerminer.'" name="add" id="btnSubmit">'; echo'</div>'; echo'</form>'; / si il y'a aucune question */ }else{ echo'<p class="empty">'.questionnaireEmpty.'</p>'; } ?> </div> <div class="clear"></div> </div> </div> </div> <script type="text/javascript" src="<?php echo BASEFRONT ?>js/jquery.js"></script> <script type="text/javascript" src="<?php echo BASEFRONT ?>js/jquery-ui.js"></script> <script type="text/javascript" src="<?php echo BASEFRONT ?>js/template.js"></script> <script type="text/javascript" src="<?php echo BASEFRONT ?>js/turbo.js"></script> <script type="text/javascript" src="<?php echo BASEFRONT ?>js/script.js"></script> </body> </html>

| ver. 1.4 | Github | . | PHP 7.4.33 | Generation time: 0 | proxy | phpinfo | Settings