php 分页程序代码
<?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/<?php echo $rs['id'] ?>.html" class="col-blu" target="_blank"> <?php echo $rs['truename'] ?></a></td> <td> <?php $date = date("Y-m-d"); $date1 = $rs['birth']; echo sdate($date, $date1); ?> </td> <td><?php echo $rs['sex'] ? '男' : '女'; ?></td> <td><?php echo $rs['education'] ?> </td> <td><?php echo $rs['experience'] ?></td> <td><?php echo $rs['facejkind'] ?></td> </tr> <?php } ?> <tr> <td colspan="6"> <div class="listPage"><form action="jobs.php?keyword=<?php echo $keyword ?>&city=<?php echo $city ?>" method="get" enctype="application/x-www-form-urlencoded" >总数:<span class="f-red"><?php echo $count ?>/条</span> 每页<?php echo $pagesize ?>条 当前第<span class="f-red"><?php echo $page ?>/<?php echo $pagecount ?></span>页 <a href="jobs.php?keyword=<?php echo $keyword ?>&city=<?php echo $city ?>&page=<?php echo 1 ?>" class="col-blu"> 首页 </a><a href="jobs.php?keyword=<?php echo $keyword ?>&city=<?php echo $city ?>&page=<?php echo $page - 1; ?>" class="col-blu">上一页 </a><span class="col-blu"> <a href="jobs.php?keyword=<?php echo $keyword ?>&city=<?php echo $city ?>&page=<?php echo $page + 1; ?>" class="col-blu">下一页 </a></span><a href="#" class="col-blu"><a href="jobs.php?keyword=<?php echo $keyword ?>&city=<?php echo $city ?>&page=<?php echo $count; ?>" class="col-blu">尾页 </a>转到 第 <input name="page" type="text" id="page" size="3" /> <input name="city" type="hidden" value="<?php echo $city; ?>" /> <input name="keyword" type="hidden" value="<?php echo $keyword; ?>" /> 页 <input type="submit" name="Submit" value="确定" /> </form> </div> </div> </td> </tr> <?php } else { ?> <tr> <td colspan="6">对不起,您要查找内容暂时不存在!</td> </tr> <?php } ?> </table> </div>
教程地址:http://www.phprm.com/code/f3e0ffa8192d6c61aa10db60f0c40f29.html
欢迎转载!但请带上文章地址^^