Your News Has Been Posted';}
unset($_SESSION["fc_addnews_title"]);
unset($_SESSION["fc_addnews_article"]);
if (isset($_SESSION["fc_addnews_image"]))
{unset($_SESSION["fc_addnews_image"]);}
if (isset($_SESSION["fc_addnews_imagealign"]))
{unset($_SESSION["fc_addnews_imagealign"]);}
if (isset($_SESSION["fc_addnews_link"]))
{unset($_SESSION["fc_addnews_link"]);}
if (isset($_SESSION["fc_addnews_linktitle"]))
{unset($_SESSION["fc_addnews_linktitle"]);}
if ((!isset($_GET["article"])) || (!is_numeric($_GET["article"])))
{
echo '
Latest News from Family Chores
';
$select = $dbh->prepare('SELECT * FROM fc_news ORDER BY news_id DESC LIMIT 5;');
$select->execute();
$results = $select->fetchAll(PDO::FETCH_ASSOC);
$newscount = 0;
if (count($results) > 0)
{
foreach($results as $row)
{
$newscount++;
echo '
';
if ($newscount == 1)
{echo '' . $row["news_title"] . '';}
else if ($newscount == 2)
{echo '' . $row["news_title"] . '';}
else if ($newscount == 3)
{echo '' . $row["news_title"] . '';}
else
{echo $row["news_title"];}
echo ' |
| Posted by ' . $row["news_user"] . ' on ' . $row["news_date"] . ' |
';
echo '
';
if (($row["news_image"] != '') && ($row["news_imagealign"] != 1))
{
echo '
';
}
echo nl2br($row["news_body"]) . '
';
if (($row["news_image"] != '') && ($row["news_imagealign"] == 1))
{echo '
';}
if ((isset($row["news_link"])) && ($row["news_link"] != ''))
{
if (isset($row["news_linkname"]))
{echo '
' . $row["news_linkname"] . '
';}
else
{echo '
Link of Relevance
';}
}
echo '
';
}
echo '
';
$select = $dbh->prepare('SELECT * FROM fc_news ORDER BY news_id DESC LIMIT 200 OFFSET 5;');
$select->execute();
$results = $select->fetchAll(PDO::FETCH_ASSOC);
$newscount = 0;
if (count($results) > 0)
{
echo '
Older Articles ...
';
echo '
| Title | Author | Date Posted |
';
foreach ($results as $row)
{
echo '
| ' . $row["news_title"] . ' |
' . $row["news_user"] . ' |
' . $row["news_date"] . ' |
';
}
echo '
';
}
}
else
{ echo '
Currently We Have No News';}
}
else
{
echo '
Archived News from Family Chores
';
$select = $dbh->prepare('SELECT * FROM fc_news WHERE news_id = ? LIMIT 1;');
$select->execute([$_GET["article"]]);
$row = $select->fetch(PDO::FETCH_ASSOC);
if (is_array($row) && !empty($row))
{
echo '
' . $row["news_title"] . ' |
| Posted by ' . $row["news_user"] . ' on ' . $row["news_date"] . ' |
';
echo '
';
if (($row["news_image"] != '') && ($row["news_imagealign"] != 1))
{
echo '
';
}
echo nl2br($row["news_body"]) . '
';
if (($row["news_image"] != '') && ($row["news_imagealign"] == 1))
{echo '
';}
if ((isset($row["news_link"])) && ($row["news_link"] != ''))
{
if (isset($row["news_linkname"]))
{echo '
' . $row["news_linkname"] . '
';}
else
{echo '
Link of Relevance
';}
}
echo '
';
$views = $row["news_visits"] + 1;
$update = $dbh->prepare('UPDATE fc_news SET news_visits = ? WHERE news_id = ? LIMIT 1;');
$update->execute([$views,$_GET["article"]]);
}
}
?>