swimmer.php

<?php
	//db variables
	define( 'DB_SERVER', 'localhost' );
	define( 'DB_USER',   'root' );
	define( 'DB_PW',	 'root' );
	define( 'DB_NAME',   'swimming' );

	session_start();

	//DB Connection

	//change before putting website up
	error_reporting( E_ALL );
	mysqli_report( MYSQLI_REPORT_STRICT );

	try
	{
		$mysqli = new mysqli( DB_SERVER, DB_USER, DB_PW, DB_NAME );
		$connected = true;
	}
	catch (Exception $e)
	{
		$connected = false;
	}

	//Character Set UTF-8
	if($connected)
	{
		if (!$mysqli->set_charset('utf8'))
		{
			$connected = false;
		}
	}

	if(!isset($_SESSION[ 'user' ] ) )
	{
		header('Location: index.php');
	}


	if( isset($_POST[ 'Teams' ]) )
	{
		$_SESSION[ 'currentSelection' ] = 'Teams';
    header('Location: search.php');
	}

	if( isset($_POST[ 'Meets' ]) )
	{
		$_SESSION[ 'currentSelection' ] = 'Meets';
		header('Location: meet.php');
	}

	if( isset($_POST[ 'Swimmers' ]) )
	{
		$_SESSION[ 'currentSelection' ] = 'Swimmers';
		header('Location: swimmer.php');
	}

	if(isset($_POST[ 'AddSwimmertoTeamsubmit' ]) )
	{
		$newSwimmerFirstName = $_POST[ 'newSwimmerFirstName' ];
		$newSwimmerLastName = $_POST[ 'newSwimmerLastName' ];
		$newSwimmerAge = $_POST[ 'newSwimmerAge' ];
		$newSwimmerYear = $_POST[ 'newSwimmerYear' ];

		//SQL to Prepare
		$newSwimmerSQL = null;
		$newSwimmerSQL = "INSERT INTO Swimmers (SFName, SLName, age, year)" .
							" VALUES ( ? , ? , ? , ? )";

		//Preparing
		$newSwimmerstmt = $mysqli->prepare($newSwimmerSQL);

		//Binding Parameter
		$newSwimmerstmt->bind_param("ssis", $newSwimmerFirstName, $newSwimmerLastName, $newSwimmerAge, $newSwimmerYear);

		//execute
		$newSwimmerstmt->execute();
		//gets the ID of the swimmer
		$newSwimmerID = mysqli_insert_id($mysqli);

		$newSwimmerstmt->close();

		//SWIMMERTEAMS SQL

		//SQL to Prepare
		$newSwimmerTeamsSQL = null;
		$newSwimmerTeamsSQL = "INSERT INTO SwimmerTeams (STTeamID, STSNID)" .
								" VALUES ( ? , ? )";

		//Preparing
		$newSwimmerTeamsstmt = $mysqli->prepare($newSwimmerTeamsSQL);

		//Binding Parameter
		$newSwimmerTeamsstmt->bind_param("ii", $_SESSION[ 'teamID' ], $newSwimmerID);

		//execute
		$newSwimmerTeamsstmt->execute();

		$newSwimmerTeamsstmt->close();
	}

	if(isset($_POST[ 'AddSwimmersOnTeam' ]) )
	{
		$teamIDToCopyFrom = $_POST[ 'AddSwimmersFromTeam' ];

		//Finding all swimmers on a team
		//SQL to Prepare
		$findSwimmersSQL = null;
		$findSwimmersSQL = "SELECT SwimmerTeams.STSNID" .
							" FROM SwimmerTeams" .
							" WHERE SwimmerTeams.STTeamID = ? ";

		//Preparing
		$findSwimmersstmt = $mysqli->prepare($findSwimmersSQL);

		//Binding Parameter
		$findSwimmersstmt->bind_param("i", $teamIDToCopyFrom);

		//execute
		$findSwimmersstmt->execute();

		//iterating over results of find all swimmers on a team
		$findSwimmersstmt->bind_result($copySwimmerID);

		$swimmerIDArray = [];

		while($findSwimmersstmt->fetch())
		{
			$swimmerIDArray[] = $copySwimmerID;
		}

		//closing
		$findSwimmersstmt->close();

		//Inserting all swimmers from old team to new team
		//SQL to Prepare
		$insertSwimmersFromOldToNewSQL = null;
		$insertSwimmersFromOldToNewSQL = "INSERT INTO SwimmerTeams (STTeamID, STSNID)" .
										" VALUES ( ? , ? )";

		//Preparing
		$insertSwimmersFromOldToNewstmt = $mysqli->prepare($insertSwimmersFromOldToNewSQL);

		foreach($swimmerIDArray as $copiedSwimmerID)
		{

			//Binding Parameters for inserting all swimmers from old team to current team
			$insertSwimmersFromOldToNewstmt->bind_param("ii", $_SESSION[ 'teamID' ], $copiedSwimmerID);

			//execute inserting swimmer from old team to current team
			$insertSwimmersFromOldToNewstmt->execute();

		}

		unset($swimmerIDArray);

		//closing
		$insertSwimmersFromOldToNewstmt->close();

	}

	if( isset($_POST[ 'SearchSwimmer' ]) )
	{
		$swimmerResult = $_POST[ 'SelectSwimmer'];

		$swimmerResult_explode = explode('|', $swimmerResult);

		$_SESSION[ 'swimmerName' ] = $swimmerResult_explode[0];
		$_SESSION[ 'swimmerID' ] = $swimmerResult_explode[1];
		$_SESSION[ 'eventID' ] = null;
		$_SESSION[ 'eventName' ] = "None";

		$_SESSION[ 'currentSelection' ] = "Events";

		header('Location: events.php');
	}

	if( isset($_POST[ 'Events' ]) )
	{
		$_SESSION[ 'currentSelection' ] = 'Events';
		header('Location: events.php');
	}

	if( isset($_POST[ 'Timer' ]) )
	{
		$_SESSION[ 'currentSelection' ] = 'Timer';
		header('Location: timer.php');

	}

	if(isset($_SESSION[ 'user' ]))
	{
?>
		<!DOCTYPE html>
		<html lang="en">

		<head>

			<meta charset="utf-8">
			<meta http-equiv="X-UA-Compatible" content="IE=edge">
			<meta name="viewport" content="width=device-width, initial-scale=1">
			<meta name="description" content="">
			<meta name="author" content="">

			<title>Creative - Start Bootstrap Theme</title>

			<!-- Bootstrap Core CSS -->
			<link rel="stylesheet" href="css/bootstrap.min.css" type="text/css">

			<!-- Custom Fonts -->
			<link href='http://fonts.googleapis.com/css?family=Open+Sans:300italic,400italic,600italic,700italic,800italic,400,300,600,700,800' rel='stylesheet' type='text/css'>
			<link href='http://fonts.googleapis.com/css?family=Merriweather:400,300,300italic,400italic,700,700italic,900,900italic' rel='stylesheet' type='text/css'>
			<link rel="stylesheet" href="font-awesome/css/font-awesome.min.css" type="text/css">

			<!-- Plugin CSS -->
			<link rel="stylesheet" href="css/animate.min.css" type="text/css">

			<!-- Custom CSS -->
			<link rel="stylesheet" href="css/creative.css" type="text/css">

			<!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
			<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
			<!--[if lt IE 9]>
				<script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
				<script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
			<![endif]-->

			<style>
				body {background-color: grey;}
				p.header {padding-top: 5px;
					color: black;}

				p.body {color: white;}
			</style>
		</head>

		<body>

			<nav id="mainNav" class="navbar navbar-default navbar-fixed-top">
			<div class="container-fluid">
				<!-- Brand and toggle get grouped for better mobile display -->
				<div class="navbar-header">
					<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
						<span class="sr-only">Toggle navigation</span>
						<span class="icon-bar"></span>
						<span class="icon-bar"></span>
						<span class="icon-bar"></span>
					</button>
					<a class="navbar-brand page-scroll" href="logout.php">LogOut</a>
				</div>

				<!-- Collect the nav links, forms, and other content for toggling -->
				<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
					<ul class="nav navbar-nav navbar-right">
						<li>

								<form method="POST" action = "<?php echo htmlentities( $_SERVER['PHP_SELF'] ); ?>">
									<button type="submit" name="Teams" class="btn btn-link">
									<p class = "header">Teams</p>
									</button>
								</form>
						</li>
						<li>

								<form method="POST" action = "<?php echo htmlentities( $_SERVER['PHP_SELF'] ); ?>">
									<button type="submit" name="Meets" class="btn btn-link">
									<p class = "header">Meets</p>
									</button>
								</form>
						</li>
						<li>
							<form method="POST" action = "<?php echo htmlentities( $_SERVER['PHP_SELF'] ); ?>">
								<button type="submit" name="Swimmers" class="btn btn-link">
								<p class = "header">Swimmers</p>
								</button>
							</form>
						</li>
						<li>
							<form method="POST" action = "<?php echo htmlentities( $_SERVER['PHP_SELF'] ); ?>">
								<button type="submit" name="Events" class="btn btn-link">
								<p class = "header">Events</p>
								</button>
							</form>
						</li>
						<li>
							<form method="POST" action = "<?php echo htmlentities( $_SERVER['PHP_SELF'] ); ?>">
								<button type="submit" name="Timer" class="btn btn-link">
								<p class = "header">Timer</p>
								</button>
							</form>
						</li>
					</ul>
				</div>
				<!-- /.navbar-collapse -->
			</div>
			<!-- /.container-fluid -->
			</nav>

			<section class="bg-primary">
						<h2>Currently Selected <?php echo $_SESSION[ 'currentSelection' ]; ?> </h2>
						<hr>
						<p class="text-left"><strong>Team: <?php echo $_SESSION[ 'teamName' ] ?></strong></p>
						<p class="text-left"><strong>Meet: <?php echo $_SESSION[ 'meetName' ] ?></strong></p>
						<p class="text-left"><strong>Swimmer: <?php echo $_SESSION[ 'swimmerName' ] ?></strong></p>
						<p class="text-left"><strong>Event: <?php echo $_SESSION[ 'eventName' ] ?></strong></p>
						<?php
								if($_SESSION[ 'teamID' ] === null)
								{
						?>
										<h3><strong> Please Select A Team Before Adding Or Searching Swimmeres </strong></h3>
						<?php
								}
									else
									{
						?>
										<p> Add new Swimmer: </p>
										<form class = "form-inline" method = "POST" action = "<?php echo htmlentities( $_SERVER['PHP_SELF'] ); ?>">
											<div class = "form-group">
												<label for="swimmerFirstName"> First Name:</label>
												<input type="text" class="form-control" id="newSwimmerFirstName" name = "newSwimmerFirstName" required maxlength = "30">
											</div>
											<div class = "form-group">
												<label for="swimmerLastName"> Last Name:</label>
												<input type="text" class="form-control" id="newSwimmerLastName" name = "newSwimmerLastName" required maxlength = "30">
											</div>
											<div class = "form-group">
												<label for="swimmerAge"> Age:</label>
												<input type="number" class="form-control" id="newSwimmerAge" name = "newSwimmerAge" min = "1" max = "99">
											</div>
											<div class = "form-group">
												<label for="swimmerYear"> Year:</label>
												<input type="text" class="form-control" id="newSwimmerYear" name = "newSwimmerYear" maxlength = "20">
											</div>
											<button type="submit" name="AddSwimmertoTeamsubmit" class="btn btn-default"> Add Swimmer to Team </button>
										</form>

										<br>

										<form class = "form-inline" method = "POST" action = "<?php echo htmlentities( $_SERVER['PHP_SELF'] ); ?>">
											<div class = "form-group">
												<label for="selTeam">Select team to copy swimmers from:</label>
												<select class="form-control" id="selTeam" name="AddSwimmersFromTeam">
													<?php
														//Find all teams that the user is the coach of
														//SQL to Prepare
														$teamNamesSQL = null;
														$teamNamesSQL = "SELECT Team.Name AS Team_Name, Team.TeamID AS Team_ID" .
																		" FROM Team" .
																		" WHERE Team.HeadCoach = ?";

														//Preparing
														$teamNamesstmt = $mysqli->prepare($teamNamesSQL);

														//Binding Parameter
														$teamNamesstmt->bind_param("i", $_SESSION[ 'user' ]);

														//execute
														$teamNamesstmt->execute();

														//iterating over results
														$teamNamesstmt->bind_result($returnedTeamNames, $returnedTeamIDs);

														while($teamNamesstmt->fetch())
														{

															echo "<option value=$returnedTeamIDs> $returnedTeamNames </option>";

														}

														$teamNamesstmt->free_result();
													?>
												</select>
											</div>
											<div class = "form-group">
												<input type="submit" name="AddSwimmersOnTeam" class="btn btn-default" value="Add all swimmers from team">
											</div>
										</form>
						<?php
									}
						?>
			</section>

			<!--END OF ADD SECTION-->
			<!--this is going to be the body of the page with all the results-->

				<?php
						if($_SESSION[ 'teamID' ] !== null)
						{
				?>
							<br>
							<form class = "form-inline" method = "POST" action = "<?php echo htmlentities( $_SERVER['PHP_SELF'] ); ?>">
								<div class = "form-group">
									<label for="selSwimmer">Select swimmer to search from:</label>
										<select class="form-control" id="selSwimmer" name="SelectSwimmer">
				<?php
										//Find all swimmers on a team
										//SQL to Prepare
										$swimmersNamesSQL = null;
										$swimmersNamesSQL = "SELECT Swimmers.SFName AS SwimmerFirstName, Swimmers.SLName AS SwimmerLastName, Swimmers.SNID AS SwimmerID" .
															" FROM Swimmers INNER JOIN SwimmerTeams ON Swimmers.SNID = SwimmerTeams.STSNID" .
															" WHERE SwimmerTeams.STTeamID = ?";

										//Preparing
										$swimmerNamesstmt = $mysqli->prepare($swimmersNamesSQL);

										//Binding Parameter
										$swimmerNamesstmt->bind_param("i", $_SESSION[ 'teamID' ]);

										//execute
										$swimmerNamesstmt->execute();

										//iterating over results
										$swimmerNamesstmt->bind_result($returnedSwimmerFirstName, $returnedSwimmerLastName, $returnedSwimmerID);

										while($swimmerNamesstmt->fetch())
										{
											echo "<option value=$returnedSwimmerFirstName$returnedSwimmerLastName|$returnedSwimmerID> $returnedSwimmerFirstName$returnedSwimmerLastName </option>";
										}

										$swimmerNamesstmt->close();

										//may want to have a button for all swimmers to search
				?>
										</select>
								</div>
										<div class ="form-group">
											<input type="submit" name="SearchSwimmer" class="btn btn-default" value="Search this swimmer">
										</div>
							</form>

							<input type="submit" name="SearchAllSwimmers" class="btn btn-default" value="Search All Swimmers">
				<?php
						}
				?>
			<!-- jQuery -->
			<script src="js/jquery.js"></script>

			<!-- Bootstrap Core JavaScript -->
			<script src="js/bootstrap.min.js"></script>

			<!-- Plugin JavaScript -->
			<script src="js/jquery.easing.min.js"></script>
			<script src="js/jquery.fittext.js"></script>
			<script src="js/wow.min.js"></script>

			<!-- Custom Theme JavaScript -->
			<script src="js/creative.js"></script>

		</body>

		</html>
<?php
	}
	else
	{
		echo "Please LogIn first.";
	}
?>