How to check and get json object in WP database?

Question

I need to check if an option value from database is a json object.

This funtion following cannot work :

function isJson( string $str, $is_assoc = true ){
    json_decode( $str, $is_assoc );
    return (json_last_error() == JSON_ERROR_NONE);
}

It´s normal because with an SQL query I got :

a:2:{i:3;a:4:{s:5:"title";s:0:"";s:4:"text";s:503:"...}}

instead of

{ '3' : { 'title' : "", 'text' : "..." }...}}

How can I do to check if this data is a json object and to get this data as object ?

Final goal : Reaplace correclty value for json object in the database without breaking serialized data.

Do you have control of the data? is it prepared by yourself before saving it to database? Did you try unserialize it for further manipulations? — 西門正 Code Guy - JingCodeGuy
– 西門正 Code Guy - JingCodeGuy, Commented Apr 7, 2020 at 17:32

J.BizMai · Accepted Answer · 2020-04-07 19:33:40Z

2

To check if a string from database is like a:2:{i:3;a:4:{s:5:"title";s:0:"";s:4:"text";s:503:"...}}, you can use the function is_serialized()

To get the data as php array :

if(is_serialized($data_as_string)){
    $data_as_array = unserialize( $data_as_string);
}

answered Apr 7, 2020 at 19:33

J.BizMai

9403 gold badges10 silver badges30 bronze badges

bueltge · Accepted Answer · 2025-05-05 14:27:39Z

0

You can test if it is JSON with this PHP code:

echo json_decode($s) === null ? "not json" : "json";

edited May 5 at 14:27

bueltge

17.1k7 gold badges65 silver badges97 bronze badges

answered May 2 at 13:47

Bryan C.

12 bronze badges

2 Answers 2