l104/H17/uit.php


<?php
include ('../dbpepijn.php');
include ('functions.php');

if (isset($_GET['vw'])){
    $id = $_GET['vw'];
    $query = "DELETE FROM berichten WHERE id = $id";
    mysqli_query($db, $query);
    echo "<script>document.location = 'uit.php'</script>";
}



?>

<!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;
        }
        table td.knop, table th.knop {
            border-bottom: 0px 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 Uit</h2>
    <?php include('menu.php');?>
    

    <table>
        <tr>
            <th>Aan</th>
            <th>Onderwerp</th>
            <th>Verzonden</th>
        </tr>

        <?php
        $query = "SELECT * FROM berichten WHERE van = ". id(). " ORDER BY `verzonden` DESC";
        $result = mysqli_query($db, $query);
        while ($row = mysqli_fetch_array($result)) {
            $query1 = "SELECT * FROM leden WHERE id = $row[aan]";
            $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(!$row['gelezen']){
                echo "<tr id=$row[id]>
                    <td><b>$row1[voornaam] $row1[tv] $row1[achternaam] ($row1[gebruikersnaam])</b></td>
                    <td><b><a href='bericht.php?id=$row[id]'>$row[onderwerp]</a></b></td>
                    <td><b>$row[verzonden]</b></td>
                    <td class='knop'><button onclick='verwijder($row[id])'>Verwijderen</button>
                    <button onclick='bewerk($row[id])'>Bewerken</button></td>
                </tr>\n";
            }
            else {
                echo "<tr id=$row[id]>
                    <td>$row1[voornaam] $row1[tv] $row1[achternaam] ($row1[gebruikersnaam]) </td>
                    <td><a href='bericht.php?id=$row[id]'>$row[onderwerp]</a></td>
                    <td>$row[verzonden]</td>
                </tr>\n";
            }


            

        }

        ?>


    <script>
        function verwijder(id){
            if (confirm('Weet u zeker dat u dit bericht wilt verwijderen?')){
                document.location = 'uit.php?vw=' + id;
            }
        }
        function bewerk(id){
            document.location = 'nieuw.php?bw=' + id;
        }
    </script>
    </table>

    
</body>
</html>
Resultaat

Made by Thijs Aarnoudse