Legenda:
index.php (de log in scherm)
session.php (dit checkt of de persoon die inlogt admin is)
planning.php (de ticket overzicht voor de user)
board.php (de ticket overzicht voor de admin)
user.php (de users overzicht voor de admin)
<?php
require "session.php" ;
$db = mysqli_connect('localhost', 'root', '', 'qrp');
$sql = "SELECT * FROM tickets WHERE status='Not Done'";
$result = mysqli_query($db, $sql);
$row= mysqli_fetch_assoc($result);
$sql = "SELECT * FROM tickets WHERE status='Pending'";
$result2 = mysqli_query($db, $sql);
$row2= mysqli_fetch_assoc($result2);
$sql = "SELECT * FROM tickets WHERE status='In Progress'";
$result3 = mysqli_query($db, $sql);
$row3= mysqli_fetch_assoc($result3);
$sql = "SELECT * FROM tickets WHERE status='Done'";
$result4 = mysqli_query($db, $sql);
$row4= mysqli_fetch_assoc($result4);
htmlspecialchars($row['subject']);
htmlspecialchars($row['type']);
?>
<!DOCTYPE html>
<html>
<link href="css/style.css" type="text/css" rel="stylesheet">
<head>
</head>
<body>
<div class="wrapper">
<div class="banner">
<nav>
<a id="home-button2" class="nav-buttons" href="planning.php">Quick Response Portal</a>
<a class="nav-buttons" href="board.php">Board</a>
<a class="nav-buttons" href="user.php">Users</a>
<a id="sign-out" href="logout.php">Log Out</a>
</nav>
</div>
<div class="second-nav">
<a class="add" href="ticketinsert.php">Add Ticket</a>
</div>
<div class="users">
<table class="table-not-done">
<tr>
<th>Not Done</th>
</tr>
<?php
foreach ($result as $row) {
?>
<tr>
<td>
<div class="board-box">
<a class="board-link" href="ticket.php?id=<?= $row['ticket_id'] ?>">
<div class="board-subject">
<span>Subject:</span> <span><?= $row['subject'] ?></span>
</div>
<br>
<div class="board-content">
<span> Content:</span>
<span><?= $row['content'] ?></span>
</div>
<br>
<div class="board-type">
<span>Type:</span> <span><?= $row['type'] ?></span>
</div>
</a>
</div>
</td>
</tr>
<?php
}
?>
</table>
<table class="table-pending">
<tr>
<th>Pending</th>
</tr>
<?php
foreach ($result2 as $row2) {
?>
<tr>
<td>
<div class="board-box">
<a href="ticket.php?id=<?= $row2['ticket_id'] ?>">
<div class="board-subject">
<span>Subject:</span> <span><?= $row2['subject'] ?></span>
</div>
<br>
<div class="board-content">
<span> Content:</span>
<span><?= $row2['content'] ?></span>
</div>
<br>
<div class="board-type">
<span>Type:</span> <span><?= $row2['type'] ?></span>
</div>
</a>
</div>
</td>
</tr>
<?php
}
?>
</table>
<table class="table-in-progress">
<tr>
<th>In Progress</th>
</tr>
<?php
foreach ($result3 as $row3) {
?>
<tr>
<td>
<div class="board-box">
<a href="ticket.php?id=<?= $row3['ticket_id'] ?>">
<div class="board-subject">
<span>Subject:</span> <span><?= $row3['subject'] ?></span>
</div>
<br>
<div class="board-content">
<span> Content:</span>
<span><?= $row3['content'] ?></span>
</div>
<br>
<div class="board-type">
<span>Type:</span> <span><?= $row3['type'] ?></span>
</div>
</a>
</div>
</td>
</tr>
<?php
}
?>
</table>
<table class="table-done">
<tr>
<th>Done</th>
</tr>
<?php
foreach ($result4 as $row4) {
?>
<tr>
<td>
<div class="board-box">
<a href="ticket.php?id=<?= $row4['ticket_id'] ?>">
<div class="board-subject">
<span class>Subject:</span> <span><?= $row4['subject'] ?></span>
</div>
<br>
<div class="board-content">
<span> Content:</span>
<span><?= $row4['content'] ?></span>
</div>
<br>
<div class="board-type">
<span>Type:</span> <span><?= $row4['type'] ?></span>
</div>
</a>
</div>
</td>
</tr>
<?php
}
mysqli_close($db);
?>
</table>
</div>
</div>
</body>
</html>