01.<?php
02.
03.$page = isset($_GET['page'])?$_GET['page']:1;
04.$show = 1;
05.
06.$pdo = new PDO('mysql:host=localhost;dbname=group11;charset=utf8;','group111','1234');
07.$query = $pdo->query('select * from blogs');
08.$all_blogs = $query->fetchAll(PDO::FETCH_ASSOC);
09.
10.$all = count($all_blogs);
11.$start = ($page*$show)-1;
12.$stop = $start+$show;
13.for($i=$start;$i<$stop;$i++){
14. $blogs[] = $all_blogs[$i];
15.}
16.$prev = $page-1;
17.$next = $page+1;
18.if($page == 1){
19. unset($prev);
20.}
21.if($page == $all){
22. unset($next);
23.}
24.
25.?>
Load balance : Server 03
