title; ?>
contents)), 0, 140).'...'; ?>
prepare($sql1);
$query1->execute();
$results=$query1->fetchAll(PDO::FETCH_OBJ);
$total = $results[0]->ids;
$limit = 5;
$pages = ceil($total / $limit);
// Calculate the offset for the query
$offset = ($page - 1) * $limit;
// Some information to display to the user
$start = $offset + 1;
$end = min(($offset + $limit), $total);
// The "back" link
$prevlink = ($page > 1) ? ' ' : '';
// The "forward" link
$nextlink = ($page < $pages) ? ' ' : '';
// Display the paging information
$paginate = '';
// Prepare the paged query
$sql = "SELECT * from posts WHERE status = 0 AND pstatus = 0 ORDER BY date_posted DESC LIMIT $limit OFFSET $offset ";
$query = $dbh -> prepare($sql);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
if($query->rowCount() > 0)
{
foreach($results as $result)
{
?>
date_posted)); ?>
', $e->getMessage(), '';
} ?>