Convert result_array() to JSON object

Question

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' ];

What framework are you using, json encode gives a string representation of an object/array. Have you tried just passing result_array to response? — Ben Cummins
– Ben Cummins, Commented Sep 24, 2016 at 9:28
nop , didn't tried it yet , but i think that's bad idea , it is expecting object as response not array — Zulqurnain Jutt
– Zulqurnain Jutt, Commented Sep 24, 2016 at 9:30
@BenCummins just tried your theory , and got 500: Internal Server Error — Zulqurnain Jutt
– Zulqurnain Jutt, Commented Sep 24, 2016 at 9:33

Muhammad Rehan Qadri · Accepted Answer · 2017-12-14 10:24:56Z

3

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);

edited Dec 14, 2017 at 10:24

Muhammad Rehan Qadri

7,8541 gold badge19 silver badges19 bronze badges

answered Sep 24, 2016 at 9:25

Gulmuhammad Akbari

2,0142 gold badges15 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Zulqurnain Jutt Over a year ago

should i pass $object or $json_obj to response ?

Gulmuhammad Akbari Over a year ago

Pass the $json_obj to response

Gulmuhammad Akbari Over a year ago

I don't know why some one voted my answer down, did I some thing wrong?

Zulqurnain Jutt Over a year ago

Thanks for hint , solution was using result() instead of result_array() ,

Collectives™ on Stack Overflow

Convert result_array() to JSON object

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related