l104/H17/in.php

<?php include ('../dbpepijn.php'); include ('functions.php'); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> <style> h2 { text-align: center; } .label { display: inline-block; padding: 5px; width: 100px; text-align: right; } table td, table th { border-bottom: 1px solid black; } </style> <script> window.onload = loadEvents(); function loadEvents(){ var berichten = document.querySelectorAll('tr'); for (var i = 0; i < berichten.length; i++) { berichten[i].onclick = function(){ var id = this.id; document.location = 'bericht.php?id=' + id; } } } </script> </head> <body> <h2>Postvak In</h2> <?php include('menu.php');?> <table> <?php if (gebruiker()=='admin'){ $query = "SELECT * FROM berichten ORDER BY `verzonden` DESC"; echo '<tr> <th>Van</th> <th>Aan</th> <th>Onderwerp</th> <th>Verzonden</th> </tr>'; } else{ echo '<tr> <th>Van</th> <th>Onderwerp</th> <th>Verzonden</th> </tr>'; $query = "SELECT * FROM berichten WHERE aan = ". id(). " ORDER BY `verzonden` DESC"; } $result = mysqli_query($db, $query); while ($row = mysqli_fetch_array($result)) { $query2 = "SELECT * FROM leden WHERE id = $row[aan]"; $result2 = mysqli_query($db, $query2); $row2 = mysqli_fetch_array($result2); $query1 = "SELECT * FROM leden WHERE id = $row[van]"; $result1 = mysqli_query($db, $query1); $row1 = mysqli_fetch_array($result1); $query2 = "SELECT * FROM leden WHERE id = $row[van]"; $result2 = mysqli_query($db, $query2); $row2 = mysqli_fetch_array($result2); if (gebruiker()=='admin'){$extra = "<td>$row2[voornaam] $row2[tv] $row2[achternaam] ($row2[gebruikersnaam])</td>";} else {$extra = "";} if(!$row['gelezen']){ echo "<tr id=$row[id]> <td><b>$row1[voornaam] $row1[tv] $row1[achternaam] ($row1[gebruikersnaam])</b></td> ".$extra." <td><b><a href='bericht.php?id=$row[id]'>$row[onderwerp]</a></b></td> <td><b>$row[verzonden]</b></td> </tr>\n"; } else { echo "<tr id=$row[id]> <td>$row1[voornaam] $row1[tv] $row1[achternaam] ($row1[gebruikersnaam]) </td> ".$extra." <td><a href='bericht.php?id=$row[id]'>$row[onderwerp]</a></td> <td>$row[verzonden]</td> </tr>\n"; } } ?> </table> </body> </html>

Resultaat

Made by Thijs Aarnoudse