PHP json encoded string escaping

Question

I need to escape json encoded string.

I have encode below string.

json_encode(['test1' => '','test2' => '','test3' => ''])

It will store in mysql table like,

"{\"test1\":\"\",\"test2\":\"\",\"test3\":\"\"}"

I want to store like,

{"test":"","test2":"","test3":""}

Thank you !

Why don't just decode it when you fetch it? since it's a json, you still need to decode it even though you didn't want to escape it when inserting on a database. — Tenten Ponce
– Tenten Ponce, Commented Jan 3, 2018 at 7:05
I think there's a misconception about escaping here. You really don't need to store it escaped. — Capsule
– Capsule, Commented Jan 3, 2018 at 7:13
It's better but it still doesn't change the fact you don't need to store it escaped. Just store it as is and decode it when you read it from the DB. That question is not a real one, you are just trying to solve an issue that is not one in the first place, in a convoluted way on top of that. — Capsule
– Capsule, Commented Jan 3, 2018 at 7:21

Aman Kumar · Accepted Answer · 2018-01-03 07:09:16Z

2

Try below code

<?php
$json = json_encode(['test1' => '','test2' => '','test3' => '']);
$dbjson = "{\"title\":\"\",\"description\":\"\",\"keywords\":\"\"}";

echo "<pre>";
$value = json_encode(json_decode($dbjson));
print_r($value); // output : {"title":"","description":"","keywords":""}
?>

answered Jan 3, 2018 at 7:09

Aman Kumar

4,5573 gold badges21 silver badges40 bronze badges

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

1 Comment

Capsule Over a year ago

You need to escape quotes to write your string, but the actual string doesn't contain the escape characters so the decode/encode is just a waste of time and you could just print $dbjson and get the same result

Abdulla Nilam · Accepted Answer · 2018-01-03 07:07:14Z

1

Add JSON_UNESCAPED_SLASHES as last argument

echo json_encode(['test1' => '','test2' => '','test3' => ''],JSON_UNESCAPED_SLASHES)

Output

{"test1":"","test2":"","test3":""}

answered Jan 3, 2018 at 7:07

Abdulla Nilam

39.7k18 gold badges85 silver badges115 bronze badges

3 Comments

Capsule Over a year ago

JSON_UNESCAPED_SLASHES won't escape forward slashes, I don't see any link with the original question

Abdulla Nilam Over a year ago

@Capsule Who said to escape slash. It's before saving DB.

Capsule Over a year ago

json_encode(['test1' => '','test2' => '','test3' => ''],JSON_UNESCAPED_SLASHES) and json_encode(['test1' => '','test2' => '','test3' => '']) will both output exactly the same string: {"test1":"","test2":"","test3":""}

Nims Patel · Accepted Answer · 2018-01-06 07:11:29Z

0

You can use stripslashes function

$string = '{\"title\":\"\",\"description\":\"\",\"keywords\":\"\"}';
echo stripslashes($string);

And also you can Use preg_replace

<?php
 $string = '{\"title\":\"\",\"description\":\"\",\"keywords\":\"\"}';
 echo $new_str = preg_replace('~[\\\\/*?<>|]~', '', $string);
?>

Output :

{ "title ": "", "description ": "", "keywords ": ""}

edited Jan 6, 2018 at 7:11

answered Jan 3, 2018 at 7:07

Nims Patel

1,0569 silver badges19 bronze badges

4 Comments

Abdulla Nilam Over a year ago

Nice copy Paste. In your first answer you're showing { "title ": "", "description ": "", "keywords ": ""} and second one 'test1' => '','test2' => '','test3' => ''

Nims Patel Over a year ago

Now it's fine ? @AbdullaNilam :)

Capsule Over a year ago

Basically, rewriting php.net/manual/en/function.stripslashes.php?

Nims Patel Over a year ago

Thanks @Capsule, Right Stripslashes function is use for that.

Collectives™ on Stack Overflow

PHP json encoded string escaping

3 Answers 3

1 Comment

3 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

3 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related