prepare('SELECT imagelocation FROM CSSplayerassignment WHERE PlayertableRef = "playerassignment" AND PlayeridRef = :idPlayer LIMIT 1'); $playerimageSQL->bindParam(':idPlayer', $playerid, PDO::PARAM_INT); $playerimageSQL->execute(); $getimage = $playerimageSQL->fetch(PDO::FETCH_ASSOC); if (!empty($getimage['imagelocation'])) { $playerimagelocation .= ''; } else $playerimagelocation = ''; return $playerimagelocation; } function teamroster($currentteam) { $PDOStatConnect = createDBH(); #Set Query for Team $Playerstatquery = $PDOStatConnect->prepare('SELECT idTeamAssignment, playerassignment.idPlayerAssignment AS PlayerAssignmentid, idPlayers, PlayerLast, PlayerFirst, PlayerNumber, PlayerStatus, SUM(PlayerGames), SUM(PlayerGoals), SUM(PlayerAssists), SUM(PlayerPoints), SUM(PlayerPIM) FROM skaterstat JOIN playerassignment ON playerassignment.idPlayerAssignment = skaterstat.idPlayerAssignment JOIN players ON playerassignment.idPlayerskey=players.idPlayers JOIN subseason ON skaterstat.idsubseasonkey = subseason.idsubseason JOIN teamassignment ON playerassignment.idTeamAssignmentkey = teamassignment.idTeamAssignment WHERE idTeamAssignment = :teamid AND (PlayerStatus <> "Sub Goalie" OR PlayerStatus IS NULL) GROUP BY PlayerAssignmentid ORDER BY PlayerNumber, PlayerLast, PlayerFirst'); $Playerstatquery->bindParam(':teamid', $currentteam, PDO::PARAM_INT); $Playerstatquery->execute(); #Set Totals Query $PlayerstatTotal = $PDOStatConnect->prepare('SELECT idTeamAssignmentkey, idPlayers, TeamName, SubSeasonName, PlayerLast, PlayerFirst, PlayerNumber, SUM(PlayerGames), SUM(PlayerGoals), SUM(PlayerAssists), SUM(PlayerPoints), SUM(PlayerPIM) FROM skaterstat JOIN playerassignment ON playerassignment.idPlayerAssignment = skaterstat.idPlayerAssignment JOIN players ON playerassignment.idPlayerskey=players.idPlayers JOIN subseason ON skaterstat.idsubseasonkey = subseason.idsubseason JOIN teamassignment ON playerassignment.idTeamAssignmentkey = teamassignment.idTeamAssignment JOIN team ON teamassignment.idTeamkey = team.idTeam WHERE idTeamAssignmentkey = :teamid'); $PlayerstatTotal->bindParam(':teamid', $currentteam, PDO::PARAM_INT); $PlayerstatTotal->execute(); #Prepare Output for HTML $Teamplayerstat = ''; while($row = $Playerstatquery->fetch(PDO::FETCH_ASSOC)) { $checkforImage = getPlayerImage($row['PlayerAssignmentid']); if (!empty($checkforImage)) {$playerImage = $checkforImage;} else {$playerImage = '';} $Teamplayerstat .= ''; } $Teamplayerstat .= ''; #Adds footer totals calculated in MySQL $PlayerSumStat = $PlayerstatTotal->fetch(PDO::FETCH_ASSOC); $Playerfooter = '
Skater Stats
#PlayerGPGoalsAssistsPointsPIM
'.$row['PlayerNumber'].''.$playerImage.''.$row['PlayerFirst'].' '.$row['PlayerLast'].''.$row['PlayerStatus'].''.$row['SUM(PlayerGames)'].''.$row['SUM(PlayerGoals)'].''.$row['SUM(PlayerAssists)'].''.$row['SUM(PlayerPoints)'].''.$row['SUM(PlayerPIM)'].'
Total'.$PlayerSumStat['SUM(PlayerGoals)'].''.$PlayerSumStat['SUM(PlayerAssists)'].''.$PlayerSumStat['SUM(PlayerPoints)'].''.$PlayerSumStat['SUM(PlayerPIM)'].'
'; return $Teamplayerstat.$Playerfooter; } function teamJSONroster($currentteam) { $PDOStatConnect = createDBH(); #Set Query for Team $Playerstatquery = $PDOStatConnect->prepare('SELECT idTeamAssignment, playerassignment.idPlayerAssignment AS PlayerAssignmentid, idPlayers, PlayerLast, PlayerFirst, PlayerNumber, PlayerStatus, SUM(PlayerGames), SUM(PlayerGoals), SUM(PlayerAssists), SUM(PlayerPoints), SUM(PlayerPIM) FROM skaterstat JOIN playerassignment ON playerassignment.idPlayerAssignment = skaterstat.idPlayerAssignment JOIN players ON playerassignment.idPlayerskey=players.idPlayers JOIN subseason ON skaterstat.idsubseasonkey = subseason.idsubseason JOIN teamassignment ON playerassignment.idTeamAssignmentkey = teamassignment.idTeamAssignment WHERE idTeamAssignment = :teamid AND (PlayerStatus <> "Sub Goalie" OR PlayerStatus IS NULL) GROUP BY PlayerAssignmentid ORDER BY PlayerNumber, PlayerLast, PlayerFirst'); $Playerstatquery->bindParam(':teamid', $currentteam, PDO::PARAM_INT); $Playerstatquery->execute(); /* #Set Totals Query $PlayerstatTotal = $PDOStatConnect->prepare('SELECT idTeamAssignmentkey, idPlayers, TeamName, SubSeasonName, PlayerLast, PlayerFirst, PlayerNumber, SUM(PlayerGames), SUM(PlayerGoals), SUM(PlayerAssists), SUM(PlayerPoints), SUM(PlayerPIM) FROM skaterstat JOIN playerassignment ON playerassignment.idPlayerAssignment = skaterstat.idPlayerAssignment JOIN players ON playerassignment.idPlayerskey=players.idPlayers JOIN subseason ON skaterstat.idsubseasonkey = subseason.idsubseason JOIN teamassignment ON playerassignment.idTeamAssignmentkey = teamassignment.idTeamAssignment JOIN team ON teamassignment.idTeamkey = team.idTeam WHERE idTeamAssignmentkey = :teamid'); $PlayerstatTotal->bindParam(':teamid', $currentteam, PDO::PARAM_INT); $PlayerstatTotal->execute(); #Prepare Output for HTML $Teamplayerstat = ''; while($row = $Playerstatquery->fetch(PDO::FETCH_ASSOC)) { $checkforImage = getPlayerImage($row['PlayerAssignmentid']); if (!empty($checkforImage)) {$playerImage = $checkforImage;} else {$playerImage = '';} $Teamplayerstat .= ''; } $Teamplayerstat .= ''; #Adds footer totals calculated in MySQL $PlayerSumStat = $PlayerstatTotal->fetch(PDO::FETCH_ASSOC); $Playerfooter = '
Skater Stats
#PlayerGPGoalsAssistsPointsPIM
'.$row['PlayerNumber'].''.$playerImage.''.$row['PlayerFirst'].' '.$row['PlayerLast'].''.$row['PlayerStatus'].''.$row['SUM(PlayerGames)'].''.$row['SUM(PlayerGoals)'].''.$row['SUM(PlayerAssists)'].''.$row['SUM(PlayerPoints)'].''.$row['SUM(PlayerPIM)'].'
Total'.$PlayerSumStat['SUM(PlayerGoals)'].''.$PlayerSumStat['SUM(PlayerAssists)'].''.$PlayerSumStat['SUM(PlayerPoints)'].''.$PlayerSumStat['SUM(PlayerPIM)'].'
'; */ $statFetched = $Playerstatquery->fetchAll(PDO::FETCH_ASSOC); $JSONecho = json_encode(array("tabledata"=>$statFetched)); return $JSONecho; } function GetRosterTeamInfo($currentteam) { $PDOStatConnect = createDBH(); $STHHeader = $PDOStatConnect->prepare('SELECT TeamName, SeasonDisplay FROM teamstatview JOIN season ON teamstatview.idSeason = season.idSeason WHERE idTeamAssignment = :teamid'); $STHHeader->bindParam(':teamid', $currentteam, PDO::PARAM_INT); $STHHeader->execute(); $HeaderTeamInfo = $STHHeader->fetch(PDO::FETCH_ASSOC); $HeaderTeamName = $HeaderTeamInfo['TeamName']; $HeaderSeason = $HeaderTeamInfo['SeasonDisplay']; $RosterHeaderOutput = '

Current Roster for the '.$HeaderTeamName.'


Season: '.$HeaderSeason.'


'; return $RosterHeaderOutput; } #Get Data $TeamRosterHeader = GetRosterTeamInfo($currentteam); $RosterData = teamroster($currentteam); $ReturnJSONdata = teamJSONroster($currentteam); #Final Output #$Header = HTMLHeader(NULL); $RosterContent = divBuilder('content','id',$TeamRosterHeader.$RosterData.' #'); #$RosterSection = divBuilder('sectionblock','class',$RosterContent); #$TotalContainer = divBuilder('container','id',$HeaderDiv.$RosterSection); #Output data #echo $Header; #print_r($ReturnJSONdata); echo $ReturnJSONdata; #include 'footer.php'; ?>