php + mysql 的问题

Question

可以将内容转到static 数组变量

Answer 1

就是一个翻页功能吧?
没有必要用session吧
<?
$sh=mysql_query("select * from XXX");
$pagenum=mysql_num_rows($sh);
$ppp=16;//用于动态控制每页显示记录数
$quotient=$pagenum/$ppp;if(is_int($quotient)){
$pages=$quotient;}else{
$pages=intval($quotient)+1;}
if(empty($page)){$page=1;}
$start=$ppp * ($page-1);
$sh=mysql_query("select * from XXX order by id desc limit $start,$ppp");
while($showdata=mysql_fetch_array($sh)){
  ?>
                <tr> 
                  <td width="259>显示你的东西</td>
                </tr>
                <tr> 
                  <td colspan="1"> 
                    <div align="right">[ 
                      <?if($page>1):?>
                      <a href="XXX.php?page=<?echo $page-1;?>&id=<?php echo$id;?>">上一页</a> 
                      <?endif;?>
                      <font face="Verdana, Arial, Helvetica, sans-serif"> 
                      <?
          for($i=1;$i<$pages+1;$i++){
          
          if($i!=$page):
          echo "<a href=XXX.php?page=$i&id=$id>$i</a>&nbsp;";
          
          else:
          echo "$i&nbsp;";
          
          endif;
          }          
          ?>
                      </font> 
                      <?if($page<$pages):?>
                      <a href="XXX.php?page=<?echo $page+1;?>&id=<?php echo$id;?>">下一页</a> 
                      <?endif;?>
                      ] &nbsp;&nbsp;每页显示 
                      <?echo $ppp;?>
                      篇日记&nbsp;&nbsp;共<font face="Verdana, Arial, Helvetica, sans-serif"> 
                      <?echo $pagenum;?>
                      </font>条<font face="Verdana, Arial, Helvetica, sans-serif"> 
                      <?echo $pages;?>
                      </font>页 第<font face="Verdana, Arial, Helvetica, sans-serif"> 
                      <?echo $page;?>
                      </font>页</div>
                  </td>
                </tr>