CODEWITHSUNDEEP
phpjqueryhtmlajax
user1411607
user1411607

Reputation:

How to bring json and html data in one ajax call

I have a two jquery function to bring ratings and comments separately from two files which is working fine.

Now i want to do it in a single ajax call, i am trying to merge two function together this way but its not working.

jquery

    function get_review(){
    $.ajax({ 
      type: "POST",
      url: '../review.php',                        
      data: {value1:value1, value2:value2, value3:value3},                        
      dataType: 'json',
      cache: false,              
      success: function(data)          
       {
        var x = data[0];
        var rating = (x-0.5)*2
        var y = (20 * rating)+40;
        $('#urating').css("backgroundPosition","0%"  +(y)+ "px");
        $('#comments').html(data);
       } 
     });
};

PHP

$find_data = "SELECT * FROM $tablename WHERE table_name='$table' AND product_id='$id' ORDER by id DESC";
$query = mysqli_query($connection, $find_data);

$find_data2 = "SELECT * FROM $tablename2 WHERE id='$id'";
$query2 = mysqli_query($connection, $find_data2);
$row2 = mysqli_fetch_assoc($query2);

header('Content-type: application/json');
echo json_encode($row2);
?> 

      <?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['quick_comment']; ?></p></div>
      </div>
      <?php endwhile;?>

Please see and suggest any possible way to do it.

Thanks.

Upvotes: 1

Views: 264

Answers (1)

Bogdan Burym
Bogdan Burym

Reputation: 5512

Try to encode whole response to JSON object! Something like:

$response = array(
    'success' => true,
    'object'  => $yourobject_or_array,
    'html'    => '<b>Bla bla</b>'
);
echo json_encode($response);
die();

JS:

function(response) {
    var res = false;
    try {
        res = jQuery.parseJSON(response);
    } catch(e) {}
    if (res && res.success) {
        // Use res.object and res.html here
    }
}

Upvotes: 1

Related Questions