File manager - Edit - /home/missmand/public_html/learning/evaluation/evaluation.php
Back
<?php include '../lib/init.php'; Utilisateur::verif_connect(); /* Déclaration des variables */ $utilisateurId = $_SESSION['utilisateur']['id']; Auth::roleAccesAuth(array(1,2,3,5)); /* Vérification de l'accès à l'auto évaluation */ $date = date("Y-m-d"); $succes = ''; /* 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]); $total = array_sum($_POST); $sql = $bdd->query("SELECT * FROM evaluation_reponse WHERE reponseUtilisateur = $utilisateurId AND reponseDate = '$date' "); if($sql->rowCount() != 0){ $data = $sql->fetchObject(); $reponseId = $data->reponseId; // Mise à jour de la BDD $sql2 = $bdd->prepare("UPDATE evaluation_reponse SET reponseTotal = :total WHERE reponseId = :reponseId "); $sql2->execute(array( "total" => $total, "reponseId" => $reponseId ) ); $succes = 'Évaluation modifiée avec succès'; }else{ // Insertion en BDD $sql2 = $bdd->prepare("INSERT INTO evaluation_reponse (reponseDate, reponseTotal, reponseUtilisateur) VALUES (:date, :total, :utilisateur) "); $sql2->execute(array( "date" => $date, "total" => $total, "utilisateur" => $utilisateurId ) ); $succes = 'Évaluation ajoutée avec succès'; } } ?> <!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 evaluationTitle ?></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/evaluation.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 ?>admin.php"><?php echo evaluationRetourTableau ?></a></li> <li class="separation"> | </li> <li><?php echo evaluationRetourEvaluation ?></li> </ul> <?php include '../include/portrait.php'; ?> </header> <?php if(!empty($succes)){ echo'<div id="succes" class="big">'; echo $succes; echo'</div>'; } ?> <div id="contenu"> <h2><?php echo evaluationTitreGraphique ?></h2> <div id="graphique"></div> <h2><?php echo evaluationTitreQuestionnaire ?></h2> <div id="questionnaire"> <form action="#" method="post"> <?php $sql = $bdd->query("SELECT * FROM evaluation WHERE evaluationLangue = '$langue' ORDER BY evaluationId "); while($data = $sql->fetchobject()){ echo'<label>'.$data->evaluationQuestion.'</label>'; echo'<input type="hidden" class="input" value="0" name="'.$data->evaluationId.'"/>'; echo'<div class="slider"></div>'; echo'<div class="legende">0 / 5</div>'; } ?> <input type="submit" name="add" id="btnSubmit" value="<?php echo evaluationSubmit ?>" /> </form> </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/script.js"></script> <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript"> /* Initialisation de google chart */ google.load("visualization", "1", {packages:["corechart"]}); google.setOnLoadCallback(drawChart); /* Graphique d'auto évaluation */ function drawChart() { var data = google.visualization.arrayToDataTable([ /* ici les informations du graphique */ <?php echo Graphique::evaluationGraph($bdd); ?> ]); var chart = new google.visualization.AreaChart(document.getElementById('graphique')); chart.draw(data); } /* Responsive */ $(window).resize(function(){ drawChart(); }); </script> </body> </html>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings