php while循环在15行后不显示行

Question

您好，我有两个文件，一个文件包含主要帖子，第二个文件包含加载更多帖子代码

以下是主文件的代码，但在这个文件中我有一个问题，我必须在 php 中循环我的所有 mysql 行，我可以使用 while 循环来做到这一点，但是当我尝试这个时，我得到了所有行，但在 15 行之后它显示只有那些在 15 行之后的，比如只有 16 行

我的 main.php 代码

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

    $nv_name_split = str_replace('_', ' ', $row['novel_name']);

    echo '<br><a href="episode?novel='.$row['novel_name'].'&episode='.$row['episode_num'].'"><figure class="snip1253"><div class="image"><img width="100%"src="images/sneakpeaks/'.$row['sneak_peak'].'" alt="sample59"/></div><figcaption>'.

            '<div class="date"><span class="day">'.$row['day'].'</span><span class="month">'.$row['month'].'</span></div><h3>Episode # '.$row['episode_num'].'</h3>  <footer>

            <div class="writer text-center"><i class="fa fa-book"> '.$nv_name_split.'</i></div>

            <div class="love"><i class="fa fa-thumbs-up"></i>'.$row['likes'].'</div>

            <div class="comments"><i class="fa fa-comments"></i>'.$row['comments'].'</div></footer></figure></a></figcaption><br><br>';

}

?>

<?php 

$stmt_count = $novel_list->runQuery("SELECT episode_num 

                                    FROM posts 

                                    WHERE just_skpk='0'");

$stmt_count->execute();

while ($rows = $stmt_count->fetch(PDO::FETCH_ASSOC)) {

    $count_row = $rows['episode_num'];

}

if ($limit < $count_row) {

    echo'<form id="frm_more_post">

            <center>

            <button type="submit" class="form-control btn btn-load_more" id="frm_btn_more">Load More Posts</button>

            </center>

        </form>

        <br>

        <br>';

}else{

    echo'<form id="frm_more_post">

            <center>

            <button type="submit" disabled class="disabled form-control btn btn-load_more" id="frm_btn_more">No More Posts</button>

            </center>

            </form>

            <br>

            <br>'; 

}

我在 main.php while 循环中使用 double == 在 while 循环中解决了第一个问题，但在 load_more.php 文件中我无法显示更多帖子按钮，它显示已禁用，但是当我在数据库中的行数少于 15 行时，它工作得很好请帮我显示在 load_more.php 中加载更多帖子按钮。

谢谢，任何帮助将不胜感激。

Answer 1

在您的代码中，您将 episode_num 作为 $count_row，但它不应该是行数。试试下面的代码$novel_list = new USER();if (isset($_POST['page'])) {&nbsp; &nbsp;&nbsp; &nbsp; $limit = $_POST['page']+3;&nbsp; &nbsp; $stmt = $novel_list->runQuery("SELECT *&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM posts&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHERE just_skpk='0'&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ORDER BY id DESC&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LIMIT $limit");&nbsp; &nbsp; $stmt->execute();&nbsp; &nbsp; if ($stmt->rowCount(0)) {&nbsp; &nbsp; &nbsp; &nbsp; echo '<input class="hidden" id="pages" value="'.$limit.'"/>';&nbsp; &nbsp; &nbsp; &nbsp; while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $nv_name_split = str_replace('_', ' ', $row['novel_name']);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '<br><a data-pages="'.$limit.'" href="episode?novel='.$row['novel_name'].'&episode='.$row['episode_num'].'"><figure class="snip1253"><div class="image"><img width="100%"src="images/sneakpeaks/'.$row['sneak_peak'].'" alt="sample59"/></div><figcaption>'.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '<div class="date"><span class="day">'.$row['day'].'</span><span class="month">'.$row['month'].'</span></div><h3>Episode # '.$row['episode_num'].'</h3>&nbsp; <footer>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="writer text-center"><i class="fa fa-book"> '.$nv_name_split.'</i></div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="love"><i class="fa fa-thumbs-up"></i>'.$row['likes'].'</div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="comments"><i class="fa fa-comments"></i>'.$row['comments'].'</div></footer></figure></a></figcaption><br><br>';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; $stmt_count = $novel_list->runQuery("SELECT count(*) as cnt&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM posts&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHERE just_skpk='0'");&nbsp; &nbsp; &nbsp; &nbsp; $stmt_count->execute();&nbsp; &nbsp; &nbsp; &nbsp; while ($rows = $stmt_count->fetch(PDO::FETCH_ASSOC)) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $count_row = $rows['cnt'];&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; if ($limit < $count_row) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '<form id="frm_more_post">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <center>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <button type="submit" class="form-control btn btn-load_more" id="frm_btn_more">Load More Posts</button>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</center>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </form>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br>';&nbsp; &nbsp; &nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '<form id="frm_more_post">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <center>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <button type="submit" disabled class="disabled form-control btn btn-load_more" id="frm_btn_more">No More Posts</button>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </center>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</form>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br>';&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; echo 0 ;&nbsp; &nbsp; }}

Answer 2

我认为这是因为分页。在文件 load_more.php 中，您设置了一个限制$limit&nbsp;=&nbsp;$_POST['page']+3;在文件中，main.phpif&nbsp;($limit&nbsp;<&nbsp;$count_row)这是支票。