Home > Article > Backend Development > 各位帮忙看看PHP分页问题！急在线等
各位帮忙看看PHP分页问题！急在线等
- WBOYOriginal
- 2016-06-20 12:44:05941browse
GET方式取值已经取到了，但是分页就是不管用，弄半天了实在找不到哪里写错了，请各位费费心给瞧瞧在线等！！
截图
PHP部分代码：
<?php header("Content-Type:text/html;Charset=utf-8"); $host='localhost'; $user='root'; $password='63698000xw'; $database='testguest'; $conn=@mysqli_connect($host, $user, $password, $database) or die('DataBase connected error<br/>'.mysqli_connect_error($conn)); // mysqli_set_charset($conn, "utf8"); if (isset($_GET['page'])){ $_page=$_GET['page']; echo $_page; if(empty($_page)){ $_page=1; } }else { $_page=1; } $_pagesize=1; $_pagenum=(page-1)*pagesize; $sql="SELECT tg_id FROM tg_user"; $result1=mysqli_query($conn,$sql)or die(mysqli_error($conn)); $_num=mysqli_num_rows($result1); $_pageabsolute=ceil($_num/$_pagesize);// echo" $_pageabsolute <br/>"; $query="SELECT tg_id,tg_username,tg_reg_time FROM tg_user ORDER BY tg_reg_time DESC LIMIT $_pagenum,$_pagesize"; $result=mysqli_query($conn, $query); while ($row=mysqli_fetch_array($result)) { echo "<td>{$row['tg_id']}</td>---<td>{$row['tg_username']}</td>---<td>{$row['tg_reg_time']}</td><br/>"; } mysqli_free_result($result1); mysqli_free_result($result); mysqli_close($conn); ?> HTML部分代码：
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>无标题文档</title> <style type="text/css"> #page_num{ height:40px; clear:both; padding:10px 0; position:relative; } #page_num ul{ position:absolute; right:30px; height:20px; } #page_num ul li{ float:left; height:20px; width:30px; } #page_num ul li a{ display:block; height:20px; width:20px; line-height:20px; border:1px solid #333; text-align:center; text-decoration:none; } #page_num ul li a:hover,#page_num ul li a.selected{ background:#666; font-weight:bold; color:#fff; } </style></head><body><div id="page_num"> <ul> <?php for($i=0;$i<$_pageabsolute;$i++){ if ($_page==($i+1)){ echo '<li><a href="index.php?page='.($i+1).'" class="selected">'.($i+1).'</a></li>'; }else { echo '<li><a href="index.php?page='.($i+1).'">'.($i+1).'</a></li>'; } } ?> </ul></div></body></html>
回复讨论(解决方案)
$_pagenum=( $page-1)* $pagesize;
粗心大意害死人！
错误信息明确的指出了错误的现象和位置，为什么视而不见呢？
$_pagenum=( $page-1)* $pagesize;
粗心大意害死人！
错误信息明确的指出了错误的现象和位置，为什么视而不见呢？
谢谢谢谢~！
这半天整的，我去找个豆腐去别拦着我~！
该死的zend studio居然也不给报个错
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：请教 mysql_unbuffered_query 遇到的问题Next article：开始玩PHP！