JSON格式化为字符串，转换为php数组？

Question

I have a JSON string which is stored in a MYSQL DB. Example:

stdClass Object (
[product] => stdClass Object
    (
        [sold_individually] => 
        [regular_price] => 
        [managing_stock] => 1
        [sku] => 0001
        [title] => Sample title
        [reviews_allowed] => 1...

etc.

I have used utf8_encode() to convert it. How can I then turn this in to a PHP array so I can use it?

Edit 1

I have now used json_encode() when posting to the DB. I have also had to use addSlashes() as I was getting some formatting issues with some of the values.

When I now pull in the data it looks like:

"{\"product\": {\"sold_individually\": false, \"regular_price\": \"\", \"managing_stock\": true, \"sku\": \"W-C-6500\", \"title\": \"Sample title\"...

How can I pull out the value for "title"? Should I also use str_replace() to get rid of the \ issue?

Answer 1

What you printed is not JSON, it's the string representation of a php Object I think. So if possible, you should store into your database actual JSON. It's easier, cleaner and more compact.

To do so, use json_encode($your_object) to insert the data in your database.

To retrieve it, use json_decode($string_from_database).

This should work like a charm.

Note: There's a trap though, by default, json_decode will create a php Object and not an array. So you have to retrieve your fields as attributes of an object:

$data = json_decode($string_from_database);
$data->product->title; // to access title in your data structure

But if you want an array, you can provide an argument to get an array and then it works like this:

$data = json_decode($string_from_database, true);
$data['product']['title']; // to access title in your data structure

Check the php documentation of json_decode for further info!

http://php.net/manual/fr/function.json-decode.php