php - 如何从 Mysql 中获取 json 数据并将其转换为 CodeIgniter 中的数组

Question

我得到了如下格式的 MySQL 结果。我想在应用程序中将其作为 JSON 数组格式发送。关键字数据以 JSON 数组格式存储在数据库中。如何将其作为 JSON 数组发送？

MySQL 结果

Array 
(
    [groups] => Array
        (
            [0] => stdClass Object
                (
                    [id] => 7
                    [category_name] => Serial
                    [group_name] => test group
                    [description] => efrt
                    [image] => 9955_1475731912.png
                    [time] => 07:30 AM
                    [member_count] => 0
                    [keyword] => [{"key_id":"1","key_name":"HBO"},
                                 {"key_id":"2","key_name":"BOLLYWOOD HUNGAMA"},
                                 {"key_id":"3","key_name":"SERIALS"}]
                )

        )

        "member_count": "0"
    }]
}

JSON 编码格式

{
  "groups": [
    {
      "id": "7",
      "category_name": "Serial",
      "group_name": "test group",
      "description": "efrt",
      "image": "9955_1475731912.png",
      "time": "07:30 AM",
      "member_count": "0",
      "keyword": "[{\"key_id\":\"1\",\"key_name\":\"HBO\"},
                  {\"key_id\":\"2\",\"key_name\":\"BOLLYWOOD HUNGAMA\"},
                  {\"key_id\":\"3\",\"key_name\":\"SERIALS\"}]"
    }
  ]
}

Answer 1

首先以您希望在函数内部编码的方式创建一个 php 数组或使用下面的示例在模型中(扩展 CI_Model)

$query_result = $result->result(); //for get result array 
return json_encode($query_result);

样本

    $array = array("test"=>"hhh",array("us"=>"letter","test"=>"ttt"));
    //print_r(json_encode($array));
    return json_encode($array);