Webbserverprogrammering 1

Show sourcecode

The following files exists in this folder. Click to view.

webbserver/filmquiz/

api/
createroom.php
createtables.php
createuser.php
css/
dbconnection.php
game.php
index.php
login.php
logout.php
remove.php
rensa.php
results.php
waiting.php

createroom.php

27 lines UTF-8 Windows (CRLF)
<?php
include('dbconnection.php');
/** @var PDO $dbconn */

// Skapa rummets kod
$room_code "R" strval(rand(100000999999));

// Hämtar user id från session
if (isset($_SESSION['user_id'])) {
    
$user_id $_SESSION['user_id'];

    
// Skapa rummet
    
$dbconn->prepare('INSERT INTO fq_rooms (room_code, created_by) VALUES (?, ?)')->execute([$room_code$user_id]);
    
$room_id $dbconn->lastInsertId();

    
// Koppla usern till rummet
    
$dbconn->prepare('INSERT INTO fq_room_players (room_id, user_id) VALUES (?, ?)')->execute([$room_id$user_id]);
    
$_SESSION['room_code'] = $room_code;
    
$_SESSION['room_id'] = $room_id;
    
header("Location: waiting.php");
    exit;
} else {
    
// Gå till login-sidan om ingen är inloggad
    
header("Location: login.php");
    exit;
}