dounangshen6553 2016-09-24 09:17
浏览 64
已采纳

将result_array()转换为JSON对象

What i am trying to do is convert result_array() given by my query and directly convert it into JSON object , which can further be set in controller like this:

$this->response($jsonobject, REST_Controller:: HTTP_OK);

my attempt by studying several SO questions :

$this->response(json_encode($result_array), REST_Controller:: HTTP_OK);

but my attempt is wrong i think because it return json itself in form of string , how to achieve this then?

Example:

$pakistan = array('status' => 'OK','message' => 'yes i am ok');
// convert pakistan to something like
$pakistan = [ 'status' => 'OK','message' => 'yes i am ok' ];
  • 写回答

1条回答 默认 最新

  • dongli5785 2016-09-24 09:25
    关注

    Try to return the query result not result_array

    model function

    function getRecords(){
       $sql = 'SELECT * FROM table';
       $query = $this->db->query($sql);
       return $query->result();
    }
    

    Convert to json

    $object = getRecords();
    $json_obj = json_encode($object);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?