Cakeman
Legacy Member
PHP:
if(isset($_GET['blog']) && is_numeric($_GET['blog'])) {
$query = "select id, title, content, unix_timestamp(datum) as datum from blog where id = " . $_GET['blog'];
$result = mysql_query($query) or die ("<strong>Fout bij ophalen van gegevens:</strong><br />" . mysql_error());
if(mysql_num_rows($result) <= 0) {
echo "De post is niet gevonden.";
}
else {
$obj = mysql_fetch_object($result) or die ("<strong>Fout bij het ophalen van de gegevens:</strong><br />" . mysql_error());
$datum = strftime("%a %d %B %Y - %H:%M", $obj->datum);
echo '<h1>' . $obj->title . '</h1>';
echo '<span class="postinfo">' . $datum . '</span><br />';
echo '<p>' . $obj->content . '</p>';
}
}
else {
// de 5 nieuwste blogs tonen
}
)