php 分頁程式碼

來源:互聯網
上載者:User

<?php
    $tempquery = mysql_query("select dpb,facejtype from zgy_member_p_d_basic where  dpb = '$city' and      facejtype like '%$keyword%' ");
  $count = mysql_num_rows( $tempquery );
  if( $count )
  {
   $page=isset($_GET['page'])?$_GET['page']:1;
   $pagesize=20;  
   $pagecount=($count % $pagesize)?(int)($count / $pagesize) +1:$count / $pagesize;  
   $page=($page>$pagecount || $page<1)?$page=1:$page;  
   $start=$pagesize*($page-1);
     $sql = "Select
     dpb,     
     truename,
     uid,
     sex,
     birth,
     education,
     experience,
     facejkind,
     facejtype,
     id
    from 
     zgy_member_p_d_basic
    where
     dpb = '$city' and
     facejtype like '%$keyword%' group by uid order by id desc limit $start,$pagesize";
     
   $query = mysql_query( $sql ) or die( mysql_error() );  
      
   while( $rs = mysql_fetch_array( $query ) )
   {
   ?>
    <tr>
   <td><a href="/index.php/display/resume/<?=$rs['id']?>.html" class="col-blu" target="_blank"><?=$rs['truename']?></a></td>
   <td>
   <?
    $date = date("Y-m-d");
    $date1 = $rs['birth'];    
    echo sdate($date,$date1);
    
   ?>   </td>
   <td><?= $rs['sex'] ? '男' : '女' ;?></td>
   <td><?= $rs['education']?> </td>
   <td><?= $rs['experience']?></td>
   <td><?= $rs['facejkind']?></td>
    </tr>
   <?php
     }
    
  ?>
  <tr>
        <td colspan="6">
  <div class="listPage"><form action="jobs.php?keyword=<?=$keyword?>&city=<?= $city?>" method="get" enctype="application/x-www-form-urlencoded" >總數:<span class="f-red"><?=$count?>/條</span> 每頁<?=$pagesize?>條 當前第<span class="f-red"><?=$page?>/<?=$pagecount?></span>頁 <a href="jobs.php?keyword=<?=$keyword?>&city=<?= $city?>&page=<?=1?>" class="col-blu"> 首頁 </a><a href="jobs.php?keyword=<?=$keyword?>&city=<?= $city?>&page=<?=$page-1;?>" class="col-blu">上一頁 </a><span class="col-blu"> <a href="jobs.php?keyword=<?=$keyword?>&city=<?= $city?>&page=<?=$page+1;?>" class="col-blu">下一頁 </a></span><a href="#" class="col-blu"><a href="jobs.php?keyword=<?=$keyword?>&city=<?= $city?>&page=<?=$count;?>" class="col-blu">尾頁 </a>轉到 第
   
 <input name="page" type="text" id="page" size="3" />
 <input name="city" type="hidden" value="<?=$city;?>" />
 <input name="keyword" type="hidden" value="<?=$keyword;?>" />
  頁
   <input type="submit" name="Submit" value="確定" />
 </form>
   </div>
 </div>
 </td>
  </tr>
  <?
  }
  else
  {
   ?>
      <tr>
        <td colspan="6">對不起,您要尋找內容暫時不存在!</td>
      </tr>
   <?php
    }
   ?>
    </table>
  </div>

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: 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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

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

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.