qartalonline
پنج شنبه 07 آذر 1392, 22:29 عصر
از کد زیر استفاده کنید. تقریبا کامله. البته از نظر امنیتی باید روش کار کنید.
استفاده کنید در صورت نیاز توضیح میدم.
$pdo = new PDO('mysql:dbname='. DB_DATABASE. ';host='.DB_HOST ,DB_USER ,DB_PASSWORD ,array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'));
$row_count_q = $pdo->prepare('SELECT `post`.* FROM post');
$row_count_q->execute();
$row_count = $row_count_q->rowCount(); // get all rows|posts
$item_count = 5; // count post in one page
$current_page = $_GET['page_id']; // get current page id
$link = '?page_id=:id:'; // paging link format
$start = ( ($row_count / $item_count) - $current_page) * $item_count;
$end = $start + $item_count;
$result = $pdo->prepare('SELECT `post`.* FROM post WHERE (id>' .$start. ' AND id<=' .$end. ') ORDER BY `post`.`id` DESC');
$result->execute();
/*
* echo post|content
*/
echo paging($row_count, $item_count, $current_page, $link);
function paging($total, $limit, $current_page, $link=':id:', $distance=3){
$total_page = $total / $limit;
if (is_float($total_page)) $total_page = ceil($total_page);
$result = '<li><a title="'.$current_page.'" href="'.str_replace(':id:', $current_page, $link).'" class="disabled">'.$current_page.'</a></li>'.PHP_EOL;
for ($i = $current_page+1; $i <= $current_page+$distance; $i++)
if ($i <= $total_page)
$result .= '<li><a title="'.$i.'" href="'.str_replace(':id:', $i, $link).'">'.$i.'</a></li>'.PHP_EOL;
for ($i = $current_page-1; $i >= $current_page-$distance; $i--)
if ($i >= 1)
$result = '<li><a title="'.$i.'" href="'.str_replace(':id:', $i, $link).'">'.$i.'</a></li>'.PHP_EOL.$result;
if ($current_page-$distance > 2)
$result = '<li> ... </li>'.PHP_EOL.$result;
if ($current_page+$distance < $total_page-1)
$result = $result.'<li> ... </li>'.PHP_EOL;
if ($current_page > 1) {
$previous = $current_page - 1;
$result = '<li><a title="'.$previous.'" href="'.str_replace(':id:', $previous, $link).'">‹</a></li>'.PHP_EOL.$result;
}
if ($current_page < $total_page) {
$next = $current_page + 1;
$result = $result.'<li><a title="'.$next.'" href="'.str_replace(':id:', $next, $link).'">›</a></li>'.PHP_EOL;
}
if ($current_page-$distance > 1)
$result = '<li><a title="1" href="'.str_replace(':id:', '1', $link).'">« اولی</a></li>'.PHP_EOL.$result;
if ($current_page+$distance < $total_page)
$result = $result.'<li><a title="'.$total_page.'" href="'.str_replace(':id:', $total_page, $link).'">آخری »</a></li>'.PHP_EOL;
return '<div class="paging"><ul>'.PHP_EOL.$result.'</ul>'.PHP_EOL.'<div>تعداد کل صفحات : <strong>'.$total_page.'</strong> صفحه</div>'.PHP_EOL.'</div>';
}