Codeigniter, How to get database table data displayed in json format?

Question

I have to display the result in json format. my code looks like:

 $this->db->select("*");
        $this->db->from('country');  
        $query = $this->db->get();

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

and the result looks like:

{"id":"1","country_name":"Australia","country_code":"61"}{"id":"2","country_name":"Bangladesh","country_code":"880"}{"id":"3","country_name":"Brazil","country_code":"55"}

I have to get this json in [] and separated by comma (,) . that is I want the result looks like:

[{"id":"1","country_name":"Australia","country_code":"61"},{"id":"2","country_name":"Bangladesh","country_code":"880"},{"id":"3","country_name":"Brazil","country_code":"55"}]

what all changes should I done in the code.

foreach($query->result() as $row) { $data['id']=$row->id; $data['country_name']=$row->country_name; echo json_encode($data); } not working but the result looks same — Abin Jacob
– Abin Jacob, Commented Aug 26, 2016 at 10:48

parth · Accepted Answer · 2016-08-26 10:49:12Z

4

Retrieve the record in array and then encode it

$result = $this->db->get('country')->result_array();
print_r(json_encode($result));

answered Aug 26, 2016 at 10:49

parth

1,9203 gold badges22 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Anil · Accepted Answer · 2016-08-26 10:51:06Z

2

In model write

return $query->result_array();

answered Aug 26, 2016 at 10:51

Anil

99610 silver badges21 bronze badges

Comments

Virb · Accepted Answer · 2016-08-26 10:56:43Z

1

Use result_array().

$this->db->select("*");
$this->db->from('country');  
$query = $this->db->get();

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

answered Aug 26, 2016 at 10:56

Virb

1,5781 gold badge16 silver badges25 bronze badges

Collectives™ on Stack Overflow

Codeigniter, How to get database table data displayed in json format?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related