public static function GetQuestion($category)
{
$dbh = MySqlConnection::getInstance();
/** @var \PDOStatement $statement */
$statement = $dbh->prepare('SELECT * FROM mdl_question WHERE category = :cat AND qtype != "random" ORDER BY RAND() LIMIT 1');
$statement->bindParam(':quizid', $category);
$statement->setFetchMode(PDO::FETCH_ASSOC);
$statement->execute();
$question = $statement->fetch();
return Examen::instanceQuestion($question);
}
public function setAnswers($id)
{
$dbh = MySqlConnection::getInstance();
$query = "SELECT * FROM mdl_question_answers WHERE question = :id";
$statement = $dbh->prepare($query);
$statement->bindParam(':id', $id);
$statement->execute();
$statement->setFetchMode(PDO::FETCH_ASSOC);
$answers = $statement->fetchAll();
foreach ($answers as $answer) {
$this->answers[] = static::processAnswer($answer);
}
}
private static function getQuestion($id)
{
/** @var MySqlConnection $dbh */
$dbh = MySqlConnection::getInstance();
/** @var \PDOStatement $statement */
$statement = $dbh->prepare('SELECT * FROM mdl_question WHERE id = :id');
$statement->bindParam(':id', $id);
$statement->execute();
$_question = $statement->fetch();
if (is_array($_question)) {
return Examen::instanceQuestion($_question);
}
return null;
}
public static function getExamIndex($course_module_id)
{
$info = ConnectionInfo::create();
/** @var MySqlConnection $dbh */
$dbh = MySqlConnection::create($info);
/** @var \PDOStatement $statement */
$statement = $dbh->prepare('SELECT quiz.id FROM mdl_course_modules AS cmi JOIN mdl_quiz AS quiz ON quiz.id = cmi.instance WHERE cmi.id = :id');
$statement->bindParam(':id', $course_module_id);
$statement->setFetchMode(PDO::FETCH_ASSOC);
$statement->execute();
$result = $statement->fetchAll();
$result = reset($result);
return $result['id'];
}
private function getQuestions()
{
/** @var MySqlConnection $dbh */
$dbh = MySqlConnection::getInstance();
/** @var \PDOStatement $statement */
$statement = $dbh->prepare('SELECT questionid FROM ingles.mdl_quiz_slots WHERE quizid = :quizid');
$statement->bindParam(':quizid', $this->examen['id']);
$statement->setFetchMode(PDO::FETCH_ASSOC);
$statement->execute();
$_questions = $statement->fetchAll();
foreach ($_questions as $_question) {
$statement = $dbh->prepare('SELECT * FROM mdl_question WHERE id = :id');
$statement->bindParam(':id', $_question['questionid']);
$statement->execute();
$_question = $statement->fetch();
if (is_array($_question)) {
$_question = static::instanceQuestion($_question);
if ($_question instanceof QuestionInterface) {
$this->questions[] = $_question;
}
}
}
}
<?php
use Crayon\Database\ConnectionInfo;
use Crayon\Database\MySqlConnection;
use Crayon\Model\Examen;
include 'vendor/autoload.php';
include 'src/autoloader.php';
$connection_info = ConnectionInfo::create();
/** @var MySqlConnection $db */
$db = MySqlConnection::create($connection_info);
// Obtenemos los exámenes
$query = 'SELECT * FROM mdl_quiz';
$stmnt = $db->prepare($query);
$stmnt->setFetchMode(PDO::FETCH_ASSOC);
$stmnt->execute();
$examenes = $stmnt->fetchAll();
foreach ($examenes as $examen) {
$examenid = $examen;
/** @var Examen $_examen */
$examen = Examen::create($examen);
$_examen = $examen->json_dump();
$template = file_get_contents(__DIR__ . '/assets/html/Template.html');
$_examen = strtr($template, array('@json_data' => $_examen));
file_put_contents(__DIR__ . '/output/quiz' . $examen->examen['id'] . '.html', $_examen);
}
//// Inicializamos el cliente
//$scapper = new Goutte\Client();
//// Recordar settear COOKIE de autentificación.
//$scapper->setHeader('Cookie', COOKIE);
//$sections = array(3,4,5,6,7,8,9,10,11,12,14,15,16,17,18,19,20,21,22,23,25,26,27,28,29,30,31,32,33,34,36,37,38,39,40,41,42,43,44,45);
//foreach ($sections as $s) {
