php ci框架 查询mysql 返回json数组

Question

要获得的效果是：
[{"name":"aaa","id":"1","sex","man"},{"name":"bbb","id":"2","sex","woman"},{}...]

现在的显示是
{"name":"aaa","id":"1","sex","man"}{"name":"bbb","id":"2","sex","woman"}{}...

我的代码：

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Demo extends CI_Controller {
    public function index() {
       $this->load->database();
       $query = $this->db->query('SELECT name, id, sex FROM user');

       foreach ($query->result() as $row){
       echo json_encode($row);
        }   
    }
}

我该如何修改?

Answer 1

public function index() { $this->load->database(); $query = $this->db->query('SELECT name, id, sex FROM user'); echo json_encode($query); } 这样不久可以了吗