<?php require_once $_SERVER["DOCUMENT_ROOT"] . "/php/init.php"; Security::demand(ADMIN); $smarty = new AdminSmarty(); $smarty->assign("pagetitle", "proquiz"); // hämta alla MinaQuiz som har användarID 0 $MinaQuiz = MinaQuiz::listAsArray(0); foreach ($MinaQuiz as $key => $quiz) { $MinaQuiz[$key]['fragor'] = MinaQuiz::getQuestions($quiz['id']); } $smarty->assign("isAgare", true); $smarty->assign("egensida", "1"); $smarty->assign("proquiz", $MinaQuiz); $smarty->assign("x", 0); $smarty->assign("show", false); $smarty->assign('visa_antal_fragor', 3); $smarty->display('proquiz.tpl');
public static function listAsArray($medlem, $order_by = "namn ASC") { global $db; $medlem_id = is_int($medlem) ? $medlem : $medlem->getId(); $minaquiz = $db->allValuesAsArray("\tSELECT\n\t\t\t\t\t\t\t\t\t\t\t*\n\t\t\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\t\t\tmm_minaquiz\n\t\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\tmedlem_id = '" . $medlem_id . "'\n\t\t\t\t\t\t\t\t\t\tORDER BY\n\t\t\t\t\t\t\t\t\t\t\t{$order_by}\n\t\t"); foreach ($minaquiz as $id => $quiz) { $fragor = MinaQuiz::getQuestions($id); $minaquiz[$id]['fragor'] = $fragor; $minaquiz[$id]['antal_fragor'] = count($fragor); } return $minaquiz; }