分頁實現

<?php
header('Content-type:text/html; charset=UTF-8');

$conn = mysql_connect('localhost', 'root', '123456') or die('connect to database error!');
mysql_select_db('xsphp') or die('select database error!');
mysql_query('SET NAMES utf8');

function showTable($name,$page=1)
{

    $eachPages = 5;
    $url = $_SERVER['PHP_SELF'];

    $sql = "SELECT count(*) as total FROM {$name}";
    $result = mysql_query($sql);
    list($rowNums) = mysql_fetch_row($result);

    $pageNums = ceil($rowNums / $eachPages);
    $rowFrom = ($page > 1) ? (($page - 1) * $eachPages) : 0;

    $sql = "SELECT id,title FROM {$name} LIMIT {$rowFrom},{$eachPages}";
    $result = mysql_query($sql);

	echo '<table align="center" width="800" border="1">';
	echo '<caption><h1>'.$name.'</h1></caption>';

    //显示标题
    $cols = mysql_num_fields($result);
    echo '<tr>';
    for ($i=0; $i<$cols; $i++) {
        echo '<th>'.mysql_field_name($result,$i).'</th>';
    }
    echo '</tr>';
    //显示记录
    while ($row = mysql_fetch_assoc($result)) {
        echo '<tr>';
        echo '<td>'.$row['id'].'</td>';
        echo '<td>'.$row['title'].'</td>';
        echo '</tr>';
    }
    //显示Page导航
    echo '<tr><td>记录共有:'.mysql_num_rows($result) . '</td><td>';
    echo ($page == 1) ? '首页' : '<a href="'.$url.'?page=1">首页</a>';
    echo '&nbsp;&nbsp;';
    echo ($page == 1) ? '上一页' : '<a href="'.$url.'?page=' . ($page - 1) . '" >上一页</a>';
    echo '&nbsp;&nbsp;';
    echo ($page == $pageNums) ? '下一页' : '<a href="'.$url.'?page='. ($page + 1) . '" >下一页</a>';
    echo '&nbsp;&nbsp;';
    echo ($page == $pageNums) ? '尾页' : '<a href="'.$url.'?page='.$pageNums.'">尾页</a>';
    echo '</td></tr></table>';
}

if (isset($_GET['page']) && $_GET['page'] > 0) {
    $page = $_GET['page'];
} else {
    $page = 1;
}

showTable('category',$page);