NarKampen/dbFiles/NewOnlineGame.php

<?php
	error_reporting( E_ALL );
	$hostname = 'localhost';
	$username = 'narKampen';
	$pass = 'IfRLzj2HJBXA9eei';
	$database = 'narKampen';

	$conn = new mysqli($hostname, $username, $pass, $database);
	
	if (!$conn) {
		die("Connection Failed. ". mysqli_connect_error());
	}
	mysqli_set_charset($conn,'utf8');
	
	$winNumber = $_POST['winNumber'];
	$limitPerQuestion = $_POST['limitPerQuestion'];
	$limitPerPlayer = $_POST['limitPerPlayer'];
	$playerIds = $_POST['playerIds'];
	$currentUser = $_POST['currentUser'];
	$functionName = $_POST['f'];
	
	if ($functionName === "NewGame") {
		$playerIdsArray = explode(",",$playerIds);
		$playerCount = count($playerIdsArray);
		if ($playerCount == 1) {
			$status = "STARTED";
		} else {
			$status = "PENDING";
		}
		$sql = "INSERT INTO game(" .
				"gameMode, " .
				"status, " .
				"winNumber, " .
				"answerTimer, " .
				"roundTimeLimit, " .
				"numberOfPlayers, " .
				"currentPlayer, " .
				"round, " .
				"startedDate) " .
				"VALUES (" .
				"'Online', " .
				"'$status', " .
				"$winNumber, " .
				"$limitPerQuestion, " .
				"$limitPerPlayer, " .
				"$playerCount, " .
				"(SELECT id FROM users WHERE id IN ($playerIds) ORDER BY RAND() LIMIT 1), " .
				"1, " .
				"NOW())";
		
		$result = mysqli_query($conn, $sql);
		$error = mysqli_error($conn);
		if ($error !== "") {
			echo $error;
		}
		$gameId = mysqli_insert_id($conn);
		$playerPartInsertSql = "";
		foreach ($playerIdsArray AS $playerId) {
			if ($currentUser == $playerId) {
				$playerPartInsertSql .= "($gameId, $playerId, 1, 1, 'ACCEPTED'),";
			} else {
				$playerPartInsertSql .= "($gameId, $playerId, 1, 1, 'WAITING'),";
			}
		}
		$playerPartInsertSql = rtrim($playerPartInsertSql,",");
		$playerSql = "INSERT INTO gamePlayers (gameId, playerId, userLockedQuestions, questionsLost, status) VALUES $playerPartInsertSql";
		
		$result = mysqli_query($conn,$playerSql);
		$error = mysqli_error($conn);
		
		echo $gameId;
		if ($error !== "") {
			echo $error . " from sql " . $playerSql;
		}
	} else if ($functionName === "GetCategories") {
		$sql = "SELECT category.name as name, count(*) as num FROM questions INNER JOIN questionToCategory ON questions.id = questionToCategory.questionId INNER JOIN category ON questionToCategory.categoryId = category.id GROUP BY category.name"
		$result = $conn->query($sql);
		$json = array();
		while ($row = $result->fetch_assoc()) {
			$json = array('name' => $row['name'],
						'value' => $row['value']);
			$jsonString = json_encode($json);

			echo $jsonString;
		}
	}

?>