分页实现

1. header('Content-type:text/html; charset=UTF-8');
3. $conn = mysql_connect('localhost', 'root', '123456') or die('connect to database error!');
4. mysql_select_db('xsphp') or die('select database error!');
5. mysql_query('SET NAMES utf8');
7. function showTable($name,$page=1)
8. {
10. $eachPages = 5;
11. $url = $_SERVER['PHP_SELF'];
13. $sql = "SELECT count(*) as total FROM {$name}";
14. $result = mysql_query($sql);
15. list($rowNums) = mysql_fetch_row($result);
17. $pageNums = ceil($rowNums / $eachPages);
18. $rowFrom = ($page > 1) ? (($page - 1) * $eachPages) : 0;
20. $sql = "SELECT id,title FROM {$name} LIMIT {$rowFrom},{$eachPages}";
21. $result = mysql_query($sql);
23. echo '';
24. echo '
';
26. //显示标题
27. $cols = mysql_num_fields($result);
28. echo '
';
29. for ($i=0; $i echo '
';
30. }
31. echo '
';
32. //显示记录
33. while ($row = mysql_fetch_assoc($result)) {
34. echo '
';
35. echo '
';
36. echo '
';
37. echo '
';
38. }
39. //显示Page导航
40. echo '

'.$name.'

'.mysql_field_name($result,$i).'
'.$row['id'].'	'.$row['title'].'
记录共有:'.mysql_num_rows($result) . '	'; echo ($page == 1) ? '首页' : '首页'; echo ' '; echo ($page == 1) ? '上一页' : '上一页'; echo ' '; echo ($page == $pageNums) ? '下一页' : '下一页'; echo ' '; echo ($page == $pageNums) ? '尾页' : '尾页'; echo '

';
41. }
43. if (isset($_GET['page']) && $_GET['page'] > 0) {
44. $page = $_GET['page'];
45. } else {
46. $page = 1;
47. }
49. showTable('category',$page);

复制代码