php - convert mysql data into json object

Question

I using codeigniter. I want to retrive data from database and convert it into JSON object not JSON array.I'm using following code

    public function json()
 {
        $content = $this->db->get('todolist'); //todolist table name
        $data = $content->result_array();
        echo json_encode($data);
 }

Above code is converting database into JSON array. Output

[{"todo_id":"1","todo_content":"Homework","date":"2016-05-05","iscomplete":null,"imagelink":"Lighthouse.jpg"},{"todo_id":"2","todo_content":"exam","date":"2015-04-21","iscomplete":null,"imagelink":"Desert.jpg"},{"todo_id":"3","todo_content":"Lab report","date":"2014-08-29","iscomplete":null,"imagelink":"FB_IMG_14700753538617403.jpg"}]

What will be best way to convert it into JSON object

Do you want the keys of the object to be numerical? Why do you even want to force an object? — user5051310
– user5051310, Commented Dec 19, 2016 at 5:39

TIGER · Accepted Answer · 2016-12-19 05:31:56Z

4

Sangam try to understand the concept, check the following line:

$data = $content->result_array();    // $data is an array
echo json_encode($data);             // here you are converting it into an json object

Your $data array contains more than one index in it that's why the json object is having multiple {} inside [];

edited Dec 19, 2016 at 5:31

TIGER

2,9055 gold badges38 silver badges46 bronze badges

answered Dec 19, 2016 at 5:25

Mayank Pandeyz

26.3k4 gold badges43 silver badges61 bronze badges

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

1 Comment

kishor10d Over a year ago

Thumbs up! This is what really happening with you. You need to iterate that object by javascript if you want the values to process.

Community · Accepted Answer · 2017-05-23 10:29:43Z

2

You want to json_encode($data, JSON_FORCE_OBJECT).

The JSON_FORCE_OBJECT flag, as the name implies, forces the json output to be an object, even when it otherwise would normally be represented as an array.

Refer: PHP Array to Json Object

edited May 23, 2017 at 10:29

CommunityBot

11 silver badge

answered Dec 19, 2016 at 5:26

Ramalingam Perumal

1,4283 gold badges18 silver badges47 bronze badges

Comments

TIGER · Accepted Answer · 2016-12-19 05:26:27Z

1

You can use JSON_FORCE_OBJECT see the example below.

 echo json_encode($data, JSON_FORCE_OBJECT);

answered Dec 19, 2016 at 5:26

TIGER

2,9055 gold badges38 silver badges46 bronze badges

Comments

aconnelly · Accepted Answer · 2016-12-19 05:23:30Z

-1

Assuming you're only getting one row back from your query.

change

echo json_encode($data);

to

echo json_encode($data[0]);

answered Dec 19, 2016 at 5:23

aconnelly

6371 gold badge6 silver badges13 bronze badges

Collectives™ on Stack Overflow

php - convert mysql data into json object

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related