<?php
$servername = "localhost";
$username = "";
$password = "";
$dbname = "";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT title, threadid, pagetext, forumid FROM post JOIN thread";
$result = $conn->query($sql);

if ($result->num_rows > 0 && $row["forumid"] = "2") {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        $post_clean = preg_replace('/[ \t]+/', ' ', preg_replace('/\s*$^\s*/m', "\n", strip_tags($row['pagetext'])));
        $post_convert = strtr($post_clean, array_flip(get_html_translation_table(HTML_ENTITIES, ENT_QUOTES)));
        $post = trim($post_convert, chr(0xC2).chr(0xA0));
        //$start_date = time_elapsed_string(date("D, d M Y H:i:s", $row['start_date']));
        $topic_link = "//forum.vitalityx.org/showthread.php?".$row['threadid'];
        echo '
<dt><span class="newsdate"><b>January-7-2019</span>'.$row["title"].'</b></dt>
<dd>
<table width="100%"><tr>
<td style="text-align: justify; vertical-align: top;">'.$post.'</td>
<td style="padding-left: 1em; text-align: right; vertical-align: top;">
<img width="50" height="50" src="img/news/shop_2.gif">
</td></tr></table>
<div style="margin-top: 0.5em;"><a href="'.$topic_link.'">Read more...</a></div>
        ';
    }
} else {
    echo "0 results";
}

$conn->close();
?>