How to fetch json data from Mysql and convert it to an array in CodeIgniter

Question

I have get the MySQL result as below format. I want to send this as JSON array format in an app.The keyword data are stored JSON array format in db. How to send this as JSON array ?

MySQL RESULT

Array 
(
    [groups] => Array
        (
            [0] => stdClass Object
                (
                    [id] => 7
                    [category_name] => Serial
                    [group_name] => test group
                    [description] => efrt
                    [image] => 9955_1475731912.png
                    [time] => 07:30 AM
                    [member_count] => 0
                    [keyword] => [{"key_id":"1","key_name":"HBO"},
                                 {"key_id":"2","key_name":"BOLLYWOOD HUNGAMA"},
                                 {"key_id":"3","key_name":"SERIALS"}]
                )

        )

        "member_count": "0"
    }]
}

JSON ENCODE FORMAT

{
  "groups": [
    {
      "id": "7",
      "category_name": "Serial",
      "group_name": "test group",
      "description": "efrt",
      "image": "9955_1475731912.png",
      "time": "07:30 AM",
      "member_count": "0",
      "keyword": "[{\"key_id\":\"1\",\"key_name\":\"HBO\"},
                  {\"key_id\":\"2\",\"key_name\":\"BOLLYWOOD HUNGAMA\"},
                  {\"key_id\":\"3\",\"key_name\":\"SERIALS\"}]"
    }
  ]
}

Possible duplicate of PHP > How to skip an element while using json_encode — Pathik Vejani
– Pathik Vejani, Commented Oct 6, 2016 at 7:41
Thanq all . Got d answer . Special thanks to @AlexanderPopov — Miya
– Miya, Commented Oct 6, 2016 at 9:07

User123456 · Accepted Answer · 2016-10-06 09:15:52Z

1

First create a php array in the way you want to encode in-side the function or use the below sample in model (which extends CI_Model)

$query_result = $result->result(); //for get result array 
return json_encode($query_result);

sample

    $array = array("test"=>"hhh",array("us"=>"letter","test"=>"ttt"));
    //print_r(json_encode($array));
    return json_encode($array);

edited Oct 6, 2016 at 9:15

answered Oct 6, 2016 at 7:42

User123456

2,7483 gold badges31 silver badges46 bronze badges

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

Comments

Miya · Accepted Answer · 2016-10-06 09:12:56Z

0

I use this method for my Question

    foreach ($result['groups'] as $key ) {
                $json = $key->keyword;
                $keys = json_decode($json);
                $arrayName = array();
                foreach ($keys as $value) {
                     $key_id = $value->key_id;
                     $key_name = $value->key_name;
                     $arrayName[] = array('key_id' =>$key_id ,'key_name'              =>$key_name);
                }
    $key->keyword =  $arrayName;
 }
 $result['success']= 1; 
 echo json_encode($result);
 exit();

answered Oct 6, 2016 at 9:12

Miya

309 bronze badges

Comments

jobinrjohnson · Accepted Answer · 2016-10-06 15:37:31Z

0

$this->output
    ->set_content_type('application/json')
    ->set_output(json_encode($result->result()->groups));

I think this will solve it

answered Oct 6, 2016 at 15:37

jobinrjohnson

5585 silver badges13 bronze badges

Collectives™ on Stack Overflow

How to fetch json data from Mysql and convert it to an array in CodeIgniter

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related