<?php require_once "php/DatabaseConnection.php"; session_start(); $db = new DatabaseConnection(); /* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ $_SESSION['gameInProgress'] = true; $db->change("INSERT INTO gamedata (gamedata,gameId) VALUES (:gamedata,:gameId)", array(":gamedata" => json_encode($_POST['gameObject']), ":gameId" => $_POST['gameId']));
<?php require_once "php/DatabaseConnection.php"; $db = new DatabaseConnection(); $result = $db->get("SELECT * FROM games WHERE id=:id", array(":id" => $_POST['gameId'])); if ($result[0]['guests'] == "") { $guests = ""; } else { $guests = explode(",", $result[0]['guests']); foreach ($guests as $key => $guest) { if ($guest == $_POST['player']) { unset($guests[$key]); } } $guests = array_values($guests); if (count($guests) == 0) { $guestList = ""; } else { $guestList = $guests[0]; for ($i = 1; $i < count($guests); $i++) { $guestList .= "," . $guests[$i]; } } } $db->change("UPDATE games SET guests=:guests WHERE id=:id", array(":id" => $_POST['gameId'], ":guests" => $guestList));
<?php session_start(); require_once "php/DatabaseConnection.php"; $db = new DatabaseConnection(); $db->change("INSERT INTO gamedata (gameId,gamedata) VALUES (:gameId,:gamedata)", array(":gameId" => $_SESSION['gameId'], "gamedata" => $_POST['gameObject']));
<?php session_start(); require_once "php/DatabaseConnection.php"; $db = new DatabaseConnection(); $result = $db->get("SELECT * FROM games WHERE id=:id", array(":id" => $_SESSION['gameId'])); $result = $result[0]['guests']; $result = explode(",", $result); foreach ($result as $key => $guest) { if ($guest == $_SESSION['username']) { unset($result[$key]); } } $result = array_values($result); if (count($result) > 0) { $guests = $result[0]; for ($i = 1; $i < count($result); $i++) { $guests .= "," . $result[$i]; } } else { $guests = ""; } $db->change("UPDATE games SET guests=:guests WHERE id=:id", array(":id" => $_SESSION['gameId'], ":guests" => $guests)); unset($_SESSION['username']); unset($_SESSION['gameId']);
<?php session_start(); require_once "php/DatabaseConnection.php"; $db = new DatabaseConnection(); $results1 = $db->get("SELECT * FROM games WHERE gameName=:gameName", array(":gameName" => $_POST['gameName'])); $results2 = $db->get("SELECT * FROM games WHERE hostName=:hostName", array(":hostName" => $_POST['hostName'])); if (count($results1) > 0) { echo "gameName"; //JSON_encode(array("status"=>"gameName")); } else { if (count($results2) > 0) { echo "hostName"; //JSON_encode(array("status"=>"hostName")); } else { $db->change("INSERT INTO games (gameName,hostName,gameType,guests) VALUES (:gameName,:hostName,:gameType,'')", array(":hostName" => $_POST['hostName'], ":gameName" => $_POST['gameName'], ":gameType" => $_POST['gameType'])); $_SESSION['hostName'] = $_POST['hostName']; $result = $db->get("SELECT * FROM games WHERE hostName=:hostName", array(":hostName" => $_POST['hostName'])); $_SESSION['gameId'] = $result[0]['id']; echo $_SESSION['gameId']; } }
<?php session_start(); require_once "php/DatabaseConnection.php"; $db = new DatabaseConnection(); $db->change("DELETE FROM games WHERE id=:id", array(":id" => $_SESSION['gameId'])); unset($_SESSION['hostName']); unset($_SESSION['gameId']);