Php ci framework query mysql returns json array

the effect to be obtained is
[{"name": "aaa", "id": "1", "sex", "man"}, {"name": "bbb", "id": "2", "sex", "woman"}, {}.]

now the display is
{"name": "aaa", "id": "1", "sex", "man"} {"name": "bbb", "id": "2", "sex", "woman"} {}.

my code: 

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

how should I modify it?

Php mysql
Mar.07,2021 
public function index() {
   $this->load->database();
   $query = $this->db->query('SELECT name, id, sex FROM user');
   echo json_encode($query);
}

is that all right soon

resolved 

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

    }
}

Previous: Can electron achieve the same tab function as chrome?

Next: The covering problem of js prototype chain function

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
© 2021 CodesHelper
Advertising Contact us About us
Menu