php - 从查询创建多数组

Question

我正在使用 Charts4Php 和 laravel 5.1，但我需要从查询返回多数组结果到数据库

数组示例

array(
  array(
   array('Charts',6),
   array('Apple',8),
   array('Hone',14),
   array('Gas',20))); 

数组返回

array:1 [
  0 => array:4 [
    0 => array:2 [
      0 => "Charts"
      1 => 6
    ]
    1 => array:2 [
      0 => "Apple"
      1 => 8
    ]
    2 => array:2 [
      0 => "Hone"
      1 => 14
    ]
    3 => array:2 [
      0 => "Gas"
      1 => 20
    ]
  ]
]

查询返回的数组

    array:1 [▼
    0 => {#193 ▼
    +"Apple": 55
    +"Car": 22
    +"House": 66
    +"Gas": 5
  }
]

Controller

$p = new \chartphp();
$DB = DB::Table('users')->select('Apple','Car','House','Gas')->where('id', '=', '2')->get();
 $p->data = $DB;
 $p->chart_type = "pie";
$p->title = "";
  $out = $p->render('c2');
    return('pages.test')->with('out',$out);

View 仅包含一行

{!!$out!!}

Answer 1

考虑循环查询结果，将其转换为所需的多维结构。

示例

$fields = [];
foreach($DB as $ind => $val) {
  $fields[] =  [$ind, $val]
}
$data = [ $fields ]; //Finally wrap them inside an array