<?php
//mysqli_report(MYSQLI_REPORT_ALL);

$v = (array)json_decode(stripslashes(file_get_contents("php://input")));
$conn = new mysqli("localhost","gtstudent", "", "concentrate");
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
if (array_key_exists("diff", $v)) {
    $hard = $v["diff"];
} else {
    $hard=1; 
}
$m = $v["moves"];
$n = $v["player"];
$q = "insert into scores (difficulty, score, scorer) values ($hard, $m, '$n');";
$conn->query($q);

$keeper=30;
$q="with lastk as (select recnum as c from scores where difficulty=$hard order by c desc limit $keeper) select c from lastk order by c asc limit 1";
// Now need to get the last record
$result = $conn->query($q);
$row = $result->fetch_assoc();
$cc = $row["c"];
$q = "delete from scores where difficulty=$hard and recnum < " . $cc . ";";
$result = $conn->query($q);
//echo $q;

$q = "select * from scores where difficulty=$hard order by score asc limit 10;";
$result = $conn->query($q);
$arr = array();
$count=0;
while ($row = $result->fetch_assoc()) {
    $arr[$count++]= $row;
}
 
$myJSON = json_encode($arr);
echo $myJSON;

?>