'17',
':cat' => '%'.$cat.'%'
);
$query = $dbh->prepare("SELECT COUNT(*) as num FROM $tbl_name where content_category_id = :catid AND sme_category LIKE :cat");
$query->execute($arrayParam);
$return = $query->fetch(PDO::FETCH_ASSOC);
$total_pages = $return['num'];
} else {
$arrayParam = array(
':catid' => '17'
);
$query = $dbh->prepare("SELECT COUNT(*) as num FROM $tbl_name where content_category_id = :catid");
$query->execute($arrayParam);
}
$return = $query->fetch(PDO::FETCH_ASSOC);
$total_pages = $return['num'];
/* Setup vars for query. */
$targetpage = "sme-all-designs.html"; //your file name (the name of this file)
$limit = 9; //how many items to show per page
$page = $_GET['page'];
if($page) {
$start = ($page - 1) * $limit; //first item to display on this page
} else {
$start = 0; //if no page var is given, set start to 0
}
/* Get data. */
if(isset($_GET['cat']) && $_GET['cat'] != "all"){
$cat = $_GET['cat'];
$arrayParam = array(
':catid' => '17',
':cat' => '%'.$cat.'%'
);
$startLimit = (int)$start;
$endLimit = (int)$limit;
$query = $dbh->prepare("SELECT * FROM $tbl_name where content_category_id = :catid AND sme_category LIKE :cat LIMIT $startLimit, $endLimit" );
$query->execute($arrayParam);
} else {
$cat = "all";
$arrayParam = array(
':catid' => '17'
);
$startLimit = (int)$start;
$endLimit = (int)$limit;
$query = $dbh->prepare("SELECT * FROM $tbl_name where content_category_id = :catid LIMIT $startLimit, $endLimit" );
$query->execute($arrayParam);
}
$result = $query->fetchAll();
/* Setup page vars for display. */
if ($page == 0) $page = 1; //if no page var is given, default to 1.
$prev = $page - 1; //previous page is page - 1
$next = $page + 1; //next page is page + 1
$lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up.
$lpm1 = $lastpage - 1; //last page minus 1
/*
Now we apply our rules and draw the pagination object.
We're actually saving the code to a variable in case we want to draw it more than once.
*/
$pagination = "";
if($lastpage > 1)
{
$pagination .= "
";
//previous button
if ($page > 1)
$pagination.= "
The quality outsourcing services we have provided our clients these past years can give you a
clear perspective on what exactly can Prime Outsourcing do for you.
![<?php echo $row['title'] ?>](http://primeoutsourcing.com/tutorials/public/upload/sme/<?php echo $row['file_name'] ?>)