How to correctly encode json in PHP (double quotes issue)

Question

I am trying to create a valid JSON from my Wordpress custom fields. I am having issues here:

{"eu_price":"400", // this one is ok
 "other_prices":["{\"GBP\":\"330\",\"USD\":\"525\"}"] // this is not
}

How do I get rid of those slashes?

I am grabbing the data from a MySql database field, using this Wordpress function:

$my_product[other_prices] = get_post_meta( $product_id, '_regular_currency_prices', false );

Then I am using:

echo json_encode($my_product, JSON_UNESCAPED_SLASHES);

in order to return an encoded result.

In the database the field content is like:

{"GBP":"330","USD":"525"}

The full json response is:

{"user_country":"US","title":"Dress  1960","permalink":"http://site.dev/my_slug/","eu_price":"350","other_prices":["{\"GBP\":\"290\",\"USD\":\"460\"}"],"main_image":"http://doublej.dev/wp-content/uploads/2015/01/1100000003274_0-300x300.jpg"}

Paul Dixon · Accepted Answer · 2015-03-05 16:10:05Z

2

When you set $my_product['other_prices'] you are setting it as a string. If the database contains JSON, you'll need to decode it so that when when re-encode your response, it all makes sense.

$jsonEncodedData = get_post_meta( $product_id, '_regular_currency_prices', false );
$my_product['other_prices'] = json_decode($jsonEncodedData)

answered Mar 5, 2015 at 16:10

Paul Dixon

302k54 gold badges315 silver badges349 bronze badges

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

4 Comments

akmur Over a year ago

Thanks for your answer, I already tried this, but as a result I get "null" instead. I wonder what I'm missing

Paul Dixon Over a year ago

well, then your data is probably invalid JSON - shouldn't be hard to diagnose that

akmur Over a year ago

I guess so, but I don't see why it doesn't work. If I try to hardcode $my_product[other_prices] = {"GBP":"330","USD":"525"} it works

Paul Dixon Over a year ago

From your post, it looks like get_post_meta returns an array containing a string - if that's the case you'll need something like json_decode($jsonEncodedData[0])

Steve · Accepted Answer · 2015-03-05 16:11:44Z

0

Dont manually build json string, use json_encode:

echo json_encode([
        'eu_price'=>'400',
        'other_prices'=>[
            'GBP'=>'330',
            'USD'=>'525'
        ]
    ]);

edited Mar 5, 2015 at 16:11

answered Mar 5, 2015 at 16:01

Steve

20.5k5 gold badges47 silver badges71 bronze badges

1 Comment

Steve Over a year ago

Well, Pauls answer is what i would suggest, if part of the data is already encoded.

Collectives™ on Stack Overflow

How to correctly encode json in PHP (double quotes issue)

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related