dfsdfsdf

<html>
<head>
<title>Player Added!</title>
<META HTTP-EQUIV="Refresh"
      CONTENT="2; URL=/site/admin/admin.php">
</head>
</html>

<?php

error_reporting(E_ALL);
ini_set('display_errors', '1');

$con = mysql_connect("******", "******", "******") or die(mysql_error());
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("db_projmay3m", $con);

$game="INSERT INTO game_stats (game_id, win, loss, otl, ot, home, date_month, date_day, rank, team_home, abbr_home, p1_score_home, p2_score_home, p3_score_home, p4_score_home, score_home, shots_home, hits_home, faceoff_home, toa_home_min, toa_home_sec, pim_home, ppa_home, ppg_home, team_away, abbr_away, p1_score_away, p2_score_away, p3_score_away, p4_score_away, score_away, shots_away, hits_away, faceoff_away, toa_away_min, toa_away_sec, pim_away, ppa_away, ppg_away )
VALUES
('$_POST[game_id]','$_POST[win]','$_POST[loss]','$_POST[otl]','$_POST[ot]','$_POST[home]','$_POST[date_month]','$_POST[date_day]','$_POST[rank]','$_POST[team_home]','$_POST[abbr_home]','$_POST[p1_score_home]','$_POST[p2_score_home]','$_POST[p3_score_home]','$_POST[p4_score_home]','$_POST[score_home]','$_POST[shots_home]','$_POST[hits_home]','$_POST[faceoff_home]','$_POST[toa_home_min]','$_POST[toa_home_sec]','$_POST[pim_home]','$_POST[ppa_home]','$_POST[ppg_home]','$_POST[team_away]','$_POST[abbr_away]','$_POST[p1_score_away]','$_POST[p2_score_away]','$_POST[p3_score_away]','$_POST[p4_score_away]','$_POST[score_away]','$_POST[shots_away]','$_POST[hits_away]','$_POST[faceoff_away]','$_POST[toa_away_min]','$_POST[toa_away_sec]','$_POST[pim_away]','$_POST[ppa_away]','$_POST[ppg_away]')";


if (!mysql_query($game ,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Game Successfully Added Into Database";


// ---------------------------------------------------------------------------Player 1 Stats-------------------------------------------------------------------------------------------------------------------------------


$playerstats1="INSERT INTO player_stats (playerid, game_id, gp, gamertag, goals, assists, plus_minus, sog, ppg, shg, pim, hits)
VALUES
('$_POST[playerid_1]','$_POST[game_id_1]','$_POST[gp_1]','$_POST[gamertag_1]','$_POST[goals_1]','$_POST[assists_1]','$_POST[plus_minus_1]','$_POST[sog_1]','$_POST[ppg_1]','$_POST[shg_1]','$_POST[pim_1]','$_POST[hits_1]')";

if (!mysql_query($playerstats1 ,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Player 1 Stats Successfully Added Into Database<br />";


// ---------------------------------------------------------------------------Player 2 Stats-------------------------------------------------------------------------------------------------------------------------------


$playerstats2="INSERT INTO player_stats (playerid, game_id, gp, gamertag, goals, assists, plus_minus, sog, ppg, shg, pim, hits)
VALUES
('$_POST[playerid_2]','$_POST[game_id_2]','$_POST[gp_2]','$_POST[gamertag_2]','$_POST[goals_2]','$_POST[assists_2]','$_POST[plus_minus_2]','$_POST[sog_2]','$_POST[ppg_2]','$_POST[shg_2]','$_POST[pim_2]','$_POST[hits_2]')";

if (!mysql_query($playerstats2 ,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Player 2 Stats Successfully Added Into Database<br />";


// ---------------------------------------------------------------------------Player 3 Stats-------------------------------------------------------------------------------------------------------------------------------


$playerstats3="INSERT INTO player_stats (playerid, game_id, gp, gamertag, goals, assists, plus_minus, sog, ppg, shg, pim, hits)
VALUES
('$_POST[playerid_3]','$_POST[game_id_3]','$_POST[gp_3]','$_POST[gamertag_3]','$_POST[goals_3]','$_POST[assists_3]','$_POST[plus_minus_3]','$_POST[sog_3]','$_POST[ppg_3]','$_POST[shg_3]','$_POST[pim_3]','$_POST[hits_3]')";

if (!mysql_query($playerstats3 ,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Player 3 Stats Successfully Added Into Database<br />";


// ---------------------------------------------------------------------------Player 4 Stats-------------------------------------------------------------------------------------------------------------------------------


$playerstats4="INSERT INTO player_stats (playerid, game_id, gp, gamertag, goals, assists, plus_minus, sog, ppg, shg, pim, hits)
VALUES
('$_POST[playerid_4]','$_POST[game_id_4]','$_POST[gp_4]','$_POST[gamertag_4]','$_POST[goals_4]','$_POST[assists_4]','$_POST[plus_minus_4]','$_POST[sog_4]','$_POST[ppg_4]','$_POST[shg_4]','$_POST[pim_4]','$_POST[hits_4]')";

if (!mysql_query($playerstats4 ,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Player 4 Stats Successfully Added Into Database<br />";


// ---------------------------------------------------------------------------Player 5 Stats-------------------------------------------------------------------------------------------------------------------------------


$playerstats5="INSERT INTO player_stats (playerid, game_id, gp, gamertag, goals, assists, plus_minus, sog, ppg, shg, pim, hits)
VALUES
('$_POST[playerid_5]','$_POST[game_id_5]','$_POST[gp_5]','$_POST[gamertag_5]','$_POST[goals_5]','$_POST[assists_5]','$_POST[plus_minus_5]','$_POST[sog_5]','$_POST[ppg_5]','$_POST[shg_5]','$_POST[pim_5]','$_POST[hits_5]')";

if (!mysql_query($playerstats5 ,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Player 5 Stats Successfully Added Into Database<br />";


// ---------------------------------------------------------------------------Goalie Stats-------------------------------------------------------------------------------------------------------------------------------


$goaliestats="INSERT INTO goalie_stats (playerid, game_id, gp, gamertag, min, win, loss, otl, ga, sa, sv, a, so)
VALUES
('$_POST[playerid_6]','$_POST[game_id_6]','$_POST[gp_6]','$_POST[gamertag_6]','$_POST[min_6]','$_POST[win_6]','$_POST[loss_6]','$_POST[otl_6]','$_POST[ga_6]','$_POST[sa_6]','$_POST[sv_6]','$_POST[a_6]','$_POST[so_6]')";

if (!mysql_query($goaliestats ,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Goalie Successfully Added Into Database<br />";

mysql_close($con)
?>