function getPlayerInfo($playerID)
{
if (isset($playerID)) {
$connection = mysqli_connect("localhost", "root", "", "baseball");
$playerID = mysqlsafe($playerID, $connection);
//player info query
$query = mysqli_query($connection, "SELECT playerID, birthYear, nameFirst, nameLast, weight, height, bats, throws, debut, finalGame, birthCity, birthState FROM master WHERE playerID='{$playerID}'");
$rowCount = mysqli_num_rows($query);
//counts rows returned
if ($rowCount == 1) {
$row = mysqli_fetch_assoc($query);
//$playerTable .= "") reserved for playerimage
$playerTable = "<b>Name: </b>" . $row['nameFirst'] . " " . $row['nameLast'] . "<br>\n";
if (!is_null($row['birthYear'])) {
$playerTable .= "<b>BirtYear: </b>" . $row['birthYear'] . "<br>\n";
}
if (!is_null($row['birthCity']) && !is_null($row['birthState'])) {
$playerTable .= "<b>Birthplace: </b>" . $row['birthCity'] . ", " . $row['birthState'] . "<br>\n";
}
if (!is_null($row['bats']) && !is_null($row['throws'])) {
$playerTable .= "<b>Bats/Throws: </b>" . $row['bats'] . "/" . $row['throws'] . "<br>\n";
}
if (!is_null($row['debut'])) {
$playerTable .= "<b>Debut: </b>" . RemoveSpacePlus($row['debut']) . "<br>\n";
}
if (!is_null($row['finalGame'])) {
$playerTable .= "<b>Final Game: </b>" . RemoveSpacePlus($row['finalGame']) . "<br>\n";
}
}
}
mysqli_close($connection);
return $playerTable;
}
$fieldingTable = getPlayerFielding($playerID);
$pitchingTable = getPlayerPitching($playerID);
} else {
if ($rowCount > 1) {
$playerTable = "<table >\n";
$playerTable .= "\t<tr>\n";
$playerTable .= "\t\t<th>Name</th>\n";
//rows will contain first and lastname
$playerTable .= "\t\t<th>Weight(Pounds)</th>\n";
$playerTable .= "\t\t<th>Height(Inches)</th>\n";
$playerTable .= "\t\t<th>Birthplace</th>\n";
// row will contain city and state of birth
$playerTable .= "\t\t<th>Debut(YYYY-MM-DD)</th>\n";
$playerTable .= "\t\t<th>Final Game(YYYY-MM-DD)</th>\n";
$playerTable .= "\t</tr>\n";
while ($row = mysqli_fetch_assoc($query)) {
$playerTable .= "\t<tr>\n";
$playerTable .= "\t\t<td>" . "<a href='#" . $row['playerID'] . "' onclick='getPlayer(this.href)'>" . $row['nameFirst'] . " " . $row['nameLast'] . "</a></td>\n";
$playerTable .= "\t\t<td>" . $row['weight'] . "</td>\n";
$playerTable .= "\t\t<td>" . $row['height'] . "</td>\n";
$playerTable .= "\t\t<td>" . $row['birthCity'] . ", " . $row['birthState'] . "</td>\n";
$playerTable .= "\t\t<td>" . RemoveSpacePlus($row['debut']) . "</td>\n";
$playerTable .= "\t\t<td>" . RemoveSpacePlus($row['finalGame']) . "</td>\n";
$playerTable .= "\t</tr>\n";
}
$playerTable .= "</table>\n";
}
}
}
mysqli_close($connection);
}
