function addResult()
{
$request = Slim::getInstance()->request();
$result = json_decode($request->getBody());
/*If the user already exist then only score is updated if not then user is saved to data base*/
if (userExist($result->email)) {
updateScore($result->email, $result->score);
} else {
createUser($result);
}
/* get the users list for calculating the your position */
$scores = Model::factory('User')->distinct()->select('score')->order_by_desc('score')->find_many();
/* Prepare the response */
$arr = array("topScorer" => getTop(), "yourranking" => getYourRanking($scores, $result->score));
echo json_encode($arr);
}
<?php
include_once 'connect.php';
switch ($_GET["table"] || $_POST["table"]) {
case "score":
updateScore($_GET);
break;
case "personne":
updatePersonne($_GET);
break;
case "document":
updateDocument($_GET);
break;
case "personnesw2ui":
updatePersonnesForW2UIGrid();
break;
default:
break;
}
function updateScore($data)
{
global $conn;
$sql = "update scores set distance=" . $data["distance"] . ", maj = NOW() where id_scores =" . $data["id_score"];
//echo $sql;
if ($conn->query($sql) === TRUE) {
echo "score updated successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
}
function updatePersonne($data)
$gebruiker = $_SESSION['gebruiker_id'];
$totaalscore = 0;
$puntenaftrek = $_POST['puntenaftrek'];
if ($_SERVER["REQUEST_METHOD"] == "POST") {
if (isset($_POST['test'])) {
unset($GEGEVENS['test']);
foreach ($GEGEVENS as $examenvraagid => $score) {
$totaalscore = $totaalscore + $score;
$data = getScore($gebruiker, $examenvraagid);
if (empty($data)) {
//score inserten in tabel score
insertScore($gebruiker, $examenvraagid, $score);
//score updaten in tabel resultaat
} else {
//score inserten in tabel score
updateScore($gebruiker, $examenvraagid, $score);
}
}
$check = checkIfExamResultExists($_SESSION['gebruiker_id'], $examen_id);
if ($check) {
//totaal score updaten in tabel resultaat
insertScoreTabelResultaat($_SESSION['gebruiker_id'], $totaalscore, $examen_id, $puntenaftrek);
} else {
//totaal score updaten in tabel resultaat
updateScoreTabelResultaat($_SESSION['gebruiker_id'], $totaalscore, $examen_id, $puntenaftrek);
}
}
}
}
include ROOT_PATH . "includes/templates/header.php";
//als docent ingelogd is sidebar-docent anders sidebar-leerling
<?php
/**
* Created by PhpStorm.
* User: Arman Jalalian
* Date: 12/14/2015
* Time: 3:49 PM
*/
require "config.php";
updateScore();
function updateScore()
{
global $connect;
$player = $_POST['Player'];
$score = $_POST['Score'];
$created = date('Y-m-d H:i:s');
$updateQuery = "UPDATE highscore SET Player = '{$player}', Score = '{$score}', Created = '{$created}' WHERE Player = '{$player}'";
if ($updateQuery = mysqli_query($connect, $updateQuery)) {
echo "Success!";
} else {
echo mysqli_error($connect);
}
}
