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();
