dongmei2956 2015-02-28 16:13
浏览 29
已采纳

Ajax自动刷新评论墙

Alright, so after several days of searching and reading I still can't get this to work so this is kinda my last chance. Keep in mind i'm a rookie with Ajax and JS.

I have a comment wall where you can leave a nice little message to others on the page and it works just fine but now I want to add some ajax so it auto refresh every 10 second and get the latest comments.

The thing is I get the whole website to be displayed inside that div and not the comments.

I have a js document with the following code

  (function update() {
    $.ajax({
        type : 'GET',
        url : 'index.php',
        success : function(data){
            $('#cmt_wall_container').html(data);
        },
    }).then(function() {
       setTimeout(update, 10000);
    });
})();

And my Index.php page include the following

<?php include_once 'connect.php'; ?>
<?php 
$cmt_list = "";
$sql = mysqli_query($con, "SELECT * FROM cmt ORDER BY id DESC LIMIT 10");
$cmtCount = mysqli_num_rows($sql);
if($cmtCount > 0){
    while($row = mysqli_fetch_array($sql)){
       $id = $row["id"];
       $comment = $row["comment"];
       $cmt_list .="<div class='post-container'><p class='post-comment'>$comment</p></div>";
}
} else {
    $cmt_list = "leave a comment";
}
?>

<head>stuff..</head>
<body>
    <div id="cmt_wall_container">
        <?php echo $cmt_list; ?>
    </div>
</body>

I hope this is clear enough! Thank you very much in advance, you are really my last hope!!!!!

  • 写回答

2条回答 默认 最新

  • dousha1873 2015-02-28 17:24
    关注

    Try something more along these lines...

    THE JS SCRIPT:

    function update() {
    $.post( "index.php", { grab: "comments"}).done(function( data ) {
        $('#cmt_wall_container').html(data);
        setTimeout(update, 10000);
    });
}

    THE PHP SCRIPT:

    <?php 
    include_once 'connect.php'; 

    $cmt_list = "";
    $sql = mysqli_query($con, "SELECT * FROM cmt ORDER BY id DESC LIMIT 10");
    $cmtCount = mysqli_num_rows($sql);
    if($cmtCount > 0){
        while($row = mysqli_fetch_array($sql)){
           $id = $row["id"];
           $comment = $row["comment"];
           $cmt_list .="<div class='post-container'><p class='post-comment'>$comment</p></div>";
    }
    } else {
        $cmt_list = "leave a comment";
    }
    // Return Results To Ajax And Exit
    if (isset($_POST['grab']) && $_POST['grab']==="comments") {
        echo $cmt_list;
        exit;
    } // Else Load Page As Normal
?>
<head>stuff..</head>
<body>
    <div id="cmt_wall_container">
        <?php echo $cmt_list; ?>
    </div>
</body>

    By using isset, you can detect if your requesting from ajax and only return the comments else you load the reset of the page as normal.. Its one method / approach.

    Note this still applies for $_GET.. just change $_POST to $_GET if you need, but by using the exit option.. You dont need to wrap your whole site in a else statement.. its cleaner

    So change your ajax url to index.php?grab=comments and add this below your PHP code.

        if (isset($_GET['grab']) && $_GET['grab']==="comments") {
        echo $cmt_list;
        exit;
    }

    By using this approach, you can also control your comments with options like grab=admin_comments or how ever you would want.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题？

悬赏问题

  • ¥100 set_link_state
  • ¥15 虚幻5 UE美术毛发渲染
  • ¥15 CVRP 图论 物流运输优化
  • ¥15 Tableau online 嵌入ppt失败
  • ¥100 支付宝网页转账系统不识别账号
  • ¥15 基于单片机的靶位控制系统
  • ¥15 真我手机蓝牙传输进度消息被关闭了，怎么打开？(关键词-消息通知)
  • ¥15 装 pytorch 的时候出了好多问题，遇到这种情况怎么处理？
  • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
  • ¥15 手机接入宽带网线，如何释放宽带全部速度