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); ?>
<!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居然也不给报个错