How to properly format JSON string in Codeiginiter?

Question

My Codeiginiter application retrieves the data from database and stores it in the $result variable and this is then converted to JSON and I get code below:

 $data = $query->result_array();  
    $result['result'] = $data;



   { "result":[
    {"name":"John","surname":"Smith"}] }

However I want to get following JSON code but didn't have any success. Count represents number of rows. Any ideas? Thanks

{
"count": 8,
"result":[
{"name":"John","surname":"Smith"}] }

Answer 1

I assume you're calling json_encode on the $result array?

Try the following:

$data = $query->result_array();  
$result['result'] = $data;
$result['count'] = count($data);

echo json_encode($result);