php分页时遇到的问题,php-分页页面ID有问题

如果我在第1页的分页中有10个数据,则另一页具有即page = 2的其他页中有10个数据.而在该页= 3之后不包含任何数据.如果我选​​择上一个按钮,则该页进入第1页,page = -2 …..,如果我按下next按钮,它也会像page = 2,page = 3等等.因此,如果记录不再可用,如何禁用prev和next按钮？

include("config.php");

$start = 0;

$per_page = 5;

if(!isset($_GET['page'])){

$page = 1;

} else{

$page = $_GET['page'];

}

if($page<=1)

$start = 0;

else

$start = $page * $per_page - $per_page;

$sql="select id,question,correctAnswer,category from math order by id";

$num_rows = mysql_num_rows(mysql_query($sql));

$num_pages = $num_rows / $per_page;

$sql .= " LIMIT $start, $per_page";

$result=mysql_query($sql) or die(mysql_error());

while($row=mysql_fetch_array($result))

{ ?>

.......

........

$prev = $page - 1;

$next = $page + 1;

echo "prev ";

echo " next ";

?>

解决方法:

这个怎么样：

include("config.php");

$start = 0;

$per_page = 5;

if(!isset($_GET['page'])){

$page = 1;

} else{

$page = $_GET['page'];

}

if($page<=1)

$start = 0;

else

$start = $page * $per_page - $per_page;

$sql="select id,question,correctAnswer,category from math order by id";

$num_rows = mysql_num_rows(mysql_query($sql));

$num_pages = $num_rows / $per_page;

$sql .= " LIMIT $start, $per_page";

$result=mysql_query($sql) or die(mysql_error());

while($row=mysql_fetch_array($result))

{ ?>

.......

........

if($page > 1){

$prev = $page - 1;

$prev = " prev ";

} else {

$prev = "";

}

if($page < $num_pages){

$next = $page + 1;

$next = " next ";

}

echo $prev;

echo $next;

?>

标签：pagination,javascript,php

来源： https://codeday.me/bug/20191122/2062945.html