PHP Loop JSON ajax成功

Question

i have a problem about looping throught json output on ajax success. this is my code :

<?php
    $product = mysqli_query($con,select * from product LIMIT 3);
    while ($dataproduct = mysqli_fetch_assoc($product) {

    echo json_encode(array(

            "product" => $dataproduct['product']
    ));

    } 
?>

$.ajax({
    type        : "GET", 
    url         : test.php, 
    dataType    : "json",
    success     : function(data) {
               $.each(data, function() {
                   $.each(this, function(k, v) {
                        $("ul").html(data.product);

                  });
                });
            }
});

<ul>
    <li></li>
</ul>

how to make that "ajax success looping . so i can make an output to "ul" element?

what's wrong with my code?

Answer 1

Try following, it should work for you:-

<?php
    $product = mysqli_query($con,select * from product LIMIT 3);
    $temp = array();
    while ($dataproduct = mysqli_fetch_assoc($product) {

    $temp[] = $dataproduct['product'];
}
echo json_encode($temp);

?>

$.ajax({
    type        : "GET", 
    url         : test.php, 
    dataType    : "json",
    success     : function(data) {
               $.each(data, function(k,v) {
                        $("ul").html(v);

                  });
                });
            }
});

<ul>
    <li></li>
</ul>