php - MySql循环到JSON

Question

我有这个json

{
      "category": [
            {
                  "catname": "gallery1", 
                  "imageCar": "www.blabla.com/jpeg", 
                  "content": [
                        {
                              "name": "Loas Angeles", 
                              "address": "Seatle Street", 
                              "lat": -7.6090925, 
                              "lng": 110.209893, 
                              "imageUrl": "http://files.wordpress.com/2010/10/b21.jpg", 
                              "gallery": [
                                    {
                                          "galleryUrl": "http:/00/inboro02.jpg"
                                    }, 
                                    {
                                          "galleryUrl": "hddfd.jpg"
                                    }, 
                                    {
                                          "galleryUrl": "http://1.bsf2B3.jpg"
                                    }
                              ]
                        }
                  ]
            }
      ]
}

如何使用sql语法或php代码？

Answer 1

您在寻找json_decode()吗？