php mysql页码,MySQL / PHP-页码分页有时仅显示10页

I am having difficulties with my MYSQL / PHP dashboard. - Currently i am having 50 pages, but currently they are all showing on the same page.

http://imgur.com/wDfTWUa - as you can see in the attached file. - I only want 10 pages to be shown, and be able to click through the rest of the pages without seeing 4 rows of pages.

Exsampel when you are on ?page=1, if you are on page ?page=10

Hope you can help me.

Code:

include 'config.php';

$sidenr = $_GET['page'];

$sidenr2 = ($sidenr -1) * 10;

echo $sidenr2;

echo "
";

$query100 = mysqli_query($conn, "SELECT * FROM `test` LIMIT $sidenr2,10") or die(mysqli_error($conn));

while($row = mysqli_fetch_array($query100))

{

echo $row['id']."
";

}

$result = mysqli_query($conn, "SELECT * FROM test");

$num_rows = mysqli_num_rows($result);

$sideantal = $num_rows / 10;

echo "Der skal være antal sider: ". $sideantal;

echo "
antal rækker ". $num_rows . "
";

?>

for ($number = 1; $number <= $sideantal; $number++) {

echo "

". $number. "";

}

?>

解决方案

function getPageRange($current, $max, $total_pages = 10) {

$desired_pages = $max < $total_pages ? $max : $total_pages;

$middle = ceil($desired_pages/2);

if ($current <= $middle){

return [1, $desired_pages];

}

if ($current > $middle && $current <= ($max - $middle)) {

return [

$current - $middle,

$current + $middle

];

}

if ($current <= $max ) {

return [

$current - ($desired_pages - 1),

$max

];

}

}

list($min,$max) = getPageRange($sidenr, $sideantal);

foreach (range($min, $max) as $number) {

echo "

". $number. "";

}