3v4l.org

run code in 300+ PHP versions simultaneously
<?php $con = mysqli_connect("localhost","fgxbidper","QajCBPx4W2Zw9U6c","fgx_bidper"); $sql = "SELECT peopleID, firstName, lastName, valueEx FROM exchange inner join people on people.id = exchange.peopleID WHERE curHave = (SELECT CurWant FROM exchange WHERE peopleID = 24) and finished = 0 and peopleID <> 24"; $res = mysqli_query($con,$sql); $result = array(); while($row = mysqli_fetch_array($res)){ array_push($result, array('id'=>$row[0], 'curHave'=>$row[1], 'curWant'=>$row[2], 'countryLive'=>$row[3])); } echo json_encode(array("result"=>$result)); mysqli_close($con); ?>

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.3.40.0070.00718.70
8.3.30.0120.00318.89
8.3.20.0090.00020.36
8.3.10.0000.00823.61
8.3.00.0080.00019.50
8.2.170.0070.00722.96
8.2.160.0100.00320.52
8.2.150.0050.00324.18
8.2.140.0030.00524.66
8.2.130.0100.00017.38
8.2.120.0000.00826.35
8.2.110.0060.00320.48
8.2.100.0040.00817.80
8.2.90.0000.00719.14
8.2.80.0030.00517.97
8.2.70.0060.00317.25
8.2.60.0000.00817.91
8.2.50.0000.00818.07
8.2.40.0000.00719.38
8.2.30.0050.00320.52
8.2.20.0000.00817.69
8.2.10.0070.00018.01
8.2.00.0040.00418.02
8.1.270.0030.00522.18
8.1.260.0050.00328.09
8.1.250.0060.00328.09
8.1.240.0060.00322.46
8.1.230.0060.00617.64
8.1.220.0000.00717.74
8.1.210.0080.00018.77
8.1.200.0030.00617.10
8.1.190.0030.00617.13
8.1.180.0040.00418.10
8.1.170.0000.00718.87
8.1.160.0000.00822.08
8.1.150.0070.00018.72
8.1.140.0000.00819.52
8.1.130.0050.00317.61
8.1.120.0030.00517.36
8.1.110.0000.00717.36
8.1.100.0040.00317.39
8.1.90.0050.00217.26
8.1.80.0040.00417.35
8.1.70.0030.00517.18
8.1.60.0030.00517.46
8.1.50.0050.00317.48
8.1.40.0060.00317.44
8.1.30.0060.00317.60
8.1.20.0000.00817.55
8.1.10.0000.00817.58
8.1.00.0000.00817.43
8.0.300.0060.00318.77
8.0.290.0030.00516.75
8.0.280.0000.00818.32
8.0.270.0040.00417.15
8.0.260.0050.00317.27
8.0.250.0070.00016.95
8.0.240.0000.00616.97
8.0.230.0040.00416.89
8.0.220.0070.00016.92
8.0.210.0050.00216.92
8.0.200.0000.00616.86
8.0.190.0000.00716.97
8.0.180.0040.00416.97
8.0.170.0030.00616.90
8.0.160.0030.00316.75
8.0.150.0000.00716.77
8.0.140.0000.01116.74
8.0.130.0030.00313.31
8.0.120.0080.00016.74
8.0.110.0050.00316.93
8.0.100.0000.00716.81
8.0.90.0030.00616.98
8.0.80.0060.01016.87
8.0.70.0080.00016.91
8.0.60.0000.00816.87
8.0.50.0040.00416.87
8.0.30.0060.01316.96
8.0.20.0080.01017.40
8.0.10.0040.00416.92
8.0.00.0070.01016.86
7.4.330.0030.00315.08
7.4.320.0030.00316.32
7.4.300.0000.00616.41
7.4.290.0030.00316.54
7.4.280.0030.00516.54
7.4.270.0000.00716.56
7.4.260.0030.00516.47
7.4.250.0060.00316.57
7.4.240.0050.00216.51
7.4.230.0050.00316.45
7.4.220.0120.00616.50
7.4.210.0110.00916.54
7.4.200.0070.00016.54
7.4.160.0090.00616.32
7.4.150.0140.00317.40
7.4.140.0090.00817.86
7.4.130.0070.01116.52
7.4.120.0100.00716.49
7.4.110.0110.00616.36
7.4.100.0150.00716.52
7.4.90.0090.00916.54
7.4.80.0080.00819.39
7.4.70.0130.01016.54
7.4.60.0040.01216.42
7.4.50.0000.00816.39
7.4.40.0030.01416.61
7.4.30.0130.01016.59
7.4.00.0050.01114.98
7.3.330.0050.00013.12
7.3.320.0060.00013.23
7.3.310.0030.00316.17
7.3.300.0030.00316.28
7.3.290.0000.00616.30
7.3.280.0100.00916.29
7.3.270.0030.01417.40
7.3.260.0180.00616.27
7.3.250.0100.00816.33
7.3.240.0080.01216.22
7.3.230.0080.00816.52
7.3.210.0070.01016.31
7.3.200.0420.00716.28
7.3.190.0130.00316.58
7.3.180.0070.01016.32
7.3.170.0070.01016.27
7.3.160.0110.00516.38
7.3.120.0050.01114.70
7.3.110.0100.00614.67
7.3.100.0080.01014.73
7.3.90.0100.00414.82
7.3.80.0040.01214.62
7.3.70.0050.00914.81
7.3.60.0040.01214.73
7.3.50.0020.00914.78
7.3.40.0080.00614.73
7.3.30.0020.00814.69
7.3.20.0020.01016.52
7.3.10.0020.01116.72
7.3.00.0080.00316.49
7.2.330.0180.00016.57
7.2.320.0090.00916.61
7.2.310.0060.01016.45
7.2.300.0070.01016.38
7.2.290.0150.00716.55
7.2.250.0080.00915.02
7.2.240.0030.01314.78
7.2.230.0060.01114.86
7.2.220.0020.01314.74
7.2.210.0060.00714.88
7.2.200.0100.00214.90
7.2.190.0090.00414.62
7.2.180.0060.00714.84
7.2.170.0030.01014.83
7.2.160.0070.00714.87
7.2.150.0000.01416.50
7.2.140.0070.00316.87
7.2.130.0000.01816.55
7.2.120.0030.01316.54
7.2.110.0000.01116.75
7.2.100.0040.01116.77
7.2.90.0070.00416.63
7.2.80.0070.01116.81
7.2.70.0040.01416.79
7.2.60.0090.00716.78
7.2.50.0040.01216.59
7.2.40.0110.00416.88
7.2.30.0080.00616.76
7.2.20.0060.00316.73
7.2.10.0030.00916.52
7.2.00.0060.00617.97
7.1.330.0090.00715.66
7.1.320.0050.00815.49
7.1.310.0070.00715.47
7.1.300.0050.00915.58
7.1.290.0070.00515.52
7.1.280.0040.00815.65
7.1.270.0070.00615.63
7.1.260.0050.00915.55
7.1.250.0100.00715.79
7.1.240.0030.01415.68
7.1.230.0030.00915.51
7.1.220.0040.01115.64
7.1.210.0060.00915.53
7.1.200.0090.00415.62
7.1.190.0000.01315.43
7.1.180.0000.00915.76
7.1.170.0000.01115.70
7.1.160.0040.00415.46
7.1.150.0070.00715.55
7.1.140.0040.00415.71
7.1.130.0030.01015.67
7.1.120.0040.00415.24
7.1.110.0060.00615.80
7.1.100.0040.01016.68
7.1.90.0070.01015.56
7.1.80.0060.01015.57
7.1.70.0030.00816.26
7.1.60.0100.01017.58
7.1.50.0050.00716.30
7.1.40.0060.01315.41
7.1.30.0060.00615.40
7.1.20.0070.00715.71
7.1.10.0000.00815.66
7.1.00.0100.03818.89
7.0.330.0060.01015.17
7.0.320.0030.01315.08
7.0.310.0030.00615.03
7.0.300.0000.01115.36
7.0.290.0000.00915.27
7.0.280.0030.01015.13
7.0.270.0030.01015.07
7.0.260.0070.00315.26
7.0.250.0040.00715.31
7.0.240.0060.00315.48
7.0.230.0160.00015.14
7.0.220.0000.01215.38
7.0.210.0030.01015.43
7.0.200.0050.00714.96
7.0.190.0000.01215.04
7.0.180.0030.00715.49
7.0.170.0110.00715.47
7.0.160.0040.00415.36
7.0.150.0030.00815.29
7.0.140.0030.01615.35
7.0.130.0070.01115.52
7.0.120.0030.00715.45
7.0.110.0040.01115.38
7.0.100.0090.00315.45
7.0.90.0220.02717.57
7.0.80.0230.03617.69
7.0.70.0240.02917.71
7.0.60.0130.02517.60
7.0.50.0160.02017.75
7.0.40.0020.02616.78
7.0.30.0080.04016.89
7.0.20.0050.02816.72
7.0.10.0100.03216.77
7.0.00.0130.02816.62
5.6.400.0140.00014.54
5.6.390.0070.01013.91
5.6.380.0040.00813.85
5.6.370.0000.01114.30
5.6.360.0090.00613.95
5.6.350.0040.00714.06
5.6.340.0030.01014.32
5.6.330.0070.00714.08
5.6.320.0000.01514.19
5.6.310.0000.01214.10
5.6.300.0030.01314.19
5.6.290.0150.00014.27
5.6.280.0030.04017.72
5.6.270.0050.00514.29
5.6.260.0060.00614.17
5.6.250.0040.00814.27
5.6.240.0070.02317.40
5.6.230.0000.03217.45
5.6.220.0080.04017.36
5.6.210.0030.02617.31
5.6.200.0020.03017.71
5.6.190.0080.02117.56
5.6.180.0080.02217.75
5.6.170.0080.04417.60
5.6.160.0080.04417.54
5.6.150.0070.04717.45
5.6.140.0050.02317.68
5.6.130.0080.04717.67
5.6.120.0020.03717.53
5.6.110.0080.05217.59
5.6.100.0050.04217.54
5.6.90.0100.04017.56
5.6.80.0080.04017.32
5.6.70.0020.03417.07
5.6.60.0010.04617.15
5.6.50.0030.03217.21
5.6.40.0050.04317.26
5.6.30.0080.04217.24
5.6.20.0050.04217.23
5.6.10.0120.03717.11
5.6.00.0050.04217.16
5.5.380.0050.02317.29
5.5.370.0070.02017.03
5.5.360.0070.02817.36
5.5.350.0020.02517.07
5.5.340.0050.02517.44
5.5.330.0070.02517.45
5.5.320.0130.01317.41
5.5.310.0080.02717.56
5.5.300.0060.04517.44
5.5.290.0050.04717.45
5.5.280.0120.03817.52
5.5.270.0060.04417.42
5.5.260.0150.03517.36
5.5.250.0040.04717.30
5.5.240.0090.04217.01
5.5.230.0140.03316.89
5.5.220.0090.03617.23
5.5.210.0110.03717.24
5.5.200.0110.03417.13
5.5.190.0030.04717.06
5.5.180.0100.04417.11
5.5.170.0030.01413.82
5.5.160.0120.02316.96
5.5.150.0020.04417.14
5.5.140.0080.04217.04
5.5.130.0070.03417.07
5.5.120.0030.04716.98
5.5.110.0100.03717.17
5.5.100.0090.04017.02
5.5.90.0070.04316.90
5.5.80.0070.03817.09
5.5.70.0110.04117.03
5.5.60.0050.03317.06
5.5.50.0050.04217.03
5.5.40.0030.04316.91
5.5.30.0130.03816.90
5.5.20.0100.04217.09
5.5.10.0130.03816.88
5.5.00.0050.04516.88

preferences:
36.29 ms | 400 KiB | 5 Q