public function getPlayerByPlayerId($playerId) { // the SQL query to be executed on the database $query = "Select PLAYER_ID, PLAYER_FNAME, PLAYER_LNAME, PLAYER_HEIGHT,PLAYER_TEAM_ID,TEAM_NAME,\r\n PLAYER_WEIGHT,PLAYER_GENDER,PLAYER_DOB,PLAYER_EMAIL_ADDRESS From dbo.PLAYER p join dbo.TEAM t on (p.PLAYER_TEAM_ID = t.TEAM_ID)\r\n WHERE PLAYER_ID =" . $playerId; $results = executeQuery($query); $player = new PlayerVO(); foreach ($results as $result) { $player->set_playerId($result['PLAYER_ID']); $player->set_dob($result['PLAYER_DOB']); $player->set_email($result['PLAYER_EMAIL_ADDRESS']); $player->set_fname($result['PLAYER_FNAME']); $player->set_gender($result['PLAYER_GENDER']); $player->set_height($result['PLAYER_HEIGHT']); $player->set_lname($result['PLAYER_LNAME']); $player->set_teamId($result['PLAYER_TEAM_ID']); $player->set_teamName($result['TEAM_NAME']); $player->set_weight($result['PLAYER_WEIGHT']); } return $player; }
function updatePlayer($arrayObj) { $playerDao = new PlayerDAO(); $player = new PlayerVO(); $player->set_fname($arrayObj[0]); $player->set_lname($arrayObj[1]); $player->set_height($arrayObj[2]); $player->set_weight($arrayObj[3]); $player->set_gender($arrayObj[4]); $player->set_dob($arrayObj[5]); $player->set_email($arrayObj[6]); $player->set_teamId($arrayObj[7]); $player->set_playerId($arrayObj[8]); $player->set_teamName($arrayObj[9]); $result = $playerDao->cudPlayer($player, UPDATE); return $result; }