public function get_Users($room_id) { $pdo = Database::getDB(); $stmt = $pdo->prepare("SELECT * FROM brain_joinroom WHERE room_num = ?"); $stmt->execute(array($room_id)); $result = $stmt->fetchAll(); $brain_joinUsers = array(); foreach ($result as $j) { $stmt = $pdo->prepare("SELECT * FROM register WHERE user_id = ?"); $stmt->execute(array($j['user_id'])); $brain_User = new brain_User(); $row = $stmt->fetch(); $brain_User->setAcc_path($row['user_path']); $brain_User->setFname($row['fname']); $brain_joinUsers[] = $brain_User; } return $brain_joinUsers; }
public function getProfile($user_id) { $pdo = Database::getDB(); $stmt = $pdo->prepare("SELECT * FROM register WHERE user_id = ?"); $stmt->execute(array($user_id)); $row = $stmt->fetchAll(); $brain_profile = array(); foreach ($row as $b) { $brain_prof = new brain_User(); $brain_prof->setUser_id($b['user_id']); $brain_prof->setAcc_path($b['user_path']); $brain_prof->setLname($b['lname']); $brain_prof->setFname($b['fname']); $brain_prof->setMname($b['middlename']); $brain_prof->setAddress($b['address']); $brain_prof->setContact($b['contact']); $brain_prof->setAge($b['age']); $brain_prof->setGender($b['gender']); $brain_prof->setUsertype($b['usertype']); $brain_prof->setDob($b['bday']); $brain_prof->setUsername($b['username']); $brain_prof->setDate($b['date_reg']); $brain_profile[] = $brain_prof; } return $brain_profile; }
require './model/brain_Category.php'; require './model/brain_CategoryDB.php'; require './model/brain_Question.php'; require './model/brain_QuestionDB.php'; 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();