connect_error)
{
die("Connection failed: " . $conn->connect_error);
}
$query = "SELECT title, content, extra_data, date_format(create_date, '%W, %M %d, %Y') as create_date, url FROM CMS_PAGES WHERE visible = 1 ORDER BY create_date DESC";
$result = $conn->query($query);
$strBlogHTML = '
<$HEADING$ class="blogsubject">$SUBJECT$
$IMAGE$
$DATE$
$TEXT$
';
$strHTML = '';
while ($row = $result->fetch_assoc())
{
$strItemHTML = $strBlogHTML;
$strBlogSubject = '';
if (!empty($row['url']))
{
$strBlogSubject .= '
';
}
else
{
$strBlogSubject = htmlspecialchars($row['title']);
}
$strItemHTML = str_replace('$SUBJECT$', $strBlogSubject, $strItemHTML);
$strBlogImage = '';
if (!empty($row['extra_data']))
{
$strBlogImage .= '';
}
else
{
$strItemHTML = str_replace('blogthumb', 'no-thumb', $strItemHTML);
}
$strItemHTML = str_replace('$IMAGE$', $strBlogImage, $strItemHTML);
$strItemHTML = str_replace('$DATE$', htmlspecialchars($row['create_date']), $strItemHTML);
$strItemHTML = str_replace('$TEXT$', $row['content'], $strItemHTML);
if (!empty($row['url']))
{
$strItemHTML = str_replace('$URL$', htmlspecialchars($row['url']), $strItemHTML);
}
else
{
$strItemHTML = str_replace('$URL$', '', $strItemHTML);
}
$headingTag = 'span';
$strItemHTML = str_replace('$HEADING$', $headingTag, $strItemHTML);
$strHTML .= $strItemHTML;
}
$conn->close();
echo $strHTML;
?>