/**
* @return Survey[]
*/
public static function getSurveys()
{
$db = DB::getConn();
$stm = $db->prepare('select * from Survey');
$stm->execute();
$rss = $stm->fetchAll();
$arr = [];
foreach ($rss as $rs) {
if ($rs['show'] == 1) {
$q = new Survey($rs['title'], 1);
$q->setId($rs['id']);
$q->setPercent(SurveyCtrl::getPercent($rs['id']));
$q->setCount(SurveyCtrl::getVotedNumber($rs['id']));
$arr[] = $q;
}
}
return $arr;
}
<?php
/**
* Created by PhpStorm.
* User: JayDz
* Date: 15/07/15
* Time: 2:54 PM
*/
require_once './controller/SurveyCtrl.php';
require_once './model/Survey.php';
//echo '<br><br><br><br>';
foreach ($_POST as $key => $value) {
// echo $key.': '.$value.'<br>';
if ($key == 'id') {
$title = $_POST['title'];
$show = $_POST['show'] == 'on' ? 1 : 0;
$s = new Survey($title);
$s->setShow($show);
$s->setId($value);
SurveyCtrl::update($s);
echo 'okkkk';
}
}
/**
* Construit un tableau de sondages à partir d'un tableau de ligne de la table 'surveys'.
* Ce tableau a été obtenu à l'aide de la méthode fetchAll() de PDO.
*
* @param array $arraySurveys Tableau de lignes.
* @return array(Survey)|boolean Le tableau de sondages ou false si une erreur s'est produite.
*/
private function loadSurveys($arraySurveys) {
$surveys = array();
foreach($arraySurveys as $row){
$survey = new Survey($row['owner'], $row['question']);
$survey->setId($row['ID']);
$surveys[] = $survey;
}
return $surveys;
}
