/** * @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; }