public function getJoin_Room($brain_joinRoom) { $pdo = Database::getDB(); $jid = $brain_joinRoom->getJid(); $user_id = $brain_joinRoom->getUser_id(); $room_num = $brain_joinRoom->getRoom_num(); $player_type = $brain_joinRoom->getPlayer_type(); // $stmt = $pdo->prepare("SELECT register.fname, register.middlename, register.lname, register.user_id, brain_joinroom.player_type , brain_joinroom.rid FROM register, brain_joinroom WHERE brain_joinroom.user_id = register.user_id AND room_num = ?"); $stmt = $pdo->prepare("SELECT * FROM register, brain_joinroom WHERE brain_joinroom.user_id = register.user_id AND room_num = ?"); $stmt->execute(array($room_num)); $result = $stmt->fetchAll(); $brain_joinUsers = array(); foreach ($result as $j) { $brain_User = new brain_User(); $brain_User->setJid($j['rid']); $brain_User->setAcc_path($j['user_path']); $brain_User->setAddress($j['address']); $brain_User->setContact($j['contact']); $brain_User->setAge($j['age']); $brain_User->setGender($j['gender']); $brain_User->setDob($j['bday']); $brain_User->setUser_id($j['user_id']); $brain_User->setFname($j['fname']); $brain_User->setLname($j['lname']); $brain_User->setMname($j['middlename']); $brain_User->setPlayer_type($j['player_type']); $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; }
include './view/checkPlayer.php'; } elseif ($action == 'add_user') { $_SESSION['user_id'] = $_POST['user_id']; $_SESSION['lname'] = ucwords($_POST['lastname']); $_SESSION['fname'] = ucwords($_POST['firstname']); $_SESSION['mname'] = ucwords($_POST['middlename']); $_SESSION['address'] = ucwords($_POST['address']); $_SESSION['contact'] = $_POST['contact']; $_SESSION['age'] = $_POST['age']; $_SESSION['gender'] = ucwords($_POST['gender']); $_SESSION['dob'] = $_POST['dob']; $_SESSION['username'] = $_POST['username']; $_SESSION['password'] = $_POST['password']; $_SESSION['usertype'] = ucwords($_POST['usertype']); $date = date('M:d:Y'); $brain_User->setUser_id($_SESSION['user_id']); $brain_User->setLname($_SESSION['lname']); $brain_User->setFname($_SESSION['fname']); $brain_User->setMname($_SESSION['mname']); $brain_User->setAddress($_SESSION['address']); $brain_User->setContact($_SESSION['contact']); $brain_User->setAge($_SESSION['age']); $brain_User->setGender($_SESSION['gender']); $brain_User->setDob($_SESSION['dob']); $brain_User->setUsername($_SESSION['username']); $brain_User->setPassword($_SESSION['password']); $brain_User->setUsertype($_SESSION['usertype']); $brain_User->setDate($date); $brain_User->setAcc_name($acc_name = $_FILES['acc_name']['name']); $brain_User->setAcc_type($acc_type = $_FILES['acc_name']['type']); $brain_User->setAcc_path($acc_path = "./user/" . $acc_name);