sql查询加载更多

Question

i have a load more button where it is loading comments for specific post from database (post_id). the problem is when i click load more it is loading all the comments from database table

pagecomment.php

$id = $_GET['id'];
$id_post = $id ;//the post or the page id
<div class="cmt-container" >
<?php
$sql = mysqli_query($con,"SELECT * FROM comments WHERE id_post ='$id_post'ORDER BY id DESC limit 2") or die(mysqli_error($con));
$rowCount = mysqli_num_rows($sql);
if($rowCount > 0){
while($affcom = mysqli_fetch_assoc($sql)){
    $name = $affcom['name'];
    $email = $affcom['email'];
    $comment = $affcom['comment'];
    $date = $affcom['date'];

loadmore.php

if(isset($_POST["id"]) && !empty($_POST["id"])){ 
 $queryAll =   mysqli_query($con,"SELECT COUNT(*) as num_rows FROM comments   WHERE id < ".$_POST['id']." ORDER BY id DESC");
$row = mysqli_fetch_assoc($queryAll);
$allRows = $row['num_rows'];

$showLimit = 2;

//get rows query
$query = mysqli_query($con, "SELECT * FROM comments WHERE id <     ".$_POST['id']." ORDER BY id DESC LIMIT ".$showLimit);

//number of rows
$rowCount = mysqli_num_rows($query);

if($rowCount > 0){
while($row = mysqli_fetch_assoc($query)){
    $tutorial_id = $row["id"]; ?>
    <div class="cmt-cnt">
        <div id="cmt-cmt"><img src="<?php echo $row['email']; ?>" alt="" />    </div>
        <div class="thecom">
            <h5><?php echo $row['name']; ?></h5><span data-utime="1371248446" class="com-dt"><?php $curenttime=$row['date'];
                $time_ago =strtotime($curenttime);
                echo timeAgo($time_ago); ?></span>
            <br/>
            <p>
                <?php echo $row['comment']; ?>
            </p>
        </div>
    </div><!-- end "cmt-cnt" -->

---

The problem is with the queries in loadmore.php

Answer 1

In the loadmore.php the SQL queries don't know from which id_post you want the comments :

$queryAll =   mysqli_query($con,"SELECT COUNT(*) as num_rows FROM comments   WHERE id < ".$_POST['id']." ORDER BY id DESC");

Modify it with :

$queryAll =   mysqli_query($con,"SELECT COUNT(*) as num_rows FROM comments   WHERE id < ".$_POST['id']." AND id_post = ".$id_post." ORDER BY id DESC");

And

$query = mysqli_query($con, "SELECT * FROM comments WHERE id < ".$_POST['id']." ORDER BY id DESC LIMIT ".$showLimit);

Modify it with :

$query = mysqli_query($con, "SELECT * FROM comments WHERE id < ".$_POST['id']." AND id_post = ".$id_post." ORDER BY id DESC LIMIT ".$showLimit);

By adding the AND part of the WHERE statement, you can add some more conditions.

Hope it helps.

EDIT :

Of course, you'll need to get the $id_post from Ajax or something.