-
Notifications
You must be signed in to change notification settings - Fork 1
/
Check High Score.php
62 lines (56 loc) · 1.42 KB
/
Check High Score.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
<?php
session_start();
$serverName = "ap-cdbr-azure-southeast-b.cloudapp.net";
$databaseName = "Default Database";
$userName = "b7c4a56e485de0";
$password = "4ed752a1";
$highscore = null;
if ($_SERVER["REQUEST_METHOD"] == "POST") {
try {
$conn = new PDO ("mysql:host=$serverName;dbname=$databaseName", $userName, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
/*$userEmail = null;
if (empty($_SESSION)) {
$userEmail = $_POST['email'];
}
else {
$userEmail = $_SESSION['email'];
}*/
if (!empty($_SESSION)) {
$userEmail = $_SESSION['email'];
$temp = (int)$_POST['time'];
if ($userEmail != null) {
$sql = "SELECT high_score FROM PlayerData WHERE email='$userEmail'";
$rslt = $conn->query($sql);
foreach ($rslt as $row) {
if ($row['high_score'] == null) {
$highscore = $temp;
}
elseif ($row['high_score'] > $temp) {
$highscore = $temp;
}
}
if($highscore != null) {
$sql = "UPDATE PlayerData SET high_score=$highscore WHERE email='$userEmail'";
$stmnt = $conn->prepare($sql);
$stmnt->execute();
echo "Data updated";
}
else {
echo "No data updated";
}
}
else {
echo "Please login first";
}
}
else {
echo "Please login first";
}
}
catch (PDOException $e) {
echo "Connection failed: " . $e->getMessage();
}
$conn = null;
}
?>