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; }