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
session_start();
$user_id= $_SESSION['id'];
$rowNumber=0;
$db = mysqli_connect('localhost', 'root', '', 'qrp');
$sql = "SELECT * FROM tickets WHERE user_id='$user_id'";
$result = mysqli_query($db, $sql);
$row= mysqli_fetch_assoc($result);
htmlspecialchars($row['subject']);
htmlspecialchars($row['content']);
htmlspecialchars($row['type']);
htmlspecialchars($row['status']);
/**
* haal de informatie alleen op
*/
?>
<!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="planning.php">FAQ</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>
<tr>
<th>Subject</th>
<th>Content</th>
<th>Type</th>
<th>Status</th>
</tr>
<?php
foreach ($result as $row){
$rowNumber++;
?>
<tr class="<?= $rowNumber % 2 == 0 ? "even": "odd"?>">
<td><?=$row['subject']?></td>
<td><?=$row['content']?></td>
<td><?=$row['type']?></td>
<td><?=$row['status']?></td>
<td>
<a class="edit" href="ticketedit.php?id=<?=$row['ticket_id']?>">Edit</a>
</td>
<?php
if ($_SESSION['id'] === $row['user_id']){
?>
<td>
<a class="delete" href="ticketdelete.php?id=<?=$row['ticket_id']?>">Delete</a>
</td>
</tr>
<?php
}}
mysqli_close($db);
?>
</table>
</div>
</div>
</body>
</html>