Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <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 id = "reportedPlayerContainer" class = "reportedPlayerContainer">
- </div>
- </div>
- <div class="actionWrapper">
- <a class="action" onclick = "adminJail()">
- Adminjail
- </a>
- </div>
- <div id = "playbackWrapper" class = "playbackWrapper">
- </div>
- <script src="script.js"></script>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement