How to convert array to string, suitable for JSON.stringify

Question

I have an array in the database and it looks like this: {"hello":"world", "Test":["hello"]}, which is perfect for JSON.stringify, but when I select it from the database like this:

$metadata = $this->repository->getMetadata($id);

$data = json_encode($metadata);

return $this->render('AcmeQuotesBundle:Home:metadata.html.twig', array('data' => $data));

and put this in the template:

{% block body %}
    <script>
        var obj = {{ data|raw }}

        document.body.innerHTML = "";
        document.body.appendChild(document.createTextNode(JSON.stringify(obj, null, 4)));
    </script>
{% endblock %}

I get this output:

[
    {
        "quoteMetadata": "{\"hello\":\"world\", \"Test\":[\"hello\"]}"
    }
]

which is not what I want. All I want is the value of obj to be the native string - {"hello":"world", "Test":["hello"]} without "quoteMetadata":, without the quotation marks and without the "\" around the words. I tried using implode(), but I get notice:

Notice: Array to string conversion in C:\xampp\htdocs...

I'm using Symfony2, Twig and Doctrine2 and I'm doing all this because I want the string from the database to be shown in a easy for reading way like here - http://jsfiddle.net/AndyE/HZPVL/ If you have any ideas how to fix this or how to make it in another way, plase share!

EDIT

When I put var_dump($matadata) after $metadata = $this->repository->getMetadata($id);, I get this:

array(1) { [0]=> array(1) { ["quoteMetadata"]=> string(35) "{"hello":"world", "Test":["hello"]}" } }

It looks like you're json_encode-ing something that's already json_encoded. Can you do a var_dump($quoteMetadata); after the first line and show us what it looks like? — MidnightLightning
– MidnightLightning, Commented Sep 26, 2012 at 11:18

MidnightLightning · Accepted Answer · 2012-09-26 11:25:49Z

1

The issue is your metadata array isn't clean; the bit you want is buried in an associative array inside a single-row array. So try:

$metadata = $this->repository->getMetadata($id);
return $this->render('AcmeQuotesBundle:Home:metadata.html.twig', array('data' => $metadata[0]['quoteMetadata']));

answered Sep 26, 2012 at 11:25

MidnightLightning

7,0087 gold badges48 silver badges72 bronze badges

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

1 Comment

Faery Over a year ago

Oh thank you very much! I haven't thought of that! It works perfectly!

Elias Van Ootegem · Accepted Answer · 2012-09-26 11:22:14Z

1

Your data isn't perfect for JSON.stringigy, it's perfect for JSON.parse, which turns the string into an object. Just drop the JSON.stringify if you want to output the raw string, or JSON.parse it if you want to use the data as an obejct.

answered Sep 26, 2012 at 11:22

Elias Van Ootegem

76.7k10 gold badges123 silver badges160 bronze badges

Collectives™ on Stack Overflow

How to convert array to string, suitable for JSON.stringify

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related