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

    $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());
  $user = $_POST['email'];
  $pass = $_POST['user'];
  $email = $_POST['pass'];
//$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());

}

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



?>