Laravel:如何将数组从查询结果分离到变量中?

Question

我有这样的东西：

return Model::get()->pluck('count','column');
Result:
{"ABC":1,"DEF":3,"GHI":1,"JKL":2}

如何将"列"和"计数"分成变量？

$column = ["ABC","DEF","GHI","JKL"];
$count = [1,3,1,2];

Answer 1

使用原生 PHP 函数;array_keys和array_values.

$result = Model::get()->pluck('count', 'column');
$column = array_keys($result);
$count = array_values($result);

有关更多详细信息，请阅读以下链接;

https://www.php.net/manual/en/function.array-keys.php

https://www.php.net/manual/en/function.array-values.php

Answer 2

试试这个

$array = Model::pluck('count','column')->toArray();
$key   = array_keys($array);
$values = array_values($array);