NarKampen/dbFiles/NewOnlineGame.php

<?php
	error_reporting( E_ALL );
	$hostname = 'localhost';
	$username = 'narKampen';
	$pass = 'narKampenPassword';
	$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'];
	
	$playerIdsArray = explode(",",$playerIds);
	
	$sql = "INSERT INTO game(" .
            "gameMode, " .
            "winNumber, " .
            "answerTimer, " .
            "roundTimeLimit, " .
            "numberOfPlayers, " .
            "currentPlayer, " .
            "round, " .
            "startedDate) " .
            "VALUES (" .
            "'Online', " .
            "$winNumber, " .
            "$limitPerQuestion, " .
            "$limitPerPlayer, " .
            count($playerIdsArray) . ", " .
            "(SELECT username 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;
	}
	
?>