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); } }