<?php
	$name = $_POST['name'];
	$password = $_POST['password'];
	$country = $_POST['country'];
	$pointsFor = $_POST['pointsFor'];
	$pointsAgainst = $_POST['pointsAgainst'];
	$pointDiff = $pointsFor - $pointsAgainst;
	$games = $_POST['games'];
	$avgPPG = $pointsFor/$games;
	$defTouch = $_POST['defTouch'];
	$softTouch = $_POST['softTouch'];
	$ace = $_POST['ace'];
	$win = $_POST['win'];
	$loss = $_POST['loss'];
	if($loss==0)
		$ratio = $win;
	else
		$ratio = $win/$loss;
	
	$host = 'localhost';
	$user = 'wmeckard';
	$passwd = 'CS389';
	$database = 'wmeckard';
	$connect = mysqli_connect($host, $user, $passwd);
	$query = "insert into SPIKE values ('$name', '$country', $pointsFor, $pointsAgainst, $pointDiff, $games, $avgPPG, $defTouch, $softTouch, $ace, $win, $loss, $ratio, '$password')";
	
	mysqli_select_db($connect, $database);
	if(mysqli_query($connect, $query)){
		print "<CENTER><P><big><big>Congrats! Your stats have been added.</big></big><P><P>";
		print "<A HREF=spikeStats.html>Return to home.</A>";
		}	
	else
		print "<P>Insert fail.<P>";
	mysqli_close($connect);
?>