Untitled

<html>
<head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.0/jquery.min.js"></script>
</head>
<body>
<script>
	game = {
		score: 0
	};

</script>

<?php
$servername = "localhost";
$username = "root";
$password = "ievank";
$dbname = "gametest";
$user = $_SERVER['REMOTE_ADDR'];


// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}


$nxtquery = "SELECT * FROM players";

$result = $conn->query($nxtquery);


$userIndex=0;
$continueLoop=true;
while($row = $result->fetch_assoc() && $continueLoop) {
		$resarray = $result->fetch_assoc();
		if($resarray["ip"]===$user){
			echo "<script id='tempScript'>game.score=" . $resarray["score"] . "; game.user='" . $user . "'</script>";
			$continueLoop=false;
		} else {
			$userIndex++;
		}
	}
if($continueLoop) {
	$nxtquery = "INSERT INTO players (ip, score) VALUES ('" . $_SERVER['REMOTE_ADDR'] . "', '0')";
	$conn->query($nxtquery);
}


?>

<script>
	document.getElementById("tempScript").remove();
	function SubForm(){
		formData= 'score='+game.score+'&user='+game.user;
		$.ajax({
			url:'sendScore.php',
			type:'post',
			data: formData,
			success:function(){
				console.log("saved");
			}
		});
	}

	window.setInterval(function(){
		SubForm();
		}, 15000);
</script>

</body>
</html>