ajax实现无刷新分页(php) _爱资料
主页 > 编程资料 > PHP >
发布时间:2015-12-29 作者:网络 阅读:207次
复制代码 代码如下:



投票结果





用户留言如下:



<>
<>



复制代码 代码如下:
$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 <= 1)
    $prepg = 1;
    $nextpg = ($page == $pagenum ? 1 : $page + 1); //下一页
    //如果只有一页则跳出函数:
    if ($pagenum <= 1)
    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

首页|上一页||尾页


PAGE;
echo $con;
?>
关键字词: