<?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");
//-------------
$sql = "SELECT user FROM ranking  WHERE user  = '$user' ";
$query=mysqli_query($mysqli, $sql);

if($dados =  mysqli_fetch_all($query, MYSQLI_ASSOC)) {
	echo "Usuario Já existe.";
}
else{
	echo "Usuário Disponível.";

	//$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());

}

//-------------



?>