savedata

<?php

	$con = mysqli_connect('localhost', 'admin', 'admin', 'carnival_db');

 //check that connection happened
 if (mysqli_connect_errno())
 {
	echo "1: Connection failed";
	exit();
 }

 $username = $_POST["name"];
 $newscore = $_POST["score"];

$namecheckquery = "SELECT username, score FROM players WHERE username='".$username."';";

$namecheck = mysqli_query($con, $namecheckquery) or die("2: Name check query failed");

if(mysqli_num_rows($namecheck) != 1)
 {
	 echo "5: Either no user with name or more than 1"; //error code #5
	 exit();
 }

$updatequery = "UPDATE players SET score ='".$newscore."' WHERE username ='".$username."';";
mysqli_query($con, $updatequery) or die("7: Save query failed"); //error code 7 update failed

 echo "0";
?>