Untitled

<html>
    <head>
        <link  href = "style.css"  rel="stylesheet" type="text/css" />
    </head>
    <body>
        <?php
            function setupConnection(){
                $servername = "p:localhost";
                $username = "root";
                $password = "";
                $dbname = "saesreports";
                $port = 3306;

                set_error_handler(function() { /* ignore errors */ });
                try {
                    $connection = new mysqli($servername, $username, $password, $dbname, $port);
                    return $connection;
                } catch (Exception $e){
                    echo ("Database connection failed.");
                    return;
                }
                restore_error_handler();
            }

            function listReports(){
                $connection = setupConnection();
                $query = "
                    SELECT id, subject
                    FROM report
                    ORDER BY id ASC;";
                $results = $connection->query($query);

                while($row = $results->fetch_assoc()) {
                    $subject = $row["subject"];
                    $id = $row["id"];
                    echo "<a onclick = 'selectReport(" . $id . ")' >" . $subject . "</a>";
                }
                return $users;
            }
        ?>


        <div class="leftColumn">
            <div class="listTitle">Reports</div>
            <div class="reportList" >
                <?php listReports() ?>
            </div>
        </div>
        <div class="reportField">
            <div class = "fieldContainer">
                <div id = "reportSubject"></div>
                <div id = "reportCategory"></div>
                <div id = "reportMessage"></div>
                <div class="actionWrapper">
                    <a class="action" onclick = "adminJail()">
                        Adminjail
                    </a>
                </div>
            </div>
            <div id = "reportedPlayerContainer" class = "reportedPlayerContainer">
            </div>
            <div id = "playbackWrapper" class = "playbackWrapper">
            </div>
            <script src="script.js"></script>
        </div>
    </body>
</html>