How to display array of json data properly in html?

Question

My Ajax

$("form").on("submit", function () {
    var data = {
        "action": "test"
    };

    data = $(this).serialize() + "&" + $.param(data);
    $.ajax({
        type: "POST",
        dataType: "json",
        url: "ajax2.php", //Relative or absolute path to response.php file
        data: data,
        success: function (data) {

            $("#main_content").slideUp("normal",function(){

            $(".the-return").html("<br />JSON: " + data);
//how to alter this part to display data for each record in one div?

            });
        }
    });
    return false;

});

My query

$statement = $pdo->prepare("SELECT * FROM posts WHERE subid IN (:key2) AND Poscode=:postcode2");
    $statement->execute(array(':key2' => $key2,':postcode2'=>$postcode));
 // $row = $statement->fetchAll(PDO::FETCH_ASSOC);
  $json = array();
 while( $row = $statement->fetch()) {
     array_push($json, array($row['Name'], $row['PostUUID']));
 }

    header('Content-Type: application/json');
    echo json_encode($json);

The result displayed currently in this form:

JSON: jack,55421894ab602,test,55439324cc43d

But I want to display like:

 Name:jack,
 Id:55421894ab602
.....and some other info-

 Name:test
 Id:55439324cc43d
.....and some other info-

This part:

$(".the-return").html("<br />JSON: " + data);

I tried: data[0]; But when I do this, only the first record displayed obviously.

What I'm trying is :

data[0] itself is an array. How to display that array together with other records fetched in nice html?

edited: WIth these edited code, i can only retrieve the last result, it's not looping through the array.

ajax success: function (data) {

            $("#main_content").slideUp("normal",function(){

            //$(".the-return").html("<br />JSON: " + j_data);
            for (i = 0; i < data.length; i++) {
            $(".the-return").html("<div>Name:" + data[i].name + "<br/>Id:" + data[i].id);
        }
            console.log(data); // this shows nothing in console,I wonder why?
            //alert(j_data);
            });
        }

php

$json = array();
 while( $row = $statement->fetch()) {
     //array_push($json, array($row['Name'], $row['PostUUID']));
     array_push($json, array("name" => $row['Name'], "id" => $row['PostUUID']));
 }

    header('Content-Type: application/json');
    echo json_encode($json);

Assign them in an variable like $variable = json_decode($json). $variable will be array type and then you can use it easily. — Death-is-the-real-truth
– Death-is-the-real-truth, Commented May 6, 2015 at 16:10

pabgaran · Accepted Answer · 2015-05-06 16:35:12Z

2

First, to get the names of the fields in your template, you need store them in your array:

array_push($json, array("name" => $row['Name'], "id" => $row['PostUUID']));

Result after json_encode -> {"name":"TheName","id":"TheID"}

Next, in your js code, if the json that it receives is valid, you can do a loop:

success: function (data) {
    $("#main_content").slideUp("normal",function(){
        for (i = 0; i < data.length; i++) {
            $(".the-return").html("<div>Name:" + data[i].name + "<br/>Id:" + data[i].id);
        }
    }
}

Of course, you can add style or class to the div.

I hope it helps.

answered May 6, 2015 at 16:35

pabgaran

7734 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

sherly Over a year ago

thanks but the result in html says like this:JSON: [object Object],[object Object]

pabgaran Over a year ago

Are you doing the loop? If you try to print it directly, the result is that, a json object. You have to access to the values.

sherly Over a year ago

I just copy pasted your codes for array push and javascript??

sherly Over a year ago

I got something now.. i simpley copy pasted your code and i can get result by name specified in array like name, id..but only one result..it's not looping though

sherly Over a year ago

[Object, Object] [Object, Object]

|

Collectives™ on Stack Overflow

How to display array of json data properly in html?

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related