- nl2br: documentation ( source)
- header: documentation ( source)
<?php
require_once('config.php');
if(!$_GET['id']){
$pagetitle = 'Blogs - '.$sitename;
$qb = mysql_query("SELECT * FROM blogs") or die(mysql_error());
$qn = mysql_num_rows($qb);
require_once('header.php');
echo "<h1>Blogs</h1>";
echo '<ul>';
while($post=mysql_fetch_array($qb)){
echo '<a style="margin-top:20px;display:block;margin-left:20px;" href="blog.php?id='.$post['id'].'">'.$post['title'].'</a>';
}
echo '</ul>';
} else {
$id = mysql_real_escape_string($_GET['id']);
$qb = mysql_query("SELECT * FROM blogs WHERE id='$id'") or die(mysql_error());
$post = mysql_fetch_array($qb);
$exist = mysql_num_rows($qb);
if($exist=='1'){
$pagetitle = $post['title'].' - '.$sitename;
require_once('header.php');
echo '<h1>'.$post['title'].'</h1>';
echo '<p class="para">'.nl2br($post['content']).'</p>';
$qrm = mysql_query("SELECT * FROM blogs WHERE id<>'$id'") or die(mysql_error());
$qnrm = mysql_num_rows($qrm);
if($qnrm=='0'){
echo '<!-- no articles to read -->';
} else {
echo "<h2 class=h2>You may also Read:</h2>";
echo '<ul>';
while($post=mysql_fetch_array($qrm)){
echo '<a style="margin-top:20px;display:block;margin-left:20px;" href="blog.php?id='.$post['id'].'">'.$post['title'].'</a>';
}
echo '</ul>';
}
} else {
header("Location: index.php?msg=Blog article not found");
}
}
require_once('sidebar.php');
require_once('footer.php');
?>