欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  php教程

ajax实现无刷新分页(php)

程序员文章站 2022-05-16 21:02:58
...
复制代码 代码如下:





投票结果





用户留言如下:








复制代码 代码如下:


$link = mysql_connect('localhost', 'root', '') or die(mysql_error());
mysql_select_db('vote', $link) or die(mysql_error());
mysql_query("set names utf8");
$num = 3;
$url = "page.php";
$con = "

    ";
    $page = (isset($_REQUEST['page'])) ? $_REQUEST['page'] : 1;
    $offset = ($page - 1) * $num;
    $result = mysql_query("SELECT COUNT(*) FROM client");
    $total = mysql_fetch_row($result);
    $total = $total[0];
    $pagenum = ceil($total / $num);
    $page = min($pagenum, $page); //获得首页
    $prepg = $page - 1; //上一页
    if ($prepg $prepg = 1;
    $nextpg = ($page == $pagenum ? 1 : $page + 1); //下一页
    //如果只有一页则跳出函数:
    if ($pagenum return false;
    $sql = "SELECT `name`,`content` FROM `client` LIMIT " . $offset . "," . $num;
    $res = mysql_query($sql);
    while ($content = mysql_fetch_row($res)) {
    $con .= "
  • $content[0]: $content[1]
  • ";
    }
    $con .= "
";
$con .=

首页|上一页||尾页


PAGE;
echo $con;
?>