<?php
include 'Functions.php';
include 'PlayerFunctions.php';
//handles call from ajax from player.php
if (isset($_POST['aPlayerID'])) {
//get player info
$playerID = $_POST['aPlayerID'];
echo getPlayerInfo($playerID);
//get player info table
echo getPlayerBatting($playerID);
//get plater batting table
echo getPlayerFielding($playerID);
//get player fielding table
echo getPlayerPitching($playerID);
// get player pitching table
}
if (isset($_POST['submit'])) {
$connection = mysqli_connect("localhost", "root", "", "baseball");
$playerFirstname = mysqlsafe($_POST['PlayerFirstname'], $connection);
$playerLastname = mysqlsafe($_POST['PlayerLastname'], $connection);
$query = mysqli_query($connection, "SELECT playerID, nameFirst, nameLast, weight, height, bats, throws, debut, finalGame, birthCity, birthState FROM master WHERE nameFirst='{$playerFirstname}' AND nameLast='{$playerLastname}'");
$rowCount = mysqli_num_rows($query);
if ($rowCount == 0) {
$error = "Player name not contained in database.";
} else {
if ($rowCount == 1) {
$row = mysqli_fetch_assoc($query);
$playerID = $row['playerID'];
$playerInfo = getPlayerInfo($playerID);
$battingTable = getPlayerBatting($playerID);
$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";