How can I create a JSON object dynamically?

Question

I would like to create a JSON object dynamically. The JSON object will have to be as the follows:

{ 
                $capa:[$fila['test_name'],...etc],
                .
                .
                .etc    

};

The key and value will be retrieved through a MySQL query.
This is what i'm doing:

$array_container= array();

while($fila=mysqli_fetch_assoc($sql)){


                    $format_org=str_replace(" ","_",$fila["organization"]);
                    $format_eval=str_replace(" ","_",$fila["EvaluationType"]);
                    $format_test=str_replace(" ","_",$fila["test_name"]);
                                        $CapaEnviar=$format_org.$format_eval;

                              $array_container[] = array($CapaEnviar => $fila['test_name']);

}

echo json_encode($array_container,true);

Using the previous code, I can retrieve a JSON object with duplicate keys.

This code is an answer for an AJAX request, so once the JSON object has been created correctly, I will send back this JSON object in order to retrieve the key and value, so I will have to retrieve separately the key and value.

You already are creating a JSON object dynamically when issuing json_encode($array_container,true), so I'm not sure what you're asking for. Please clarify, and show what you've tried so far. — Webomatik
– Webomatik, Commented May 6, 2016 at 17:03
what i'm trying is create a an dynamic array and then convert it to json object. the results of this array is as the follows: ` [{"TEST1":"valueT1"},{"TEST1":"otherValue"}] ` and what i'm looking for is to have a json like this: ` [{"TEST1":['valueT1','otherValue']}] ` as you can see, i want to avoid duplicates keys. if is possible to check if there are an existing key . — riztak
– riztak, Commented May 6, 2016 at 17:19
Note: This line $array_container[] = array($CapaEnviar => $fila['test_name']); should be $array_container[] = array($CapaEnviar => $format_test);, don't you think? — Rajdeep Paul
– Rajdeep Paul, Commented May 6, 2016 at 17:31
no, fila['test_name'] is correct, because i want that user show text whitout "_" — riztak
– riztak, Commented May 6, 2016 at 17:52

Rajdeep Paul · Accepted Answer · 2016-05-06 18:10:31Z

2

From your comment,

...the results of this array is as the follows: [{"TEST1":"valueT1"},{"TEST1":"otherValue"}] and what i'm looking for is to have a json like this: [{"TEST1":['valueT1','otherValue']}] as you can see, i want to avoid duplicates keys.

Solution:

In your while loop, change this line

$array_container[] = array($CapaEnviar => $fila['test_name']);

to

$array_container[$CapaEnviar][] = $fila['test_name'];

Update:

how i can retrieve this key and their values through ajax?

Since you're expecting a json object from server, add this setting dataType:'json' to your AJAX request. dataType is the type of data you're expecting back from the server. And in the success() callback function, loop through the json result to get (key, value) pairs

Here's the reference:

jQuery.ajax()

So your AJAX skeleton code should be like this:

$.ajax({
    type: 'POST',
    url: 'yourpage.php',
    dataType: 'json',
    cache: 'false',

    beforeSend: function(){

    },

    success: function(data){
        $.each(data, function(key, value) {
            alert("Key:" + key + ", value: " + value);
        });
    },

    error: function(){
        // error
    }
});

edited May 6, 2016 at 18:10

answered May 6, 2016 at 17:44

Rajdeep Paul

16.9k3 gold badges21 silver badges39 bronze badges

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

4 Comments

riztak Over a year ago

Thanks, is working good!. By the way , how i can retrieve this key and their values through ajax?

riztak Over a year ago

i want to retrieve the name of key and their values, somebody has an idea?

Webomatik Over a year ago

Are you using an ajax library, something like jQuery?

Rajdeep Paul Over a year ago

@riztak I've updated my answer. Please see the Update section of my answer.

Collectives™ on Stack Overflow

How can I create a JSON object dynamically?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related