<?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>";
- Output for 5.6.0 - 5.6.40, 7.0.0 - 7.0.33, 7.1.0 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.33, 8.2.0 - 8.2.29, 8.3.0 - 8.3.25, 8.4.1 - 8.4.12
- <table><tr><td>7</td><td>45</td><td>40</td><td>65</td><td>14</td></tr><tr><td>10</td><td>53</td><td>45</td><td>69</td><td>13</td></tr></table>
preferences:
161.65 ms | 408 KiB | 5 Q