php資料分頁加資料顯示效果

最後更新：2017-09-14 來源：互聯網

上載者：User

關鍵字網路程式設計 PHP教程

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

<?php
include_once(dirname(__FILE__).'.. /.. /Inc/Conn.php');
include_once(dirname(__FILE__).'.. /.. /photo/Inc/function.php');
?>
<! 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=gb2312" />
<title>無標題文檔</title>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
height:17px;
padding:8px 0px 0px 0px;
text-align:center;

}
body {
margin-left: 0px;
margin-top: 10px;
margin-right: 0px;
margin-bottom: 0px;
}
td{
border:1px solid #333;
}

-->
</style></head>

<body>
<div style="height:26px;text-align:left; width:98%;font-size:16px; font-weight:bold; margin :0px auto;" ><a href="export.php" target="_blank">匯出Execel表格</a></div>
<table width="98%" border="0 " align="center" cellpadding="0" cellspacing="0">
<tr>
    <td width="8%" ><strong>帳號</strong></td>
    <td width="14%"><strong>郵箱</ strong></td>
    <td width="5%"><strong>性別</strong></td>
    <td width="9%"><strong>寶寶出生日期</strong></td>
    < td width="12%"><strong>省份</strong></td>
    <td width="9%">< strong>真實姓名</strong></td>
    <td width="12%"><strong>郵編</strong ></td>
    <td width="10%"><strong>手機</strong></td>
    <td width="21%"><strong>位址</strong></td>
</tr>
<?php

$sql  ="Select * from tablename";



    $result =mysql_query($sql) or die('fail1'.mysql_error());

    $rs  =mysql_fetch_array($result);

    $rdcount =mysql_num_rows($result);

    if($rdcount){

    $pagesize =20;

    $pagecount=($rdcount % $pagesize)? (int) ($rdcount / $pagesize)+1:$rdcount/$pagesize;//統計總頁面

    $page  =isset($_GET['page'])?$_GET['page']:1;//取得當前頁面

    $start =($page>=1 && $page<=$pagecount)?$start=$pagesize*($page-1):$start=1;//取得超始記錄

    $start =$start;

    $sql  =$sql." order by add_date desc limit $start,$pagesize";

    $result =mysql_query($sql) or die(mysql_error());

  while($rs =mysql_fetch_array($result) ){

   echo"<tr>

    <td>".$rs['User_Name']." </td>

    <td>".$rs['User_Mail']." </td>

    <td>".$rs['User_Baby_Sex']." </td>

    <td>".$rs['User_Baby_Birth']." &nbsp;</td>

    <td>".$rs['sheng']." &nbsp;</td>

    <td>".$rs['User_rname']." &nbsp;</td>

    <td>".$rs['User_Zip']." &nbsp;</td>

    <td>".$rs['User_Hand']." &nbsp;</td>

    <td>".$rs['User_Address']." &nbsp;</td>

     </tr>

     ";



  }

echo "<tr> <td colspan=9>";

pagelist1($page,$pagecount,$rdcount,'?page=',$pagesize);

echo "</td> </tr> ";

}else{

   echo '暫時沒有資訊!';

}

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More