Home > Backend Development > PHP Tutorial > 各位帮忙看看PHP分页问题!急在线等

各位帮忙看看PHP分页问题!急在线等

WBOY
Release: 2016-06-20 12:44:05
Original
948 people have browsed it

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);    ?>
Copy after login

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>
Copy after login


回复讨论(解决方案)

$_pagenum=( $page-1)* $pagesize;

粗心大意害死人!

错误信息明确的指出了错误的现象和位置,为什么视而不见呢?

$_pagenum=( $page-1)* $pagesize;

粗心大意害死人!

错误信息明确的指出了错误的现象和位置,为什么视而不见呢?


谢谢谢谢~!
这半天整的,我去找个豆腐去别拦着我~!


该死的zend studio居然也不给报个错

source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template