php分页和具体使用

来源：互联网发布：ubuntu openstack 编辑：程序博客网时间：2024/05/16 21:18

<?php
$conn = @ mysql_connect("localhost", "root", "password") or die("数据库链接错误");
mysql_select_db("test",$conn);
mysql_query("set names 'GBK'"); //使用GBK中文编码;
//$content=str_replace("'","‘",$content);
//htmlspecialchars();
?>

<?php
$pagesize=20;
$url=$_SERVER["REQUEST_URI"];
$url=parse_url($url);
$url=$url[path];s$numq=mysql_query("SELECT * FROM `phptest`");
$num = mysql_num_rows($numq);
if($_GET[page]){
$pageval=$_GET[page];
$page=($pageval-1)*$pagesize;
$page.=',';
}else{
$pageval=1;
$page=($pageval-1)*$pagesize;
$page.=',';
}
if($num > $pagesize)
{
$SQL="SELECT * FROM `phptest`order by id desc limit $page $pagesize ";
$query=mysql_query($SQL);

while($row=mysql_fetch_array($query)){
?>

<tr>
  <td  style="text-indent:30px;" valign="middle"><?php echo $row[0];?></td>
  <td align="center" valign="middle"><?php echo $row[2];?></td>
</tr>
<?php
    }

$e = $pageval*$pagesize;
$w = ($pageval+1)*$pagesize;
if($pageval==1&&$num<=$e){
echo "  共".$num."条  "."这是第".$pageval."页  "."上一页  下一页";
}
if($pageval==1&&$num>=$e){
echo "  共".$num."条  "."这是第".$pageval."页  "."上一页  <a href=$url?page=".($pageval+1)."&u_id=51>下一页</a>";
}
if($num>=$e&&$pageval!=1){
echo "  共".$num."条 &nbsp"."这是第".$pageval."页 &nbsp"."<a href=$url?page=".($pageval-1)."&u_id=51>上一页</a>  <a href=$url?page=".($pageval+1)."&u_id=51>下一页</a>";
}
if($pageval!=1&&$num<=$e){
echo "  共".$num."条 &nbsp"."这是第".$pageval."页 &nbsp"."<a href=$url?page=".($pageval-1)."&u_id=51>上一页</a>  下一页";
}}

else{
$SQL="SELECT * FROM `phptest` limit $page $pagesize ";
$query=mysql_query($SQL);

while($row=mysql_fetch_array($query)){
?>

<tr>
  <td  style="text-indent:30px;" valign="middle"><?php echo $row[0];?></td>
  <td align="center" valign="middle"><?php echo $row[2];?></td>
</tr>
<?php
    }
$e = $pageval*$pagesize;
$w = ($pageval+1)*$pagesize;

if($pageval==1&&$num<=$e){
echo "  共".$num."条  "."这是第".$pageval."页  "."上一页  下一页";
}
if($pageval==1&&$num>=$e){
echo "  共".$num."条  "."这是第".$pageval."页  "."上一页  <a href=$url?page=".($pageval+1)."&u_id=51>下一页</a>";
}
if($num>=$e&&$pageval!=1){
echo "  共".$num."条 &nbsp"."这是第".$pageval."页 &nbsp"."<a href=$url?page=".($pageval-1)."&u_id=51>上一页</a>  <a href=$url?page=".($pageval+1)."&u_id=51>下一页</a>";
}
if($pageval!=1&&$num<=$e){
echo "  共".$num."条 &nbsp"."这是第".$pageval."页 &nbsp"."<a href=$url?page=".($pageval-1)."&u_id=51>上一页</a>  下一页";
}}
?>