/**
* Performs a SQL query and returns the fetched results
*
* @param string $sql
* @return array
*/
public function query($sql)
{
$res = $this->connection->query($sql);
if ($res === false) {
return array();
}
$rows = array();
foreach ($res as $row) {
$rows[] = $row;
}
return $rows;
}
require "config.php";
require "dbo_lib.php";
require "question.class.php";
require "myTinCanAPI.class.php";
$questions = array();
// We do not need the totals to show just one question
// $corrects = 0;
// $total = 0;
$page = 0;
if (!empty($_GET['page'])) {
$page = $_GET['page'];
}
$dbo = new DBO($servername, $username, $password, $dbname);
$sql = "SELECT * FROM questions";
$dbo->query($sql) or die($dbo->ShowError());
$num_questions = $dbo->emaitza_kopurua();
$sql = "SELECT * FROM questions LIMIT " . $page . ", 1";
$dbo->query($sql) or die($dbo->ShowError());
while ($questionDB = $dbo->emaitza()) {
$question = new question($questionDB);
$total++;
$qid = 'q' . $question->getId();
$answer = $_POST[$qid];
$passed = $question->isCorrect($answer);
// if ($passed) {
// $corrects++;
// }
$myTC = new MyTinCanAPI();
$myTC->createObject($question->getBefore());
$myTC->createActivityType($question);
