creating a json output in php

Question

This is what i would like to end up with

{
  name: 'creditor',
  y: 5600
}, {
  name: 'Supplier',
  y: 2400,
}, {
  name: 'Normal',
  y: 1038
}, {
  name: 'Suppliers',
  y: 4377
},

I have tied:

  $roles = AllUserRoles::find()->all();

  $userdata = [];
  foreach ($roles as $role) {
     $name = array('name' => $role["description"]);
     $trucks = TblTrucks::find()->where(['role_id'=>$role["id"]])->count();
     $totals = array('y'=>$trucks);
     array_push($userdata, array($name => $totals));

  }

  return json_encode($userdata);

But now am getting an illegal string offset at array_push

How can i generate json as above from php?

Why did you decide on array_push? A simple append $list[] = [...] would have been easier, and avoided $name being an array. — mario
– mario, Commented Aug 22, 2017 at 20:56

Death-is-the-real-truth · Accepted Answer · 2017-08-22 21:00:23Z

2

You have to do it like below:-

$roles = AllUserRoles::find()->all();

$userdata = [];
foreach ($roles as $role) {
    $name = $role["description"];
    $trucks = TblTrucks::find()->where(['role_id'=>$role["id"]])->count();
    $userdata[] = ['name'=>$name,'y'=> $trucks]; // assign data directly

}
return json_encode($userdata);

edited Aug 22, 2017 at 21:00

answered Aug 22, 2017 at 20:55

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

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

3 Comments

AbraCadaver Over a year ago

'y'=> $trucks

Death-is-the-real-truth Over a year ago

@AbraCadaver i am in the process of editing that. thanks for telling BTW

Geoff Over a year ago

ok i cant mark before 7 mins are over but will surely mark it.

Collectives™ on Stack Overflow

creating a json output in php

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related