存储位于对象内部的数组

Question

I have the following JSON:

"list": {
            "list_id": "2kA",
            "title": "Social Media",
            "description": "Trending",
            "image": [
                "http://cdn.socialmediaexaminer.com/wp-content/uploads/2012/11/br-campaign-report.png?9d7bd4",
                "http://cdn.socialmediaexaminer.com/wp-content/uploads/2012/11/br-campaign-report.png?9d7bd"
            ],
            "views": 65
        }

How can I store a serialized version of the image array in the database? Doing any of the following returns an error:

$images = $item->list->image;
$images = $item->list->image->[0];
$images = $item->list->['image'];

Thanks guys!

Answer 1

you can access to your images like this:

foreach($item->list->image as $your_image) {
    //do what you want
}

or use a associated array like this

$x = json_decode('{"list": {
            "list_id": "2kA",
            "title": "Social Media",
            "description": "Trending",
            "image": [
                "a",
                "b"
            ],
            "views": 65
        }}', true);

foreach($x['list']['image'] as $your_image) {
    //do what you want
}

to save it to your db use json_encode (and escape), as example of a mysqli connection

$query = 'INSERT INTO your_table (...)
          VALUES (\''.mysqli_real_escape_string($dblink, json_encode($your_array)).'\')';

on select you can use json_decode!