鍍金池/ 問答/PHP  數(shù)據(jù)庫/ php ci框架 查詢mysql 返回json數(shù)組

php ci框架 查詢mysql 返回json數(shù)組

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

現(xiàn)在的顯示是
{"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);
        }   
    }
}

我該如何修改?

回答
編輯回答
萌小萌

已解決

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Demo extends CI_Controller {

    public function index() {
       $con=mysqli_connect("localhost","root","***","test"); 
       //輸出中文可以加一句 mysqli_query($con,"SET NAMES utf8");
       $query = mysqli_query($con,"select * from user");
       $array =  array();
       while($row = mysqli_fetch_assoc($query)){
        $array[] =  $row; 
      }
      echo json_encode($array);

    }
}
2017年10月25日 10:19
編輯回答
瞄小懶
public function index() {
   $this->load->database();
   $query = $this->db->query('SELECT name, id, sex FROM user');
   echo json_encode($query);
}

這樣不久可以了嗎

2018年6月8日 07:18