l104/H17/bericht.php


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

$id = $_GET['id'];
?>

<!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;
        }
    </style>
    
</head>
<body>
    <?php include('menu.php');?>
    <?php  
    $query = "SELECT * FROM berichten WHERE id = $id";
    $result = mysqli_query($db, $query);
    $row = mysqli_fetch_array($result);

    $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[aan]";
    $result2 = mysqli_query($db, $query2);
    $row2 = mysqli_fetch_array($result2);

    if(!$row['gelezen'] && $row['aan'] == id()){
        $query3 = "UPDATE berichten SET gelezen = 1 WHERE id = $id";
        mysqli_query($db, $query3);
    }


    echo "<h2>Onderwerp: $row[onderwerp]</h2>";
    echo "<div>Van $row1[voornaam] $row1[tv] $row1[achternaam] ($row1[gebruikersnaam])
    <br>Aan $row2[voornaam] $row2[tv] $row2[achternaam] ($row2[gebruikersnaam])</div>";
    echo "<div>Verzonden: $row[verzonden]</div>";
    echo "<div><button onclick='beantwoord()'>Beantwoorden</button></div>";
    echo '<br>
    <br>';
    echo '<h3>Bericht</h3>';
    echo "<div>".nl2br($row['tekst'])."</div>";


    ?>
<script>
    function beantwoord(){
        document.location = 'nieuw.php?re=<?php echo $id?>';
    }
</script>
   
</body>
</html>
Resultaat

Made by Thijs Aarnoudse