<?php
	require_once('check_login.php');

	$messgae = "";

	if(empty($_POST["name"])){
		$messgae .= "Please enter player's name.\\n\\n";
	}else{
		//check player name
		$sql = "select * from player where name = ? and deleted = ?";
		$parameters = array($_POST["name"], 0);
		$result = bind_pdo($sql, $parameters, "selectall");
		if(!empty($result)){
			$messgae .= "This player has existed. Please check the player name.\\n\\n";
		}
	}

	if(empty($_POST["gender"])){
		$messgae .= "Please select player's gender.\\n\\n";
	}

	if(!empty($messgae)){
		echo "<script>alert('".$messgae."'); history.back();</script>";
		exit;
	}

	$sql        = "insert into player set name=?, gender=?, tel=?, createdate=?, createby=?, lastupdate=?, lastupby=? ";
	$parameters = array($_POST["name"],$_POST["gender"], $_POST["tel"], $nowdate, $_SESSION['cmsloginid'], $nowdate, $_SESSION['cmsloginid']);
	bind_pdo($sql, $parameters);

	$dbh = null;

	header("Location: player_index.php?msg=1");