prepare('SELECT stats_news FROM fc_stats LIMIT 1;'); $select->execute(); $result = $select->fetch(PDO::FETCH_ASSOC); $stats = $result["stats_news"]++; $select = $dbh->prepare('UPDATE fc_stats SET stats_news = ? LIMIT 1;'); $select->execute([$stats]); $date = date("F j, Y"); if ((isset($_SESSION["fc_addnews_title"])) && (isset($_SESSION["fc_addnews_article"])) && ($_SESSION["fc_admin"] == 1)) { $title = $_SESSION["fc_addnews_title"]; $body = $_SESSION["fc_addnews_article"]; $image = $imagealign = $link = $linkname = ''; if (isset($_SESSION["fc_addnews_image"])) {$image = $_SESSION["fc_addnews_image"];} if (isset($_SESSION["fc_addnews_imagealign"])) {$imagealign = $_SESSION["fc_addnews_imagealign"];} if (isset($_SESSION["fc_addnews_link"])) {$link = $_SESSION["fc_addnews_link"];} if (isset($_SESSION["fc_addnews_linkname"])) {$linkname = $_SESSION["fc_addnews_linkname"];} $insert = $dbh->prepare('INSERT INTO fc_news (news_user, news_date, news_title, news_body, news_image, news_imagealign, news_link, news_linkname) VALUES (?,?,?,?,?,?,?,?);'); $insert->execute([$_SESSION["fc_handle"],$date,$title,$body,$image,$imagealign,$link,$linkname]); } ?> Family Chores - Ideas and inspiration for families with children.
FamilyChores.com Logo
 
About Family Chores
How Family Chores Works
Family Chores Blog
Family Chores Contact Page
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 '
'; foreach ($results as $row) { echo ''; } echo '
TitleAuthorDate Posted
' . $row["news_title"] . ' ' . $row["news_user"] . ' ' . $row["news_date"] . '

'; } } 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"]]); } } ?>
Links of Interest

Try Family Chores for Free
';} ?>
Family Chores Home Page
About Family Chores
How Family Chores Works
Family Chores Blog
Family Chores Contact Page
Family Chores Privacy and Terms of Use
Family Chores Frequently Asked Questions
Copyright 2009 Family Chores