SQL query print JSON data

Question

I am currently printing data from an SQL query using print json_encode($query->result());

Which is giving a result of all the fields in the database. It currently prints :

[{"id":"3812","assigned_to":"1","opportunity_id":null,"lead_stage":"1","first_name":"Jamie","last_name":"Warren","company_name":"","phone_number":"+1","email_address":"[email protected]"},

However I need it to print in the following format :

items": [
    { "id":"3812"

How can i add the items part?

Ethan · Accepted Answer · 2018-11-12 10:45:23Z

1

You can just json_encode a new array with $query->result() assigned to a key of 'items' like this:

print json_encode(['items' => $query->result()]);

answered Nov 12, 2018 at 10:45

Ethan

4,4054 gold badges27 silver badges49 bronze badges

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

Comments

Ayaz Ali Shah · Accepted Answer · 2018-11-12 10:47:30Z

0

You can wrap up with an array as like below

print json_encode(array('items' => $query->result()));

OR

$items_arr = array('items' => $query->result());
print json_encode($items_arr);

answered Nov 12, 2018 at 10:47

Ayaz Ali Shah

3,5419 gold badges42 silver badges68 bronze badges

Collectives™ on Stack Overflow

SQL query print JSON data

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related