setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// select all in reverse date order and scroll through to find this one by pagename key & next for key
$sql = "SELECT * FROM blog ORDER BY blogdate DESC";
//echo $sql;
$stmt = $dbh->prepare($sql);
$stmt->execute();
$bUseNextRecordForLink = false;
$sNextPageLink = '';
$sTitle = '';
while ($row = $stmt->fetch()) {
$a++;
//$sTitle = htmlspecialchars($row['title'], ENT_QUOTES, 'utf-8');
$sTitle = $row['title'];
$sImage = $row['image'];
$sDate = $row['blogdate'];
$date = new DateTime($sDate);
$sDate = $date->format('j F Y');
//$sNextPage= '';
//echo 'a='.$a;
// echo 'pagename='.$pageName;
if ($bUseNextRecordForLink) {
//echo '
next pagename='.$sTitle;
//$bUseNextRecordForLink = false;
$sNextPage= cleanSpecialChars($sTitle);
$sNextPage1 = '"'.$sNextPage.'.html"';
$sNextPageLink = 'Next page';
$bUseNextRecordForLink = false;
//break;
}
//echo 'pageNameKey='.$sPageNameKey.', Title='.$sTitle.'
';
// strip any 'special' chars from title for match - should be same as per $sNextPage
$sTitleKey = cleanSpecialChars($sTitle);
if (($pageName == 'index' && $a == 1) || (strripos($sTitleKey,$pageName) > -1)) {
$sTitleThis = $sTitle;
$sDateThis = $sDate;
if ($sImage != '') {
$sImageLink = '
';
} else {
}
$blogtext = $row['blogtext'];
$sBlogbody= str_replace("\r\n", "
", $blogtext);
$bUseNextRecordForLink = true;
}
}
$dbh = null;
} catch (PDOException $e) {
echo "Error!: " . $e->getMessage() . "
";
die();
}
header('X-Frame-Options: SAMEORIGIN');
header('X-Content-Type-Options: nosniff');
header('X-XSS-Protection: 1; mode=block');
if ($sTitleThis == '') {
// page does not exist - return a 404
//http_response_code(404);
//header($_SERVER["SERVER_PROTOCOL"]." 404 Not Found", true, 404);
//header("HTTP/1.0 404 Not Found");
// die();
$sNextPageLink = 'Next page';
}
$sTitleSentenceCase = ucwords($sTitleThis);
echo 'Mayday Mummy - ' . $sTitleSentenceCase . '';
echo '';
//echo '';
if ($sImage != '') {
echo '';
echo '';
}
//echo '';
?>