<main>
<?php
include 'header.php';
include 'navi.php';
session_start();
$db = new Datenbank();
$mysqli = $db->verbindung();
$youtube = "";
$homepage = "";
$forum = "";
$tipps = "";
if (isset($_GET['idgame'])) {
$gameid = $_GET['idgame'];
}
$query = "SELECT * FROM games WHERE gameid = ?";
if ($statement = $mysqli->prepare($query)) {
$statement->bind_param("i", $gameid);
$statement->execute();
$result = $statement->get_result();
if (($row = $result->fetch_assoc()) != null) {
$youtube = $row['youtube'];
$homepage = $row['homepage'];
$forum = $row['forum'];
$tipps = $row['tipps'];
}
} else {
echo "Keine Links in der Datenbank";
}
include 'content.php';
if (strlen($youtube) != 0) {
?>
