Show sourcecode
The following files exists in this folder. Click to view.
admin.php
bilder/
checkUpdates.php
confirmPassword.php
confirmSignIn.php
createadmin.php
endScreen.php
getBoard.php
getChat.php
getHand.php
getTurnPlayer.php
lobbies.php
logIn.php
play.php
playCard.php
signIn.php
start.php
startsida.php
style.css
tables.php
update.php
updatePassword.php
waitInfo.php
waitingRoom.php
getTurnPlayer.php
27 lines ASCII Windows (CRLF)
<?php
/** @var PDO $dbconn */
include ("../dbconnection.php");
if (isset($_GET["gameid"])) {
$sql = "SELECT * FROM JassGames WHERE gameid=?";
$stmt = $dbconn->prepare($sql);
$data = array($_GET["gameid"]);
$stmt->execute($data);
if ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
$turnplayerid = $res["turnplayerid"];
$sql = "SELECT * FROM JassPlayers WHERE playerid=?";
$stmt = $dbconn->prepare($sql);
$data = array($turnplayerid);
$stmt->execute($data);
if ($player = $stmt->fetch(PDO::FETCH_ASSOC)) {
echo $player["username"];
}
}
}
?>