3v4l.org

run code in 300+ PHP versions simultaneously
<?php $verbindung = mysqli_connect("server","user","pw"); mysqli_select_db($verbindung,"userdaten"); /* Ermittlung der eigenen ID */ $abfrage = "select userid from accountdaten where username = '" . $_SESSION["username"] . "'"; $ergebnis = mysqli_query($verbindung, $abfrage) OR die("Error: $abfrage <br>".mysqli_error()); $row = mysqli_fetch_assoc($ergebnis); /* Ermittlung der ID des Freundes */ $abfrage2 = "select freundid from freunde where userid = " . $row["userid"] . ""; $ergebnis2 = mysqli_query($verbindung, $abfrage2) OR die("Error: $abfrage2 <br>".mysqli_error()); $row2 = mysqli_fetch_assoc($ergebnis2); $num = mysqli_num_rows($ergebnis2); /* Prüfung, ob man bisher schon Freunde hat */ if($num == 0) { echo "Du hast bisher noch keine Freunde."; } else { /* Ermittlung des Usernamen und den Online-Status des Freundes */ $abfrage3 = "select username, online from accountdaten where userid = " . $row2["freundid"] . ""; $ergebnis3 = mysqli_query($verbindung, $abfrage3) OR die("Error: $abfrage3 <br>".mysqli_error()); $row3 = mysqli_fetch_assoc($ergebnis3); /* Ermittlung der Userdaten, die für die Ausgabe gebraucht werden */ $abfrage4 = "select nation, klasse, Level from userwerte where userid = " . $row2["freundid"] . ""; $ergebnis4 = mysqli_query($verbindung, $abfrage4) OR die("Error: $abfrage4 <br>".mysqli_error()); echo "<table>"; echo "<thead><tr> <th>Name</th> <th>Herkunft</th> <th>Klasse</th> <th>Level</th> <th>Online-Status</th> </tr></thead> <tbody>"; while($dsatz = mysqli_fetch_array($ergebnis4, MYSQL_ASSOC)) { echo "<tr>"; /* Wie kann ich $row3 mit in die while Funktion einbringen? */ echo "<td>" . $row3["username"] . "</td>"; echo "<td>" . $dsatz["nation"] . "</td>"; echo "<td>" . $dsatz["klasse"] . "</td>"; echo "<td>" . $dsatz["Level"] . "</td>"; echo "<td></td>"; echo "</tr>"; } echo "</tbody></table>"; } mysqli_close($verbindung); ?>

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.60.0040.01118.27
8.3.50.0240.00722.92
8.3.40.0100.00618.84
8.3.30.0030.01019.21
8.3.20.0040.00420.34
8.3.10.0050.00323.65
8.3.00.0060.00319.38
8.2.180.0080.01116.63
8.2.170.0110.00722.96
8.2.160.0040.01120.35
8.2.150.0080.00024.18
8.2.140.0040.00424.66
8.2.130.0000.00826.16
8.2.120.0030.00720.97
8.2.110.0030.00622.00
8.2.100.0000.01117.84
8.2.90.0030.00619.07
8.2.80.0060.00317.97
8.2.70.0080.00017.63
8.2.60.0030.00517.92
8.2.50.0030.00618.07
8.2.40.0030.00619.95
8.2.30.0100.00017.92
8.2.20.0040.00417.81
8.2.10.0060.00317.90
8.2.00.0050.00217.60
8.1.280.0110.00325.92
8.1.270.0080.00023.83
8.1.260.0040.00426.35
8.1.250.0070.00028.09
8.1.240.0060.00323.82
8.1.230.0120.00019.14
8.1.220.0050.00317.74
8.1.210.0040.00418.77
8.1.200.0090.00317.25
8.1.190.0030.00617.13
8.1.180.0080.00018.10
8.1.170.0040.00418.53
8.1.160.0080.00021.91
8.1.150.0050.00218.80
8.1.140.0070.00017.30
8.1.130.0000.00817.85
8.1.120.0040.00417.26
8.1.110.0040.00417.37
8.1.100.0070.00317.27
8.1.90.0050.00217.37
8.1.80.0040.00417.26
8.1.70.0040.00417.33
8.1.60.0040.00417.46
8.1.50.0040.00417.39
8.1.40.0040.00417.48
8.1.30.0000.00817.48
8.1.20.0040.00417.52
8.1.10.0040.00417.44
8.1.00.0050.00317.51
8.0.300.0030.00518.77
8.0.290.0030.00516.88
8.0.280.0040.00418.38
8.0.270.0000.00717.23
8.0.260.0030.00317.25
8.0.250.0070.00017.02
8.0.240.0060.00317.01
8.0.230.0070.00017.01
8.0.220.0070.00016.92
8.0.210.0070.00016.82
8.0.200.0060.00016.98
8.0.190.0000.00916.97
8.0.180.0000.00816.87
8.0.170.0040.00416.99
8.0.160.0000.00716.88
8.0.150.0040.00416.86
8.0.140.0030.00616.84
8.0.130.0060.00013.40
8.0.120.0000.00716.82
8.0.110.0000.00716.87
8.0.100.0040.00416.97
8.0.90.0030.00516.90
8.0.80.0060.01516.86
8.0.70.0060.00316.89
8.0.60.0040.00416.82
8.0.50.0030.00616.84
8.0.30.0080.01116.98
8.0.20.0130.00717.40
8.0.10.0070.00017.05
8.0.00.0120.00616.71
7.4.330.0000.00615.05
7.4.320.0060.00016.43
7.4.300.0040.00416.58
7.4.290.0000.00716.41
7.4.280.0040.00416.58
7.4.270.0030.00316.54
7.4.260.0060.00316.52
7.4.250.0040.00416.58
7.4.240.0030.00316.45
7.4.230.0070.00016.40
7.4.220.0090.00916.69
7.4.210.0090.00616.52
7.4.200.0030.00316.56
7.4.160.0060.00916.39
7.4.150.0060.01217.40
7.4.140.0120.00617.86
7.4.130.0060.01016.52
7.4.120.0080.01316.49
7.4.110.0080.00816.31
7.4.100.0060.01116.48
7.4.90.0030.01316.70
7.4.80.0100.01019.39
7.4.70.0030.01316.58
7.4.60.0090.00616.44
7.4.50.0080.00016.27
7.4.40.0040.01216.57
7.4.30.0100.00616.46
7.4.10.0060.01114.93
7.4.00.0110.00514.95
7.3.330.0030.00313.05
7.3.320.0050.00313.18
7.3.310.0030.00516.13
7.3.300.0050.00216.34
7.3.290.0070.01016.30
7.3.280.0070.00916.27
7.3.270.0090.00917.40
7.3.260.0110.00616.48
7.3.250.0070.00916.43
7.3.240.0070.01616.53
7.3.230.0100.00716.39
7.3.210.0120.00616.22
7.3.200.0160.00619.39
7.3.190.0040.01416.25
7.3.180.0040.01216.54
7.3.170.0100.01316.52
7.3.160.0060.00916.54
7.3.130.0070.01114.78
7.3.120.0080.00714.67
7.3.110.0100.00914.66
7.3.100.0070.00614.81
7.3.90.0050.00714.89
7.3.80.0060.00414.89
7.3.70.0040.01014.83
7.3.60.0090.00414.69
7.3.50.0050.00714.75
7.3.40.0110.00214.81
7.3.30.0080.00714.87
7.3.20.0040.00816.69
7.3.10.0050.00616.55
7.3.00.0060.00716.42
7.2.330.0120.00616.36
7.2.320.0040.01116.55
7.2.310.0090.00916.57
7.2.300.0130.00316.53
7.2.290.0140.00316.29
7.2.260.0130.00514.90
7.2.250.0100.00915.04
7.2.240.0090.00615.00
7.2.230.0080.00714.80
7.2.220.0040.00914.91
7.2.210.0080.00614.95
7.2.200.0090.00714.76
7.2.190.0100.00614.93
7.2.180.0010.01314.85
7.2.170.0040.01014.80
7.2.160.0050.01114.90
7.2.150.0060.00816.73
7.2.140.0040.00816.75
7.2.130.0050.01216.77
7.2.120.0080.00716.83
7.2.110.0020.01216.63
7.2.100.0020.01016.67
7.2.90.0090.00716.68
7.2.80.0050.01016.79
7.2.70.0060.01116.66
7.2.60.0060.00916.75
7.2.50.0070.00816.79
7.2.40.0090.00916.84
7.2.30.0100.00716.67
7.2.20.0090.00516.66
7.2.10.0090.00516.70
7.2.00.0040.01016.82
7.1.330.0040.00915.68
7.1.320.0030.01015.74
7.1.310.0030.00915.45
7.1.300.0040.00815.52
7.1.290.0070.00815.63
7.1.280.0100.00615.68
7.1.270.0050.00715.52
7.1.260.0060.00815.49
7.1.250.0060.00615.52
7.1.240.0020.00915.45
7.1.230.0020.00915.47
7.1.220.0050.00515.66
7.1.210.0050.00915.64
7.1.200.0050.01015.64
7.1.190.0070.00915.60
7.1.180.0080.00715.59
7.1.170.0060.00715.47
7.1.160.0050.01015.69
7.1.150.0040.00915.43
7.1.140.0070.00815.59
7.1.130.0070.00615.60
7.1.120.0060.00815.63
7.1.110.0050.00715.68
7.1.100.0090.00415.69
7.1.90.0030.01115.49
7.1.80.0050.00715.68
7.1.70.0050.00715.92
7.1.60.0110.00616.62
7.1.50.0030.01115.93
7.1.40.0060.00715.48
7.1.30.0050.00815.51
7.1.20.0040.00815.63
7.1.10.0040.00515.63
7.1.00.0060.02317.44
7.0.330.0040.00615.20
7.0.320.0030.00815.18
7.0.310.0070.00815.18
7.0.300.0060.00415.12
7.0.290.0110.00315.26
7.0.280.0030.00915.21
7.0.270.0040.00715.34
7.0.260.0060.00615.41
7.0.250.0020.01115.05
7.0.240.0040.00915.31
7.0.230.0080.00815.37
7.0.220.0050.00715.33
7.0.210.0030.01015.38
7.0.200.0060.00715.22
7.0.190.0070.00715.33
7.0.180.0060.00415.16
7.0.170.0050.00615.25
7.0.160.0050.00815.27
7.0.150.0040.00715.21
7.0.140.0070.02317.06
7.0.130.0030.01015.28
7.0.120.0070.00515.38
7.0.110.0060.00715.24
7.0.100.0030.00715.22
7.0.90.0040.00715.34
7.0.80.0070.00815.25
7.0.70.0040.00915.24
7.0.60.0060.02516.42
7.0.50.0020.02515.87
7.0.40.0060.01614.96
7.0.30.0090.01914.94
7.0.20.0100.02615.02
7.0.10.0050.02015.02
7.0.00.0020.02515.03
5.6.400.0030.00914.17
5.6.390.0050.00514.12
5.6.380.0020.01114.20
5.6.370.0060.00914.11
5.6.360.0050.00914.05
5.6.350.0080.00914.03
5.6.340.0020.00914.02
5.6.330.0050.00714.15
5.6.320.0080.00614.23
5.6.310.0070.00614.46
5.6.300.0070.00814.04
5.6.290.0110.00614.08
5.6.280.0060.02215.97
5.6.270.0040.00914.18
5.6.260.0070.00514.00
5.6.250.0060.00814.11
5.6.240.0060.00814.03
5.6.230.0040.00814.17
5.6.220.0070.00614.10
5.6.210.0070.02615.73
5.6.200.0050.01515.11
5.6.190.0060.02615.82
5.6.180.0130.01715.69
5.6.170.0130.02115.74
5.6.160.0060.01715.69
5.6.150.0120.01814.98
5.6.140.0100.02215.18
5.6.130.0070.01615.05
5.6.120.0030.02415.98
5.6.110.0040.03115.78
5.6.100.0100.01915.89
5.6.90.0060.01515.88
5.6.80.0040.02715.63
5.6.70.0080.00814.06
5.6.60.0080.00614.09
5.6.50.0030.00814.09
5.6.40.0080.00714.13
5.6.30.0060.00714.06
5.6.20.0050.00914.21
5.6.10.0070.00414.10
5.6.00.0030.00614.06
5.5.380.0050.00614.15
5.5.370.0070.00514.10
5.5.360.0070.00713.91
5.5.350.0990.01815.53
5.5.340.0030.01815.19
5.5.330.0050.02015.55
5.5.320.0080.01615.65
5.5.310.0110.01915.49
5.5.300.0070.02615.05
5.5.290.0060.01715.06
5.5.280.0060.02815.81
5.5.270.0090.02315.81
5.5.260.0050.02815.57
5.5.250.0070.02215.72
5.5.240.0070.02515.59
5.5.230.0080.00914.04
5.5.220.0070.00714.05
5.5.210.0060.00613.94
5.5.200.0010.01514.17
5.5.190.0050.00714.03
5.5.180.0020.00913.94
5.5.170.0050.00813.88
5.5.160.0020.00914.05
5.5.150.0060.00513.86
5.5.140.0100.00413.99
5.5.130.0040.01013.91
5.5.120.0040.00914.01
5.5.110.0080.00713.85
5.5.100.0040.01114.13
5.5.90.0050.01014.06
5.5.80.0030.01014.09
5.5.70.0060.00814.00
5.5.60.0050.00813.99
5.5.50.0060.00713.99
5.5.40.0090.00213.98
5.5.30.0050.00813.67
5.5.20.0040.00813.98
5.5.10.0010.01414.02
5.5.00.0030.01014.05
5.4.450.0140.01712.91
5.4.440.0160.02013.04
5.4.430.0120.01712.95
5.4.420.0140.01712.95
5.4.410.0100.01312.85
5.4.400.0170.01712.89
5.4.390.0070.01712.77
5.4.380.0200.01912.55
5.4.370.0170.01612.59
5.4.360.0200.02112.72
5.4.350.0280.01912.75
5.4.340.0240.01312.64
5.4.330.0040.00510.65
5.4.320.0040.01411.17
5.4.310.0050.01511.17
5.4.300.0060.01411.17
5.4.290.0040.01311.07
5.4.280.0070.01211.13
5.4.270.0030.01911.09
5.4.260.0070.01211.10
5.4.250.0050.01711.08
5.4.240.0050.01311.10
5.4.230.0050.01511.08
5.4.220.0060.01311.04
5.4.210.0040.01411.24
5.4.200.0060.01411.12
5.4.190.0020.01511.07
5.4.180.0050.01211.11
5.4.170.0070.01211.16
5.4.160.0050.01411.16
5.4.150.0060.01511.23
5.4.140.0040.01511.09
5.4.130.0040.01511.10
5.4.120.0050.01211.11
5.4.110.0070.01210.99
5.4.100.0030.01511.16
5.4.90.0030.01611.00
5.4.80.0050.01311.10
5.4.70.0060.01611.03
5.4.60.0040.01211.02
5.4.50.0040.01510.94
5.4.40.0060.01410.89
5.4.30.0040.01510.97
5.4.20.0040.01311.02
5.4.10.0050.01311.04
5.4.00.0070.01110.85
5.3.290.0040.04012.80
5.3.280.0060.03812.71
5.3.270.0070.04612.72
5.3.260.0060.04912.72
5.3.250.0060.03612.72
5.3.240.0110.03112.71
5.3.230.0060.03712.71
5.3.220.0040.03812.68
5.3.210.0030.04112.68
5.3.200.0030.03912.68
5.3.190.0060.03612.67
5.3.180.0060.03512.67
5.3.170.0070.03412.66
5.3.160.0060.03512.67
5.3.150.0080.03412.68
5.3.140.0070.03812.66
5.3.130.0050.03812.66
5.3.120.0050.04012.66
5.3.110.0070.03812.66
5.3.100.0060.03612.12
5.3.90.0050.03712.09
5.3.80.0120.02912.07
5.3.70.0070.03512.08
5.3.60.0090.03312.07
5.3.50.0060.03612.01
5.3.40.0020.04012.01
5.3.30.0040.03711.97
5.3.20.0030.03911.75
5.3.10.0070.03411.71
5.3.00.0080.03511.70
5.2.170.0030.0349.21
5.2.160.0080.0269.21
5.2.150.0060.0299.21
5.2.140.0030.0319.21
5.2.130.0070.0269.17
5.2.120.0060.0279.17
5.2.110.0040.0309.17
5.2.100.0070.0269.16
5.2.90.0080.0269.17
5.2.80.0090.0269.16
5.2.70.0050.0309.16
5.2.60.0070.0279.11
5.2.50.0040.0309.08
5.2.40.0060.0279.06
5.2.30.0100.0289.04
5.2.20.0060.0279.03
5.2.10.0050.0278.95
5.2.00.0040.0328.81
5.1.60.0030.0258.09
5.1.50.0070.0228.09
5.1.40.0040.0258.07
5.1.30.0030.0278.42
5.1.20.0020.0298.45
5.1.10.0060.0238.17
5.1.00.0080.0228.16
5.0.50.0040.0206.65
5.0.40.0030.0206.51
5.0.30.0040.0306.32
5.0.20.0040.0186.29
5.0.10.0040.0196.27
5.0.00.0030.0316.26
4.4.90.0010.0174.78
4.4.80.0020.0164.75
4.4.70.0010.0174.76
4.4.60.0030.0154.75
4.4.50.0090.0094.77
4.4.40.0030.0244.71
4.4.30.0020.0164.76
4.4.20.0040.0154.85
4.4.10.0040.0154.85
4.4.00.0030.0254.75
4.3.110.0030.0154.66
4.3.100.0040.0134.67
4.3.90.0020.0154.63
4.3.80.0050.0254.58
4.3.70.0020.0164.63
4.3.60.0020.0154.63
4.3.50.0040.0144.63
4.3.40.0050.0224.54
4.3.30.0010.0163.31
4.3.20.0050.0133.29
4.3.10.0030.0143.24
4.3.00.0270.01313.43

preferences:
52.55 ms | 401 KiB | 5 Q