public function __construct($userid, $connection, $dbPrefix) { $GLOBALS["dbPrefix"] = $dbPrefix; $set = null; $setid = -1; $questionid = -1; $answerid = -1; foreach ($connection->query('SELECT * FROM ' . $GLOBALS["dbPrefix"] . 'question_set WHERE ownerid="' . $userid . '"') as $setRow) { $set = new cardSet(s); $set->setSetId($setRow['setid']); $setid = $setRow['setid']; $set->setSetName($setRow['setname']); $set->setSetDescription($setRow['setdescription']); foreach ($connection->query('SELECT * FROM ' . $GLOBALS["dbPrefix"] . 'question_question WHERE ' . $GLOBALS["dbPrefix"] . 'question_question.set="' . $setid . '";') as $questionRow) { $question = new question(); $question->setId($questionRow['questionid']); $question->setQuestion($questionRow['question']); $question->setMode($questionRow['mode']); $question->setRightAnswered($questionRow['rightAnswered']); $question->setWrongAnswered($questionRow['wrongAnswered']); $questionid = $questionRow['questionid']; foreach ($connection->query('SELECT * FROM ' . $GLOBALS["dbPrefix"] . 'question_answer WHERE ' . $GLOBALS["dbPrefix"] . 'question_answer.ownerquestion=' . $questionid) as $answerRow) { $answerobj = new answer(); $answerobj->setAnswer($answerRow['answertext']); $answerobj->setAnswerId($answerRow['answerid']); $question->addAnswer($answerobj); } $set->addQuestion($question); } array_push($this->sets, $set); } }
public function __construct($userid, $connection) { $set = null; $setid = -1; $questionid = -1; $answerid = -1; foreach ($connection->query('SELECT * FROM fullQuestionSet WHERE ownerid="' . $userid . '"') as $row) { if ($row['setid'] != $setid) { $set = new cardSet(); $set->setSetId($row['setid']); $set->setSetName($row['setname']); $set->setSetDescription($row['setdescription']); } if ($questionid != $row['questionid'] && $row['questionid'] != null) { $question = new question(); $question->setId($row['questionid']); $question->setQuestion($row['question']); $question->setMode($row['mode']); $question->setRightAnswered($row['rightAnswered']); $question->setWrongAnswered($row['wrongAnswered']); } if ($answerid != $row['answerid'] && $row['answerid'] != null) { $answerobj = new answer(); $answerobj->setAnswer($row['answertext']); $answerobj->setAnswerId($row['answerid']); } if ($answerid != $row['answerid'] && $row['answerid'] != null) { $question->addAnswer($answerobj); $answerid = $row['answerid']; } if ($questionid != $row['questionid'] && $row['questionid'] != null) { $set->addQuestion($question); $questionid = $row['questionid']; } if ($set != null && $row['setid'] != $setid) { $setid = $row['setid']; array_push($this->sets, $set); } } }