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"}{}...我的代码：

Answer 1

已解决
defined('BASEPATH')ORexit('Nodirectscriptaccessallowed');
classDemoextendsCI_Controller{
publicfunctionindex(){
$con=mysqli_connect("localhost","root","***","test");
//输出中文可以加一句mysqli_query($con,"SETNAMESutf8");
$query=mysqli_query($con,"select*fromuser");
$array=array();
while($row=mysqli_fetch_assoc($query)){
$array[]=$row;
}
echojson_encode($array);
}
}
                            

Answer 2

publicfunctionindex(){
$this->load->database();
$query=$this->db->query('SELECTname,id,sexFROMuser');
echojson_encode($query);
}
这样不久可以了吗