= '$start_dt' AND entry_dt <= '$end_dt'"; $check = dbSelect($query); if(!$check){ header("Location: /blog"); exit; } $type = "date"; } ?> Blog /
recent posts
setSelects("*"); $r->setTables("blog"); $r->setOrder("entry_dt DESC"); $r->setWhere("status = 'published'"); $r->setLimit("0, 5"); $query = $r->buildQuery(); $d = dbSelect($query); if($d){ echo "
    "; foreach($d as $v){ echo "
  • "; echo "$v[name]"; echo "
    • "; } echo "
"; } ?>
past posts
setSelects("*"); $r->setTables("blog"); $r->setOrder("entry_dt DESC"); $r->setWhere("status = 'published'"); $r->setLimit("5, 999999"); $query = $r->buildQuery(); $d = dbSelect($query); if($d){ echo "
    "; foreach($d as $v){ echo "
  • "; echo "$v[name]"; echo "
    • "; } echo "
"; } ?>
setSelects("*"); $r->setTables("blog"); $r->setOrder("entry_dt DESC"); $r->setWhere("status = 'published'"); $r->setLimit("0, 7"); $query = $r->buildQuery(); $d = dbSelect($query); $first = true; if($d){ foreach($d as $v){ echo "
"; echo "
"; if(file_exists(IMG_PATH . $v['main_img_fn']) && $v['main_img_fn'] != ""){ echo ""; } echo "
"; echo "
"; echo "
"; echo "" . strtoupper($v[name]) . ""; echo "
"; echo "
"; echo strtoupper(date("F j, Y", strtotime($v['entry_dt']))); echo "
"; echo $v['teaser']; echo "
read more"; echo "
"; echo "
"; } } ?>
    $year"; } ?>
  • " >
setSelects("*"); $r->setTables("blog"); $r->setOrder("entry_dt DESC"); $r->setWhere("status = 'published'"); if($type == "date"){ $r->setWhere("entry_dt >= '$start_dt'"); $r->setWhere("entry_dt <= '$end_dt'"); } $query = $r->buildQuery(); $p = new Paginate; $p->setQuery($query); $p->setPerPage(5); $p->getNav($paginate); $navLinks = $p->getNavLinks(); $queryNew = $p->getQueryNew(); $totalRows = $p->getTotalRows(); $totalPages = $p->getTotalPages(); $d = dbSelect($queryNew); $first = true; if($d){ foreach($d as $v){ if($first){ if(file_exists(IMG_PATH . $v['main_img_fn']) && $v['main_img_fn'] != ""){ echo ""; } } echo "
"; echo "
"; echo "" . strtoupper($v[name]) . ""; echo "
"; echo "
"; echo strtoupper(date("F j, Y", strtotime($v['entry_dt']))); echo "
"; ?>
"; $first = false; } } $text = ob_get_contents(); ob_end_clean(); $c = new contentBox; $c->set('text', $text); $c->set('left', $left); $c->set('topCode', ""); $c->printGo(); $leftCol = ob_get_contents(); ob_end_clean(); /***************** LEFT SIDEBAR END */ /***************** MAIN */ ob_start(); include 'tpl_rightCol.php'; $mainCol = ob_get_contents(); ob_end_clean(); /***************** MAIN END */ $layout = new Layout; $layout->setParam("leftCol", $leftCol); $layout->setParam("mainCol", $mainCol); $layout->twoCol(); ?>