function get_question_type($id)
{
$bd = new mysqlObject(HOST, DB, USER, MDP);
$rep = $bd->select('select * from reponse where id_question = ' . $id . '');
if (count($rep) == 1) {
return $rep[0]->TYPE;
}
return TYPE_CHOIX_MULTIPLE;
}
function afficher_users()
{
$bd = new mysqlObject(HOST, DB, USER, MDP);
$user = $bd->select('select * from compte
where status != ' . ADMIN_NUM . ';');
echo '<div class="panel panel-primary">';
echo '<div class="panel-heading">';
echo '<h3> Liste utilisateur </h3>';
echo '</div>';
echo '<div class="list-group scrollable-menu">';
foreach ($user as $u) {
echo '<div class="list-group-item"> ';
echo $u->LOGIN;
echo '<a href="' . ROOT . '?action=' . DELETE_USER . '&id=' . $u->ID_USER . '" class="pull-right need_confirm">
<button class="badge">Supprimé</button></a>';
echo '</div>';
}
echo '</div>';
echo '</div>';
}
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/sondage/Model/mysql.php';
$bd = new mysqlObject(HOST, DB, USER, MDP);
$id_q = $_GET['ID'];
$name = "";
$val = $bd->select('select valeur, count(valeur) as c from statistique
where id_question = ' . $id_q . '
group by valeur;');
$q = $bd->select('select * from
question where id_question = ' . $id_q . ';');
$name = $q[0]->LIBELE;
$datas = "";
foreach ($val as $v) {
if ($datas == "") {
$datas = '["' . $v->valeur . '", ' . $v->c . ']';
} else {
$datas .= ',["' . $v->valeur . '", ' . $v->c . ']';
}
}
$series = '"series" : [{
"type": "pie",
"name": "stat question",
"data": [' . $datas . ']
}]';
echo '{
"title" : {
"text" : "' . $name . '"
},
' . $series . '
}';
function afficher_question_for_voter($id_s, $num_q)
{
$bd = new mysqlObject(HOST, DB, USER, MDP);
$sondage = $bd->select('select * from sondage where id_sondage = ' . $id_s . ';');
$question = $bd->select('select * from question where id_sondage = ' . $id_s . ' and num = ' . $num_q . ';');
if (count($sondage) == 0) {
$sondage_label = 'Erreur sondage inconnu';
} else {
$sondage_label = $sondage[0]->LIBELE;
}
if (count($question) == 0) {
$question_label = 'Erreur question inconnue';
} else {
$question_label = $question[0]->LIBELE;
}
?>
<div class="panel panel-primary">
<div class="panel-heading">
<h4><?php
echo $sondage_label;
?>
</h4>
</div>
<?php
if (count($question) == 0) {
echo '<div class="panel panel-body">
' . $question_label . '
</div>';
} else {
afficher_liste_reponse_for_voter($question[0]);
}
?>
</div>
<?php
}
function open_close_sondage($id)
{
if (!isset($_SESSION[CONNECTED])) {
return ERROR_NOT_CONNECTED;
}
if (!is_numeric($id)) {
return ERROR_CORRUPTED_DATA;
}
$bd = new mysqlObject(HOST, DB, USER, MDP);
$req = 'select * from sondage
where id_sondage = ' . $id . ' and
id_user = '******';';
$s = $bd->select($req);
if (count($s) != 1) {
return ERROR_NOT_YOUR_SONDAGE;
}
if ($s[0]->STATUS == OPEN) {
$stat = CLOSE;
} else {
$stat = OPEN;
}
$req = 'update sondage set status = ' . $stat . '
where id_sondage = ' . $s[0]->ID_SONDAGE . ';';
return $bd->execQuery($req);
}
