Need to display only array value in JSON output

Question

How to display only array value in JSON out in php

I am using below PHP code

echo '{"aaData":'.json_encode($user_details).'}';

And it return below output

{"aaData": [
    {"id":"31","name":"Elankeeran","email":"[email protected]","activated":"0","phone":""}
]}

But I need JSON output like below

{"aaData": [
    {"31","Elankeeran","[email protected]","0","1234"}
]}

Any one please help on this.

Your example is not valid JSON. {} refers to an object, and objects must have properties like {"id":"31"}. The output returned by your PHP code is valid JSON. — Michael Berkowski
– Michael Berkowski, Commented Jan 21, 2012 at 14:05

Elankeeran · Accepted Answer · 2012-01-21 15:45:55Z

7

$rows = array();
foreach ($user_details as $row) {
  $rows[] = array_values((array)$row);
}

echo json_encode(array('aaData'=> $rows));

which outputs:

{"aaData": [
    ["31","Elankeeran","[email protected]","0","1234"],
    ["33","Elan","[email protected]","1",""]
]}

edited Jan 21, 2012 at 15:45

Elankeeran

6,1949 gold badges43 silver badges57 bronze badges

answered Jan 21, 2012 at 14:05

dorsh

24.9k2 gold badges30 silver badges30 bronze badges

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

7 Comments

Elankeeran Over a year ago

Dor Shemer still I am getting same result

dorsh Over a year ago

@Elankeeran What's the output of var_dump($user_details) ?

Elankeeran Over a year ago

var_dump out here array(3) { [0]=> object(stdClass)#20 (5) { ["id"]=> string(2) "31" ["name"]=> string(10) "Elankeeran" ["email"]=> string(17) "[email protected]" ["activated"]=> string(1) "0" ["phone"]=> string(0) "" } [1]=> object(stdClass)#21 (5) { ["id"]=> string(2) "33" ["name"]=> string(4) "Elan" ["email"]=> string(21) "[email protected]" ["activated"]=> string(1) "1" ["phone"]=> string(0) "" } [2]=> object(stdClass)#22 (5) { ["id"]=> string(2) "34" ["name"]=> string(6) "Elango" ["email"]=> string(17) "[email protected]" ["activated"]=> string(1) "0" ["phone"]=> string(0) "" } }

dorsh Over a year ago

In that case, you should probaby do json_encode(array('aaData'=> array_values((array)($user_details[0]))))

Elankeeran Over a year ago

thanks now i am getting one row like below {"aaData":["31","Elankeeran","[email protected]","0",""]} how to get all rows

|

rauschen · Accepted Answer · 2012-01-21 14:06:11Z

1

echo '{"aaData":'.json_encode(array_values($user_details)).'}';

should do it

answered Jan 21, 2012 at 14:06

rauschen

4,0062 gold badges15 silver badges13 bronze badges

Comments

Michael Berkowski · Accepted Answer · 2012-01-21 14:07:15Z

1

Your PHP is already producing valid JSON. To access items in it from JavaScript, use patterns like:

obj.aaData[0].name;
// Elankeeran

obj.aaData[0].email;
// [email protected]

answered Jan 21, 2012 at 14:07

Michael Berkowski

271k47 gold badges450 silver badges395 bronze badges

Collectives™ on Stack Overflow

Need to display only array value in JSON output

3 Answers 3

7 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

7 Comments

Comments

Comments

Linked

Related