function attemptToInsertIntoBalls($color, $weight, $size)
{
$query = "INSERT INTO Ball(Color, Weight, Size) VALUES ('{$color}', {$weight}, {$size})";
$result = attemptDataManipulationLanguageQuery($query);
if ($result == TRUE) {
echo '<br>Ball successfully created! You can go back to the previous page to use your new ball!';
} else {
echo $result;
}
}
// echo '<br>You are about to delete player number ' . $_POST['player2'];
// $sql = "update team set Player_2 = null where team.Team_ID = $teamID";
// break;
// case 'player3':
// echo '<br>You are about to delete player number ' . $_POST['player3'];
// $sql = "update team set Player_3 = null where team.Team_ID = $teamID";
// break;
// case 'player4':
// echo '<br>You are about to delete player number ' . $_POST['player4'];
// $sql = "update team set Player_4 = null where team.Team_ID = $teamID";
// break;
// case 'player5':
// echo '<br>You are about to delete player number ' . $_POST['player5'];
// $sql = "update team set Player_5 = null where team.Team_ID = $teamID";
// break;
// default:
// echo 'Invalid player!';
// break;
//}
if (attemptDataManipulationLanguageQuery($sql)) {
echo '<br>Player Deleted';
} else {
echo 'Could not delete player!';
}
}
/**
* Created by PhpStorm.
* User: William
* Date: 4/22/2016
* Time: 1:38 PM
*/
echo "<br>Their player ID is: {$playerID}";
echo "<br>Congratulations! {$fname} {$lname} is now part of your team!";
echo '<br>Player has been set as #4';
$sql = "UPDATE team SET Player_4 = {$playerID} where team.Team_ID = {$teamID}";
$message = 'Player has been added to 4th player slot! You can only add one more person to your team!';
} elseif (!isset($row2['Player_5'])) {
echo 'You are trying to add the e-mail ' . $_POST['myinput'], ' to your team';
echo "<br>Their player ID is: {$playerID}";
echo "<br>Congratulations! {$fname} {$lname} is now part of your team!";
echo '<br>Player has been set as #5';
$sql = "UPDATE team SET Player_5 = {$playerID} where team.Team_ID = {$teamID}";
$message = 'Player has been added to 5th player slot! You are currently maxed out on other team members!';
} else {
$message = 'Your team is full, therefore you are unable to add any more players. Please remove some members off of your team if you want room to add other players.';
$isFull = true;
}
popupMessageAndRedirectBrowser($message);
}
}
}
}
if (!$isFull and attemptDataManipulationLanguageQuery($sql)) {
emailPlayer($playerID);
echo '<br>Player Added';
} else {
$message = 'Unable to add the player! ';
}
popupMessageAndRedirectBrowser($message);
} else {
popupMessageAndRedirectBrowser('Player does not exist! Please ensure that what you have entered is correct and valid. ');
}