<?PHP
header('Content-Type: text/html; charset=utf-8');

$user = $_POST['user'];
$pass = $_POST['pass'];
$email = $_POST['email'];


    $servername = "localhost";
    $username = "id463989_gazin";
    $password = "nabil2017";
    $dbname = "id463989_gazin2017";

    $mysqli = new mysqli($servername, $username, $password, $dbname);
    $mysqli->set_charset("utf8");

mysqli_select_db( $mysqli,  $dbname) or die ("could not load the database" . mysql_error());

$sql = "SELECT * FROM ranking WHERE `user`='".$user."'" or die("errao");

$numrows = mysqli_num_rows($sql);

if ($numrows == 0)
{
	//$pass = md5($pass);
	$ins = mysqli_query($mysqli, "INSERT INTO  `ranking` (  `id` ,  `user` ,  `pass` , `email` , `score`  ) VALUES ('' ,  '".$user."' ,  '".$pass."' , '".$email."' , '0') ; ");
	if ($ins)
		die ("Conta criada com sucesso!");
	else
		die ("Error: " . mysql_error());
}
else
{
	die("Este usuario ja existe!");
}

?>