3v4l.org

run code in 300+ PHP versions simultaneously
<?php $sql = [ ['id'=>1,'user_id'=>1,'question_id'=>1,'answer'=>'3c','date'=>'2021.08.06',], ['id'=>2,'user_id'=>1,'question_id'=>2,'answer'=>'2c','date'=>'2021.08.06',], ['id'=>3,'user_id'=>1,'question_id'=>3,'answer'=>'1c','date'=>'2021.08.06',], ['id'=>4,'user_id'=>1,'question_id'=>4,'answer'=>'com','date'=>'2021.08.06',], ['id'=>5,'user_id'=>2,'question_id'=>1,'answer'=>'3','date'=>'2021.08.08',], ['id'=>6,'user_id'=>2,'question_id'=>2,'answer'=>'2','date'=>'2021.08.08',], ['id'=>7,'user_id'=>2,'question_id'=>3,'answer'=>'1','date'=>'2021.08.08',], ['id'=>8,'user_id'=>2,'question_id'=>4,'answer'=>'2comm','date'=>'2021.08.08',], ['id'=>9,'user_id'=>211,'question_id'=>1,'answer'=>'113','date'=>'2021.07.08',], ['id'=>10,'user_id'=>211,'question_id'=>2,'answer'=>'22','date'=>'2021.07.08',], ['id'=>11,'user_id'=>211,'question_id'=>3,'answer'=>'132','date'=>'2021.07.08',], ['id'=>12,'user_id'=>211,'question_id'=>4,'answer'=>'qeww','date'=>'2021.07.08',] ]; $quest = array_unique(array_column($sql, 'question_id')); sort($quest); // optional $data = []; foreach($sql as $row){ $user_id = $row['user_id']; if (!isset($data[$user_id])){ $data[$user_id] = ['date' => $row['date'], 'ans' => []]; } foreach($quest as $question_id){ if ($row['question_id'] == $question_id) { $data[$user_id]['ans'][$question_id] = $row['answer']; } } } foreach($data as $userID => $user_data){ echo '<tr>'.PHP_EOL; echo ' <td> User ID: '.$userID.'</td>'.PHP_EOL; foreach($user_data['ans'] as $q_id => $q_ans){ echo ' <td>'.$q_ans.'</td>'.PHP_EOL; } echo ' <td> Date: '.$user_data['date'].'</td>'.PHP_EOL; echo '</tr>'.PHP_EOL; }

Here you find the average performance (time & memory) of each version. A grayed out version indicates it didn't complete successfully (based on exit-code).

VersionSystem time (s)User time (s)Memory (MiB)
8.4.120.0160.00524.43
8.4.110.0130.00820.75
8.4.100.0120.00917.69
8.4.90.0110.00920.52
8.4.80.0120.00418.88
8.4.70.0080.00318.84
8.4.60.0130.00919.01
8.4.50.0110.00518.94
8.4.40.0040.00419.42
8.4.30.0060.00319.01
8.4.20.0080.01120.88
8.4.10.0070.01318.80
8.3.250.0120.00618.86
8.3.240.0120.00717.11
8.3.230.0130.00718.53
8.3.220.0110.01118.86
8.3.210.0030.00516.75
8.3.200.0060.00316.66
8.3.190.0050.00317.09
8.3.180.0110.00919.09
8.3.170.0130.00622.75
8.3.160.0140.00417.32
8.3.150.0170.00017.17
8.3.140.0130.00316.68
8.3.130.0140.00316.71
8.3.120.0060.01320.46
8.3.110.0130.00318.57
8.3.100.0050.00316.37
8.3.90.0090.00026.77
8.3.80.0030.00618.30
8.3.70.0080.00816.38
8.3.60.0090.00916.88
8.3.50.0140.00316.45
8.3.40.0070.01318.84
8.3.30.0110.00718.84
8.3.20.0050.00324.18
8.3.10.0040.01124.66
8.3.00.0050.00226.16
8.2.290.0110.00816.92
8.2.280.0090.01118.17
8.2.270.0160.00317.28
8.2.260.0110.00416.64
8.2.250.0040.00418.23
8.2.240.0000.00816.95
8.2.230.0040.00420.94
8.2.220.0040.00424.06
8.2.210.0050.00326.77
8.2.200.0060.00318.54
8.2.190.0060.00916.58
8.2.180.0040.01125.92
8.2.170.0000.01518.96
8.2.160.0070.00722.96
8.2.150.0050.00325.66
8.2.140.0000.00824.66
8.2.130.0040.00426.16
8.2.120.0050.00320.66
8.2.110.0090.00020.94
8.2.100.0040.00817.84
8.2.90.0040.00417.84
8.2.80.0080.00017.97
8.2.70.0030.00517.93
8.2.60.0040.00418.28
8.2.50.0060.00318.10
8.2.40.0000.00819.32
8.2.30.0030.00519.32
8.2.20.0050.00218.23
8.2.10.0040.00419.38
8.2.00.0050.00319.22
8.1.330.0060.00422.11
8.1.320.0130.00618.12
8.1.310.0150.00418.33
8.1.300.0100.00716.82
8.1.290.0090.00030.84
8.1.280.0120.00325.92
8.1.270.0000.00823.99
8.1.260.0040.00426.35
8.1.250.0120.00428.09
8.1.240.0100.00722.20
8.1.230.0090.00322.70
8.1.220.0000.00917.75
8.1.210.0000.00820.24
8.1.200.0060.00317.35
8.1.190.0090.00017.35
8.1.180.0030.00518.10
8.1.170.0050.00318.50
8.1.160.0040.00420.61
8.1.150.0000.00718.82
8.1.140.0050.00218.96
8.1.130.0000.00720.22
8.1.120.0070.00017.37
8.1.110.0000.00717.46
8.1.100.0000.00717.44
8.1.90.0060.00317.46
8.1.80.0050.00517.45
8.1.70.0030.00317.50
8.1.60.0030.00517.65
8.1.50.0000.00817.41
8.1.40.0060.00317.49
8.1.30.0040.00517.49
8.1.20.0030.00617.64
8.1.10.0030.00517.61
8.1.00.0080.00417.44
8.0.300.0060.00322.03
8.0.290.0070.00016.63
8.0.280.0060.00318.39
8.0.270.0060.00318.52
8.0.260.0000.00718.59
8.0.250.0070.00016.85
8.0.240.0100.00017.02
8.0.230.0030.00316.94
8.0.220.0000.00716.81
8.0.210.0000.00716.91
8.0.200.0000.00717.02
8.0.190.0030.00516.96
8.0.180.0000.00716.95
8.0.170.0030.00616.96
8.0.160.0040.00416.91
8.0.150.0040.00416.84
8.0.140.0000.00716.88
8.0.130.0060.00013.36
8.0.120.0030.00616.89
8.0.110.0050.00216.89
8.0.100.0000.00716.83
8.0.90.0050.00316.90
8.0.80.0040.00416.73
8.0.70.0000.00816.84
8.0.60.0040.00416.89
8.0.50.0040.00416.73
8.0.30.0030.00416.91
8.0.20.0000.00816.98
8.0.10.0000.00817.09
8.0.00.0040.00416.94
7.4.330.0000.00515.55
7.4.320.0000.00616.57
7.4.300.0030.00616.51
7.4.290.0070.00016.42
7.4.280.0040.00416.63
7.4.270.0070.00016.49
7.4.260.0000.00513.35
7.4.250.0030.00316.61
7.4.240.0030.00516.62
7.4.230.0050.00216.55
7.4.220.0000.00716.61
7.4.210.0000.00716.59
7.4.200.0000.00716.63
7.4.190.0030.00316.67
7.4.180.0040.00416.69
7.4.160.0070.00016.56
7.4.150.0040.00416.51
7.4.140.0040.00416.22
7.4.130.0030.00516.37
7.4.120.0080.00016.26
7.4.110.0000.00816.56
7.4.100.0030.00316.36
7.4.90.0040.00416.56
7.4.80.0030.00316.29
7.4.70.0000.00716.29
7.4.60.0040.00416.45
7.4.50.0000.00716.43
7.4.40.0030.00316.43
7.4.30.0000.00716.58
7.4.20.0000.00716.36
7.4.10.0040.00416.30
7.4.00.0070.00016.54
7.3.330.0000.00716.20
7.3.320.0020.00213.21
7.3.310.0070.00016.20
7.3.300.0000.00716.29
7.3.290.0000.00716.29
7.3.280.0000.00716.44
7.3.270.0060.00016.20
7.3.260.0000.00616.32
7.3.250.0030.00316.24
7.3.240.0000.00716.22
7.3.230.0070.00016.32
7.3.220.0000.00616.29
7.3.210.0030.00316.23
7.3.200.0070.00016.32
7.3.190.0000.00716.11
7.3.180.0070.00016.30
7.3.170.0000.00916.11
7.3.160.0040.00416.27
7.3.150.0080.00016.31
7.3.140.0000.00916.32
7.3.130.0020.00516.13
7.3.120.0000.00716.31
7.3.110.0030.00316.12
7.3.100.0000.00716.11
7.3.90.0030.00316.52
7.3.80.0070.00016.17
7.3.70.0070.00016.43
7.3.60.0000.00616.44
7.3.50.0000.00716.40
7.3.40.0020.00516.46
7.3.30.0070.00016.49
7.3.20.0000.00716.41
7.3.10.0080.00016.36
7.3.00.0040.00416.34

preferences:
123.3 ms | 403 KiB | 5 Q