require './model/brain_room.php';
require './model/brain_roomDB.php';
require './model/brain_joinRoom.php';
require './model/brain_joinRoomDB.php';
require './model/brain_reserveQuestion.php';
require './model/brain_reserveQuestionDB.php';
require './model/BrainJoinRoom.php';
require './model/BrainRoom.php';
// require './model/brain_Game.php';
// require './model/brain_GameDB.php';
//--------------------------------------------//
$brain_User = new brain_User();
$brain_UserDB = new brain_UserDB();
$brain_Category = new brain_Category();
$brain_CategoryDB = new brain_CategoryDB();
$brain_Question = new brain_Question();
$brain_QuestionDB = new brain_QuestionDB();
$brain_room = new brain_Room();
$brain_roomDB = new brain_RoomDB();
$brain_joinRoom = new brain_joinRoom();
$brain_joinRoomDB = new brain_joinRoomDB();
$brain_reserveQuestion = new brain_reserveQuestion();
$brain_reserveQuestionDB = new brain_reserveQuestionDB();
$brainJoinRoom = new BrainJoinRoom();
$brainRoom = new BrainRoom();
// $brain_room = new brain_Game();
// $brain_roomDB = new brain_GameDB();
$values = array();
//--------------------------------------------//
if ($action == 'login_form') {
if (isset($_GET['error'])) {
public function getReserveQuestions($room_id)
{
$pdo = Database::getDB();
// $number_question = 1;
$stmt = $pdo->prepare("SELECT * FROM reserve_question WHERE room_num = ? AND difficulty = 'EASY' ORDER BY question_num ASC");
$stmt->execute(array($room_id));
$result = $stmt->fetchAll();
$brain_Questions = array();
// $remainder = $result/$number_question;
foreach ($result as $b) {
$brain_question = new brain_Question();
$brain_question->setQuestion_id($b['question_id']);
$brain_question->setQuestion_num($b['question_num']);
$stmt = $pdo->prepare("SELECT * FROM brain_question, easy_choice WHERE brain_question.bid AND easy_choice.qid = ?");
$stmt->execute(array($b['question_id']));
$row = $stmt->fetch();
$brain_question->setQuestion($row['question']);
$brain_question->setLevel($row['level']);
$brain_question->setSubject($row['subject']);
$brain_question->setfile_path($row['question_path']);
$brain_question->setHint($row['hint']);
$brain_question->setCorrect($row['correct']);
$brain_question->setChoiceB($row['choiceB']);
$brain_question->setChoiceC($row['choiceC']);
$brain_question->setChoiceD($row['choiceD']);
$brain_Questions[] = $brain_question;
}
return $brain_Questions;
}
public function getRandQuestion($level, $Subject)
{
$pdo = Database::getDB();
$stmt = $pdo->prepare("SELECT * FROM brain_Question WHERE level = ? AND subject = ? ORDER BY Rand() LIMIT 5");
$stmt->execute(array($level, $Subject));
$result = $stmt->fetchAll();
$brain_RQuestions = array();
foreach ($result as $row) {
$brain_Question = new brain_Question();
$brain_Question->setQid($row['bid']);
$brain_Question->setLevel($row['level']);
$brain_Question->setSubject($row['subject']);
$brain_RQuestions[] = $brain_Question;
}
return $brain_RQuestions;
}
