douzhechi2435 2018-05-20 16:08
浏览 46

php jquery mysql - 在循环中加载更多按钮

I have two files for a load more button for posts but I can't use another load more for posts replay this is one load more code: file index.php:

<script>
$(document).ready(function() {
  var comco = 2;
  var offset = 0;
  $("#btn1").click(function() {
    $.ajax({
        method: "POST",
       url: "ld_comco.php",
        data: { comnco: comco, offset: offset }
      })
      .done(function(msg) {
        $("#comnts").append(msg);
      });
    offset = offset + comco;
  });

  $("#btn1").trigger("click");
});
</script>
<div  id="comnts"></div>
<button id="btn1">load more</button>

and this is the ld_comco.php file:

$comnco=$_POST['comnco'];
$offset=$_POST['offset'];

$qq="SELECT * FROM tbl_users_posts limit $offset, $comnco";
$qr=mysqli_query($conn,$qq);while($fff=mysqli_fetch_assoc($qr)){
    echo $fff['post'];}

I do change the ld_comco.php file for add repost button inside the posts:

$comnco=$_POST['comnco'];
$offset=$_POST['offset'];

$qq="SELECT * FROM tbl_users_posts limit $offset, $comnco";
$qr=mysqli_query($conn,$qq);while($fff=mysqli_fetch_assoc($qr)){
   $sbid=$fff['id'];
    echo $fff['post'];
?>

<script>
$(document).ready(function() {
  var recomco = 2;
  var sbid = <?php echo $sbid?>;
  var reoffset = 0;
  $("#btn2").click(function() {
    $.ajax({
        method: "POST",
       url: "ld_recomco.php",
        data: { recomnco: recomco, reoffset: reoffset }
      })
      .done(function(msg) {
        $("#recomnts").append(msg);
      });
    reoffset = reoffset + recomco;
  });

  $("#btn2").trigger("click");
});
</script>
<?php }?>
<div  id="recomnts"></div>
<button id="btn2">load more re-pst</button>

and add a ld_recomco.php file:

$recomnco=$_POST['recomnco'];
$reoffset=$_POST['reoffset'];
$sbid=$_POST['sbid'];

$qq2="SELECT * FROM re_pst WHERE subid=$sbid limit $reoffset, $recomnco";
$qr2=mysqli_query($conn,$qq2);while($fff2=mysqli_fetch_assoc($qr2)){
    echo $fff2['id'];
    echo $fff2['remsg'];
}

This dosen't work properly, how can I do this?


Edit: i have the user posts in a while-loop like this:

$qq="SELECT * FROM tbl_users_posts";
$qr=mysqli_query($conn,$qq);while($fff=mysqli_fetch_assoc($qr)){
   $sbid=$fff['id'];
    echo $fff['post'];}

i can add -load more- button to post but i cant add -load more- button to posts replay in some code like this:

$qq="SELECT * FROM tbl_users_posts limit 10";
$qr=mysqli_query($conn,$qq);while($fff=mysqli_fetch_assoc($qr)){
   $sbid=$fff['id'];
    echo $fff['post'];?>
<?php   $qq2="SELECT * FROM re_pst WHERE subid=$sbid";
    $qr2=mysqli_query($conn,$qq2);while($fff2=mysqli_fetch_assoc($qr2)){
        echo $fff2['remsg'];
    }} 
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值
    • ¥15 我想咨询一下路面纹理三维点云数据处理的一些问题,上传的坐标文件里是怎么对无序点进行编号的,以及xy坐标在处理的时候是进行整体模型分片处理的吗
    • ¥15 CSAPPattacklab
    • ¥15 一直显示正在等待HID—ISP
    • ¥15 Python turtle 画图
    • ¥15 关于大棚监测的pcb板设计
    • ¥15 stm32开发clion时遇到的编译问题
    • ¥15 lna设计 源简并电感型共源放大器
    • ¥15 如何用Labview在myRIO上做LCD显示?(语言-开发语言)
    • ¥15 Vue3地图和异步函数使用