<?php
Class conn{
function __construct () {
Require ("config.php");
$conn = @mysql_connect ($host, $root, $pass);
@mysql_select_db ($DB);
if (! $conn) {
echo "Cannot connect". Mysql_errno (). ":" . Mysql_error ();
Exit
}
}
function query ($sql) {
$result = @mysql_query ($sql);
if (! $result) {
Echo Mysql_errno (). ":". Mysql_error ();
Exit
}
return $result;
}
function Next ($result) {
Return @mysql_fetch_array ($result);
}
function Count_row ($result) {
$row = @mysql_num_rows ($result);
return $row;
}
function Close ($result) {
@mysql_free_result ($result);
@mysql_close ();
}
}
Class Fenye extends conn{
Public $sql;
Public $page;
Public $countpage;
Public $pagesize;
public $result;
function __construct ($sql, $page, $pagesize) {
$this->sql = $sql;
$this->page = $page;
$this->countpage = $countpage;
$this->pagesize = $pagesize;
Parent::__construct ();
$result = Parent::query ($sql);
$num = Parent::count_row ($result);
$this->countpage = ceil ($num/$pagesize);
$a = ($page-1) * $pagesize;
$limit = "Limit $a, $pagesize";
$this->sql = $sql. $limit;
$this->result = parent::query ($this->sql);
}
function Getlimit () {
return $this->sql;
}
function Next () {
Return Parent::next ($this->result);
}
function Foor () {
$a = $this->page-1;
$b = $this->page +1;
if ($this->page = = 1) {
echo "Home". "";
}else echo "<a href= '" page=1 ' > Home </a> "."
if ($this->page >1)
echo "<a href= '" page= $a ' > Prev </a> '. "";
else echo "Up page";
For ($i =1 $i <= $this->countpage; $i + +) {
echo "<a href= ' page= $i ' > $i </a>". "";
}
if ($this->page < $this->countpage)
echo "<a href= ' page= $b ' > next page </a>". "";
else echo "next page";
if ($this->page = = $this->countpage) {
echo "Last". "";
}else echo "<a href=" page= $this->countpage ' > Last </a> ';
#######################
}
}
####################
if (Isset ($_get[' page ')) {
$page = $_get[' page '];
}else $page = 1;
$sql = "SELECT * from Guestbook";
$pagesize = 3;
$p = new Fenye ($sql, $page, $pagesize);
$sql = $p->getlimit ();
$result = $p->query ($sql);
while ($row = $p->next ()) {
echo $row [' ID ']. <br> ";
}
$p->foor ();
$p->close ($result);
?>