posts2.php

<!DOCTYPE html>
<html>
<body>
<?php
$servername = "localhost";
$username = "elad";
$password = "12345";
$dbname = "forum";

$con=mysqli_connect($servername, $username, $password, $dbname);

$id = $_GET['del'];

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " .mysqli_connect_error();
  }

$query = $query = "SELECT * FROM posts WHERE id='$id'";

$result = mysqli_query($con,$query);

  while($row= mysqli_fetch_assoc($result))
   {
    echo "<tr>";
    echo "VIEW POST:";
    echo "<BR><BR>";
    echo "POST TITLE:". "  " . "<td>" . $row['title'] . "</td>";
    echo "<BR><BR>";
    echo "AUTHER:" . "  " . "<td>" . $row['username'] . "</td>";
    echo "<BR><BR>";
    echo "THE CONTENT:";
    echo "<BR><BR>";
    echo "<td>" . $row['content'] . "</td>";
    echo "<BR><BR>";
    echo "<tr><td>" ."<a href=\"posts.php?del=".$row['id']."\">RETURN TO THE POSTS LIST !</a><br />". " </td></tr>";
    echo "</tr>";
  }
echo "</table>";

mysqli_close($con);
?>

</body>
</html>