Show sourcecode
The following files exists in this folder. Click to view.
webbsrvprg/exercises/projekt/classes/
card.php
collection.php
filtersort.php
lineup.php
user.php
collection.php
166 lines UTF-8 Windows (CRLF)
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166
<?php
include("./incl/default.php");
class Collection
{
private $db;
public function __construct($dbconn)
{
$this->db = $dbconn;
//Slippa skicka $dbconn varje gång du kallar en metod
}
public function addtocollection($playerid, $userid)
{
try {
$sql = "INSERT INTO owned_cards (user_id, player_id)
VALUES (?, ?)";
$stmt = $this->db->prepare($sql);
$data = array($userid, $playerid);
$stmt->execute($data);
} catch (PDOException $e) {
echo $sql . "<br />" . $e->getMessage();
}
}
public function removefromcollection($userid, $playerid)
{
try {
$sql = "DELETE FROM startelva
WHERE userid = ? AND
owned_id = ?";
$stmt = $this->db->prepare($sql);
$data = array($userid, $playerid);
$stmt->execute($data);
//ta bort från din startelva
$sql = "DELETE FROM owned_cards WHERE user_id=? AND id = ?";
$stmt = $this->db->prepare($sql);
$data = array($userid, $playerid);
$stmt->execute($data);
//ta bort från din samling
} catch (PDOException $e) {
echo $sql . "<br />" . $e->getMessage();
}
}
public function showownedplayers($userid)
{
try {
$sql = "SELECT owned_cards.id AS playerid, players.name AS name
FROM owned_cards
RIGHT JOIN players ON owned_cards.player_id = players.id
WHERE owned_cards.user_id = ?";
$stmt = $this->db->prepare($sql);
$data = array($userid);
$stmt->execute($data);
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
echo "<input type='checkbox' name='" . htmlentities($res['playerid']) . "'>" . htmlentities($res['name']) . "</option> <br>";
}
} catch (PDOException $e) {
echo $sql . "<br />" . $e->getMessage();
}
}
public function show_notownedplayers($userid)
{
try {
$sql = "SELECT player_id
FROM owned_cards
WHERE user_id = ?";
$stmt = $this->db->prepare($sql);
$data = array($userid);
$stmt->execute($data);
$ownedplayers = [];
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
$ownedplayers[] = $res['player_id'];
}
$sql = "SELECT id, name
FROM players";
$stmt = $this->db->prepare($sql);
$stmt->execute();
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
if (!in_array($res['id'], $ownedplayers)) {
echo "<input type='checkbox' name='" . htmlentities($res['id']) . "'>" . htmlentities($res['name']) . "</option> <br>";
}
}
} catch (PDOException $e) {
echo $sql . "<br />" . $e->getMessage();
}
}
public function leaderboard()
{
try {
$sql = "SELECT id, name FROM projektusers";
$stmt = $this->db->prepare($sql);
$stmt->execute();
$users = [];
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
$users[] = [
'id' => $res['id'],
'name' => $res['name']
];
}
$leaderboard = [];
foreach ($users as $user) {
$sql = "SELECT players.rating AS rating, players.name AS name
FROM owned_cards
RIGHT JOIN players ON owned_cards.player_id = players.id
WHERE owned_cards.user_id = ?";
$stmt = $this->db->prepare($sql);
$stmt->execute([$user['id']]);
$highestrating = 0;
$antalspelare = 0;
$highestname = '';
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
$antalspelare++;
if ($res['rating'] > $highestrating) {
$highestrating = $res['rating'];
$highestname = $res['name'];
}
}
$sql = "SELECT players.rating AS rating
FROM startelva
RIGHT JOIN owned_cards ON startelva.owned_id = owned_cards.id
RIGHT JOIN players ON owned_cards.player_id = players.id
WHERE startelva.userid = ?";
$stmt = $this->db->prepare($sql);
$stmt->execute([$user['id']]);
$totalRating = 0;
$count = 0;
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
$totalRating += $res['rating'];
$count++;
}
$average = $count > 0 ? round($totalRating / $count) : 0;
$leaderboard[] = [
'id' => $user['id'],
'name' => $user['name'],
'antalspelare' => $antalspelare,
'highestname' => $highestname,
'average' => $average
];
}
// Sortera efter average (högst först)
usort($leaderboard, function ($a, $b) {
return $b['average'] - $a['average'];
});
// Skriva ut HTML-raderna
foreach ($leaderboard as $entry) {
echo "<tr onclick=\"lineup(" . htmlentities($entry['id']) . ", '" . htmlentities($entry['name']) . "')\">
<td>" . htmlentities($entry['name']) . "</td>
<td>" . htmlentities($entry['antalspelare']) . "</td>
<td>" . htmlentities($entry['highestname']) . "</td>
<td>" . htmlentities($entry['average']) . "</td>
</tr>";
}
} catch (PDOException $e) {
echo $sql . "<br />" . $e->getMessage();
}
}
}