<?php

header('Content-Type: text/html; charset=utf-8');
 $user = $_POST['score'];
$score = $_POST['user'];
    $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' ";
$query = mysqli_query($mysqli, $sql);
$numrows = mysqli_num_rows($query);

if ($numrows == 0){
	die ("Usuario nao existe");
}else{
	while($row = mysqli_fetch_assoc($query)){
		if($score > $row['score']){
			$SetCoins = mysqli_query($mysqli, "UPDATE ranking SET score='$score' WHERE user='$user'") or die(mysql_error());
		}
	}
}
 ?>