来自 MySQL 的 PHP 分页

Question

我的分页 PHP 脚本有问题。第一页工作正常，但接下来的页面是空白的。Config.php 包括数据库设置，如主机等。请帮我解决我的问题。提前致谢。

这是我的代码:

include 'config.php';
mysql_connect($iplogow, $userlogow, $haslologow) or die("Mysql error: " . mysql_error());
mysql_select_db($bazalogow)or die("Błąd bazy danych: " . mysql_error());


        echo '<br>
            <table class="table table-bordered table-striped" width="500px">
               <thead>
                <tr>
                    <th>table1</th>
                    <th>table2</th>
                <th>table3</th>
                <th>table4</th>
                <th>table5</th>
                <th>table6</th>
                <th>table7</th>
                     </tr></thead>';


        $result = mysql_query("SELECT Count(id) FROM `logi`");
        $row = mysql_fetch_row($result);
        $count_users = $row[0];

        $per_page = 10;


        $pages = ceil($count_users / $per_page);


        $current_page = !isset($_GET['page']) ? 1 : (int)clear($_GET['page']);


        if($current_page < 1 || $current_page > $pages) {
            $current_page = 1;
        }


        if($count_users > 0) {
            $result = mysql_query("SELECT * FROM `logi` ORDER BY `id` DESC LIMIT ".($per_page*($current_page-1)).", ".$per_page);
            while($row = mysql_fetch_assoc($result)) {
                echo '<tr>
                    <td>'.$row['nick'].'</td>
                                <td>'.$row['ip'].'</td>
                    <td>'.$row['password'].'</td>
                    <td>'.$row['productid'].'</td>
                    <td>'.$row['client'].'</td>
                    <td>'.$row['date'].'</td>
                    <td>'.$row['hour'].'</td>
                </tr>';
            }
        } else {
            echo '<tr>
                <td colspan="3" style="text-align:center">Niestety nie znaleziono żadnych ataków.</td>
            </tr>';
        }
        echo '</table>';


        if($pages > 0) { 
            echo '<p>';
            if($pages < 11) {
                for($i = 1; $i <= $pages; $i++) {
                    if($i == $current_page) {
                        echo '<b>['.$current_page.']</b> ';
                    } else {
                        echo '<a href="ataki.php?page='.$i.'">['.$i.']</a> ';
                    }
                }
            } elseif($current_page > 10) {
                echo '<a href="ataki.php?page=1">[1]</a> ';
                echo '<a href="ataki.php?page=2">[2]</a> ';
                echo '[...] ';
                for($i = ($current_page-3); $i <= $current_page; $i++) {
                    if($i == $current_page) {
                        echo '<b>['.$current_page.']</b> ';
                    } else {
                        echo '<a href="ataki.php?page='.$i.'">['.$i.']</a> ';
                    }
                }
                for($i = ($current_page+1); $i <= ($current_page+3); $i++) {
                    if($i > ($pages)) break;
                    if($i == $current_page) {
                        echo '<b>['.$current_page.']</b> ';
                    } else {
                        echo '<a href="ataki.php?page='.$i.'">['.$i.']</a> ';
                    }
                }
                if($current_page < ($pages-4)) {
                    echo '[...] ';
                    echo '<a href="ataki.php?page='.($pages-1).'">['.($pages-1).']</a> ';
                    echo '<a href="ataki.php?page='.$pages.'">['.$pages.']</a> ';
                } elseif($current_page == ($pages-4)) {
                    echo '[...] ';
                    echo '<a href="ataki.php?page='.$pages.'">['.$pages.']</a> ';
                }
            } else {
                for($i = 1; $i <= 11; $i++) {
                    if($i == $current_page) {
                        if($i > ($pages)) break;
                        echo '<b>['.$current_page.']</b> ';
                    } else {
                        echo '<a href="ataki.php?page='.$i.'">['.$i.']</a> ';
                    }
                }
                if($pages > 12) {
                    echo '[...] ';
                    echo '<a href="ataki.php?page='.($pages-1).'">['.($pages-1).']</a> ';
                    echo '<a href="ataki.php?page='.$pages.'">['.$pages.']</a> ';
                } elseif($pages == 12) {
                    echo '[...] ';
                    echo '<a href="ataki.php?page=12">[12]</a> ';
                }
            }
            echo '</p>';
        }
        ?>

Answer 1

您是否包含了 clear() 函数？

看行:$current_page = !isset($_GET['page']) ? 1:(int)clear($_GET['page']);

如果您没有包含该函数，那么您将在执行脚本时遇到 fatal error 。尝试将clear()全部删除，看看会发生什么，更改后的行应该是

$current_page = !isset($_GET['page']) ? 1 : $_GET['page'];