<?php
$data = <<<DATA
[
{
"user_id": "7",
"field": "1",
"value": "45"
},
{
"user_id": "10",
"field": "1",
"value": "53"
},
{
"user_id": "7",
"field": "2",
"value": "40"
},
{
"user_id": "10",
"field": "2",
"value": "45"
},
{
"user_id": "7",
"field": "3",
"value": "65"
},
{
"user_id": "10",
"field": "3",
"value": "69"
},
{
"user_id": "7",
"field": "4",
"value": "14"
},
{
"user_id": "10",
"field": "4",
"value": "13"
}
]
DATA;
$arrays = json_decode($data, true);
$results = [];
foreach ($arrays as $value) {
$results[$value['user_id']][] = $value['value'];
}
echo "<table>";
foreach ($results as $key => $result) {
echo "<tr><td>$key</td>";
foreach ($result as $col) {
echo "<td>$col</td>";
}
echo "</tr>";
}
echo "</table>";
preferences:
26.76 ms | 404 KiB | 5 Q