Jquery - 从数据库中获取注释

oI am having problem fetching comments from MySQL database using jQuery.

I am trying this way, but its not working.

PHP (comments.php)

<?php 

    if (isset($_POST['value1'])) {
        $id = ($_POST['value1']);
    }else{
        $id = '';
    } 
    if (isset($_POST['value2'])) {
        $database = ($_POST['value2']);
    }else{
        $database = '';
    } 
    if (isset($_POST['value3'])) {
        $tablename = ($_POST['value3']);
    }else{
        $tablename='';
    } 

    require_once('rt-connect.php');

    $find_data = "SELECT * FROM $tablename";
    $query = mysqli_query($connection, $find_data);
?> 



  <?php while($row = mysqli_fetch_assoc($query)):?>
  <div class="comment-container">
    <div class="user-info"><?php echo $row['user_name']; ?></div>
    <div class="comment"><p><?php echo $row['comment']; ?></p></div>
  </div>
  <?php endwhile;?>

Jquery(comments.html)

     var id=2;
 var database='comments_db';
 var tablename='comments';

 $.post('comments.php', {value1:id, value2:database, value3:tablename}, function(data)
    {
    $('#comments').load('comments.php .comment-container');
 });

Html(div on comments to load on comments.html)

      <div id="comments"></div><!--end of comments-->

Please see and suggest any possible way to do it.

Thanks

You have $.load() inside success function of $.post(), try this..

$.post('comments.php', {value1:id, value2:database, value3:tablename}, function(data)
   {
   $('#comments').html(data);
});

In your javascript, you are posting data to a url, accepting response and if the response is successful, you are sending another request to the PHP script, this time without parameters. Your comments box is displaying the result of your second request.

You do not require :

 $('#comments').load('comments.php .comment-container');

in your javascript, since you have already received a response. Instead, use :

  $('#comments').html(data);

which will display the response data in the comments div.

Try This one it will help you. This is jquery Ajax post method requesst if you want to show your data is loaded or not just remove the commet.

$.ajax({
type: "POST",
url: url,
data: { value1:id, value2:database, value3:tablename}
}).done(function( data ) {
//alert(data); return false;

$("#comments").html(html);
});

You could try this one,

 var id = 2;
 var database  = 'comments_db';
 var tablename = 'comments';

$.ajax({
    type   :"POST",
    data   :"id="+id+"&database="+database+"&tablename="+tablename,
    url    : comments.php, 
    success: function(msg){
        $("#comments").html(msg);
     }
});