News
-
query("SELECT * from wp_posts WHERE post_status = 'publish' AND post_type = 'post' ORDER BY post_modified DESC");
$result = $query->fetchAll(PDO::FETCH_CLASS);
$maxLetters = 300;
$postTitle = "";
$postContent = "";
$counter = 1;
foreach ($result as $row) {
$postTitle = $row->post_title;
$postContent = strip_tags($row->post_content);
$postReadMore = $row->guid;
$mydate = date('m/d/y', strtotime($row->post_modified));
while (strpos(" ".$postContent,"[")>0) {
if (strpos($postContent,"[")>0) {
$temppostContent = substr($postContent,0,strpos($postContent,"["));
} else {
$temppostContent = "";
}
$postContent = $temppostContent.ltrim(substr($postContent,strpos($postContent,"]")+1));
}
if (strlen($postContent) > $maxLetters) {
$postContent = substr($postContent, 0, $maxLetters);
$postContent = substr($postContent,0,strrpos($postContent," "));
$postContent = $postContent."…";
}
if ($counter%2==0) {
$bcolor = "#59bed3; color: #000000;";
} else {
$bcolor = "#05A0BE;";
}
echo "
- ".$mydate."
".$postTitle."".$postContent. "Read More ";
$counter = $counter+1;
if ($counter>6) break;
}
mysql_close($conn);
?>