Untitled

<?php
      $servername = "localhost";
      $username = "root";
      $password = "";
      $dbname = "emildeveloping6";

      // Skapa anslutning
      $conn = new mysqli($servername, $username, $password, $dbname);
      // Anslutnings Check
      if ($conn->connect_error) {
          die("Connection failed: " . $conn->connect_error);
      }

    $id = $_GET['ticketid'];

    $sql = "SELECT * FROM tickets WHERE id=$id";
$result = $conn->query($sql) or die($conn->error);

    if ($result->num_rows > 0) {
echo '
<!DOCTYPE html>
 <html lang="sv">
  <head>
   <title>Emil Developing - Ask a Question</title>

   <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1">
   	<link rel="stylesheet" type="text/css" href="css/style.css">
    <link href="https://fonts.googleapis.com/css?family=Roboto" rel="stylesheet">
    <script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
    <script src="//netdna.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/pretty-checkbox@3.0/dist/pretty-checkbox.min.css"></script>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
  	<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.6.3/css/all.css" integrity="sha384-UHRtZLI+pbxtHCWp1t77Bi1L4ZtiqrqD80Kn4Z8NTSRyMA2Fd33n5dQ8lWUE00s/" crossorigin="anonymous">
  </head>
  <body>

  <nav class="navbar navbar-expand-lg navbar-dark bg-dark">
  <a class="navbar-brand" href="#">Ask A Question</a>
  <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNavDropdown" aria-controls="navbarNavDropdown" aria-expanded="false" aria-label="Toggle navigation">
    <span class="navbar-toggler-icon"></span>
  </button>
  <div class="collapse navbar-collapse" id="navbarNavDropdown">
    <ul class="navbar-nav">
      <li class="nav-item">
        <a class="nav-link" href="index.php">Dashboard</a>
      </li>
      <li class="nav-item active">
        <a class="nav-link" href="support.php">Support <span class="sr-only">(current)</span></a>
      </li>
      <li class="nav-item">
        <a class="nav-link" href="reports.php">Reports</a>
      </li>
      <li class="nav-item">
        <a class="nav-link" href="users.php">Users</a>
      </li>
      <li class="nav-item">
        <a class="nav-link" href="statistics.php">Statistics</a>
      </li>
      <li class="nav-item">
        <a class="nav-link" href="server-status.php">Server Status</a>
      </li>
    </ul>
  </div>
</nav>
';

while($row = $result->fetch_assoc()) {
echo '
<div class="left-side-ticket">
<div class="ticket-ontop-box">
<i class="fas fa-ticket-alt"></i>
<span class="ticket-information-text">Ticket Information</span>
<br>
<br>
</div>
<div class="ticket-information-box">
<div class="ticket-creator-admin"><b>#'.$row['id'].'</b> - '.$row['username'].'</div>
<div class="ticket-department-admin"><div class="department-title-admin">Department</div>'.$row['department'].'</div>
<div class="ticket-submitted-admin"><div class="submitted-title-admin">Submitted</div>'.$row['date'].'</div>
<div class="ticket-email-admin"><div class="email-title-admin">Email</div>'.$row['email'].'</div>
<div class="ticket-status-admin"><div class="status-title-admin">Status</div>'.$row['status'].'</div>
<div class="ticket-priority-admin"><div class="priority-title-admin">Priority</div>'.$row['priority'].'</div>
</div>

<div class="button-group-ticket">
<button type="button" class="btn btn-danger main-color-button">Escalate</button>
<button type="button" class="btn btn-primary main-color-button">Close Ticket</button>
<button type="button" class="btn btn-info main-color-button">View User Profile</button>
<button type="button" class="btn btn-warning main-color-button">On Hold</button>
<hr class="button-break">
<button type="button" class="btn btn-warning main-color-button">Block User IP</button>
<button type="button" class="btn btn-warning main-color-button">Ban User</button>
<hr class="button-break">
<button type="button" class="btn btn-danger remove-account-ticket">Remove User Account</button>
</div>
</div>
';
}

echo '
<footer class="footer">&copy; Ask A Question | Powered by <a class="footer-href" href="emildeveloping.com">Emil Developing</a></footer>

</body>
</html>
';

} else {
  echo "Error";
}

$sql2 = "SELECT * FROM ticket_replies WHERE ticketid='$id' ORDER BY id ASC";
$result2 = $conn->query($sql2) or die($conn->error);

if ($result2->num_rows > 0) {
  while($row = $result2->fetch_assoc()) {
echo '
<div class="ticket-box">

<div class="box-ontop-reply-ticket">
'.$row['reply_creator'].' - <b>'.$row['reply_creator_grade'].'</b>
</div>

<div class="reply-box-ticket">
'.$row['reply'].'
</div>

</div>
';
}

} else {
  echo "Error 2";
}

$conn->close();
?>