3v4l.org

run code in 300+ PHP versions simultaneously
<?php error_reporting(E_ALL); $db = new PDO("sqlite::memory:"); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $queries = array( "CREATE TABLE users ( userid INT PRIMARY KEY, name TEXT, country TEXT, referred_by_userid INT )", "INSERT INTO users (userid, name, country, referred_by_userid) VALUES (104, 'Chris', 'Ukraine', NULL)", "INSERT INTO users (userid, name, country, referred_by_userid) VALUES (105, 'Jamie', 'England', NULL)", "INSERT INTO users (userid, name, country, referred_by_userid) VALUES (107, 'Robin', 'Germany', 104)", "INSERT INTO users (userid, name, country, referred_by_userid) VALUES (108, 'Sean', 'Ukraine', NULL)", "INSERT INTO users (userid, name, country, referred_by_userid) VALUES (109, 'Toni', 'Germany', NULL)", "INSERT INTO users (userid, name, country, referred_by_userid) VALUES (110, 'Toni', 'Germany', NULL)", "INSERT INTO users (userid, name, country, referred_by_userid) VALUES (111, 'Sean', 'France', NULL)", ); foreach ($queries as $query) { $db->exec($query); } $query = "SELECT userid, name, country, referred_by_userid FROM users"; $fetchMode = PDO::FETCH_COLUMN | PDO::FETCH_GROUP; print "\nfetchAll (no column specified):\n"; $stmt = $db->query($query); $result = $stmt->fetchAll($fetchMode); print_r($result); print "\nfetchAll (col 2):\n"; $stmt = $db->query($query); $result = $stmt->fetchAll($fetchMode, 2); print_r($result); $query = "SELECT country, name, userid FROM users"; print "\nfetchAll (by country, no column specified):\n"; # Values are column 1, group is column 0 $stmt = $db->query($query); $result = $stmt->fetchAll($fetchMode); print_r($result); print "\nfetchAll (by country, col 0):\n"; # Values are column 0, group is column 0 $stmt = $db->query($query); $result = $stmt->fetchAll($fetchMode, 0); print_r($result); print "\nfetchAll (by country, col 1):\n"; # Values are column 0, group is column 0 $stmt = $db->query($query); $result = $stmt->fetchAll($fetchMode, 1); print_r($result); print "\nfetchAll (by country, col 2):\n"; # Values are column 0, group is column 1 $stmt = $db->query($query); $result = $stmt->fetchAll($fetchMode, 2); print_r($result);

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.130.0360.01118.27
8.4.120.0430.00418.65
8.4.110.0330.01518.57
8.4.100.0360.01218.57
8.4.90.0380.01318.60
8.4.80.0380.01418.43
8.4.70.0400.01318.36
8.4.60.0390.01318.59
8.4.50.0420.00818.64
8.4.40.0510.01018.21
8.4.30.0400.01118.18
8.4.20.0420.00918.28
8.4.10.0420.00818.38
8.3.260.0360.01017.41
8.3.250.0380.00917.35
8.3.240.0320.01217.25
8.3.230.0380.00817.08
8.3.220.0370.00917.23
8.3.210.0380.00717.46
8.3.200.0380.00817.02
8.3.190.0350.01117.36
8.3.180.0360.01017.19
8.3.170.0380.01017.04
8.3.160.0350.01317.25
8.3.150.0360.01217.32
8.3.140.0340.01417.30
8.3.130.0360.00917.42
8.3.120.0340.01317.13
8.3.110.0380.01417.19
8.3.100.0420.01017.16
8.3.90.0390.00817.16
8.3.80.0400.00817.25
8.3.70.0370.01217.44
8.3.60.0440.00617.40
8.3.50.0490.00817.37
8.3.40.0390.00918.16
8.3.30.0370.00518.39
8.3.20.0330.01018.33
8.3.10.0270.01318.30
8.3.00.0320.01018.48
8.2.290.0300.01017.25
8.2.280.0270.01217.61
8.2.270.0330.00717.36
8.2.260.0330.00917.39
8.2.250.0330.00817.09
8.2.240.0300.01117.54
8.2.230.0360.00717.50
8.2.220.0360.01017.13
8.2.210.0320.01017.32
8.2.200.0330.00717.25
8.2.190.0300.01017.13
8.2.180.0320.00817.33
8.2.170.0370.01018.47
8.2.160.0360.00818.22
8.2.150.0370.01118.24
8.2.140.0360.01017.97
8.2.130.0330.01317.98
8.2.120.0340.01018.26
8.2.110.0370.01118.05
8.2.100.0350.00618.38
8.2.90.0330.01018.25
8.2.80.0340.00818.16
8.2.70.0330.01217.80
8.2.60.0490.00818.03
8.2.50.0370.01018.21
8.2.40.0320.01218.35
8.2.30.0360.00718.27
8.2.20.0450.00718.13
8.2.10.0290.01018.09
8.2.00.0330.00718.35
8.1.330.0280.01216.89
8.1.320.0300.00916.86
8.1.310.0320.01016.98
8.1.300.0320.00917.00
8.1.290.0340.00716.69
8.1.280.0330.00716.50
8.1.270.0320.00818.15
8.1.260.0300.00918.00
8.1.250.0300.01218.09
8.1.240.0330.00718.07
8.1.230.0300.00917.98
8.1.220.0250.01518.33
8.1.210.0290.01118.09
8.1.200.0300.00818.08
8.1.190.0290.00917.82
8.1.180.0290.00818.07
8.1.170.0260.01218.29
8.1.160.0300.01118.03
8.1.150.0300.00918.11
8.1.140.0280.01018.27
8.1.130.0300.00818.09
8.1.120.0300.00917.99
8.1.110.0310.00717.99
8.1.100.0360.00618.27
8.1.90.0370.00918.11
8.1.80.0350.01018.31
8.1.70.0350.00818.30
8.1.60.0340.00718.20
8.1.50.0310.01018.00
8.1.40.0340.00618.23
8.1.30.0290.01118.23
8.1.20.0350.00718.16
8.1.10.0340.00818.41
8.1.00.0300.01018.16
8.0.300.0280.01017.63
8.0.290.0270.01117.54
8.0.280.0300.00817.32
8.0.270.0310.00817.51
8.0.260.0270.01217.23
8.0.250.0290.01117.38
8.0.240.0310.01017.34
8.0.230.0360.00617.63
8.0.220.0280.00917.42
8.0.210.0280.01117.43
8.0.200.0280.01017.45
8.0.190.0310.00717.28
8.0.180.0340.00717.52
8.0.170.0330.01317.63
8.0.160.0320.00717.25
8.0.150.0270.01117.54
8.0.140.0310.00717.32
8.0.130.0340.00617.44
8.0.120.0330.00717.37
8.0.110.0340.01117.23
8.0.100.0330.01117.11
8.0.90.0360.01117.29
8.0.80.0340.00917.34
8.0.70.0350.00917.29
8.0.60.0310.00717.39
8.0.50.0310.00917.48
8.0.30.0340.00817.49
8.0.20.0250.01417.54
8.0.10.0270.01217.26
8.0.00.0310.01117.71
7.4.330.0260.01116.91
7.4.320.0270.00717.28
7.4.300.0250.01117.24
7.4.290.0310.00617.15
7.4.280.0320.00617.25
7.4.270.0250.01017.25
7.4.260.0270.00816.93
7.4.250.0210.01516.87
7.4.240.0300.00516.95
7.4.230.0320.00516.92
7.4.220.0300.00616.97
7.4.210.0310.00616.94
7.4.200.0280.00717.07
7.4.190.0290.00817.24
7.4.180.0240.01117.32
7.4.160.0310.00717.38
7.4.150.0320.00717.03
7.4.140.0280.00716.92
7.4.130.0260.00816.94
7.4.120.0270.00716.97
7.4.110.0250.01016.88
7.4.100.0240.01117.19
7.4.90.0320.00317.11
7.4.80.0300.00617.10
7.4.70.0350.00816.86
7.4.60.0380.00917.05
7.4.50.0220.01217.00
7.4.40.0250.01017.07
7.4.30.0330.00816.70
7.4.20.0280.00916.94
7.4.10.0280.01117.00
7.4.00.0260.01016.92
7.3.330.0310.00816.91
7.3.320.0230.01117.20
7.3.310.0260.00816.86
7.3.300.0250.00916.67
7.3.290.0290.00417.07
7.3.280.0270.00716.98
7.3.270.0260.00917.01
7.3.260.0260.00916.94
7.3.250.0270.00717.02
7.3.240.0280.00616.91
7.3.230.0270.00816.82
7.3.220.0300.00916.89
7.3.210.0310.00517.01
7.3.200.0280.00716.70
7.3.190.0290.01217.01
7.3.180.0290.00817.15
7.3.170.0290.00616.83
7.3.160.0290.00716.91
7.3.150.0270.00816.93
7.3.140.0260.01017.09
7.3.130.0250.01016.65
7.3.120.0290.00516.90
7.3.110.0260.00817.03
7.3.100.0290.00516.95
7.3.90.0310.00717.05
7.3.80.0480.00816.81
7.3.70.0390.00816.55
7.3.60.0310.00816.73
7.3.50.0250.01017.08
7.3.40.0340.01017.00
7.3.30.0350.00916.70
7.3.20.0320.00816.97
7.3.10.0310.00616.95
7.3.00.0290.00816.82
7.2.340.0260.00816.88
7.2.330.0270.00817.00
7.2.320.0300.00517.15
7.2.310.0280.00716.99
7.2.300.0290.00517.21
7.2.290.0300.00517.11
7.2.280.0280.01017.03
7.2.270.0280.00916.96
7.2.260.0280.00716.73
7.2.250.0280.00916.98
7.2.240.0300.00417.11
7.2.230.0280.00817.04
7.2.220.0300.00616.92
7.2.210.0270.00816.91
7.2.200.0330.00617.07
7.2.190.0250.00917.06
7.2.180.0220.01316.96
7.2.170.0280.00817.32
7.2.160.0260.01217.04
7.2.150.0490.00917.20
7.2.140.0320.00517.17
7.2.130.0290.00717.34
7.2.120.0290.00817.11
7.2.110.0360.00617.17
7.2.100.0340.01117.34
7.2.90.0400.00817.02
7.2.80.0300.01017.32
7.2.70.0300.00717.30
7.2.60.0290.00817.38
7.2.50.0340.00317.37
7.2.40.0330.00717.09
7.2.30.0340.00417.40
7.2.20.0280.01017.08
7.2.10.0240.01217.14
7.2.00.0270.00917.40
7.1.330.0260.01116.14
7.1.320.0310.00516.13
7.1.310.0310.00715.83
7.1.300.0270.00815.98
7.1.290.0260.00815.98
7.1.280.0230.01115.85
7.1.270.0830.00416.21
7.1.260.0210.00715.98
7.1.250.0210.00515.81
7.1.240.0220.00716.04
7.1.230.0270.00615.96
7.1.220.0220.01215.88
7.1.210.0280.00716.26
7.1.200.0260.01216.02
7.1.190.0250.01216.11
7.1.180.0280.00816.01
7.1.170.0270.00715.98
7.1.160.0240.01215.80
7.1.150.0290.00515.76
7.1.140.0270.00816.00
7.1.130.0250.00815.89
7.1.120.0270.00616.13
7.1.110.0280.00615.93
7.1.100.0280.00715.89
7.1.90.0280.00715.72
7.1.80.0320.00815.94
7.1.70.0290.01015.76
7.1.60.0330.00715.93
7.1.50.0950.00515.95
7.1.40.0180.00715.70
7.1.30.0270.00815.98
7.1.20.0290.00715.61
7.1.10.0320.00715.95
7.1.00.0270.00615.78
7.0.330.0260.01015.77
7.0.320.0270.00815.57
7.0.310.0270.00915.52
7.0.300.0250.01115.60
7.0.290.0250.01015.59
7.0.280.0310.00615.69
7.0.270.0300.00815.58
7.0.260.0330.00715.63
7.0.250.0280.00815.93
7.0.240.0280.00716.07
7.0.230.0300.00715.95
7.0.220.0290.00715.76
7.0.210.0300.00715.73
7.0.200.0270.01015.63
7.0.190.0270.00915.86
7.0.180.0310.00815.78
7.0.170.0580.01315.66
7.0.160.0280.00815.89
7.0.150.0310.00615.93
7.0.140.0330.00515.77
7.0.130.0280.00915.79
7.0.120.0300.00815.88
7.0.110.0310.00815.49
7.0.100.0290.00615.73
7.0.90.0290.00715.61
7.0.80.0290.00715.41
7.0.70.0290.00915.35
7.0.60.0290.00815.77
7.0.50.0380.00815.48
7.0.40.0430.01015.57
7.0.30.0330.01115.70
7.0.20.0400.00415.65
7.0.10.0360.00915.88
7.0.00.0310.01115.61
5.6.400.0290.01216.14
5.6.390.0340.00616.37
5.6.380.0370.01016.22
5.6.370.0270.01416.12
5.6.360.0350.00516.05
5.6.350.0300.00916.41
5.6.340.0300.00916.04
5.6.330.0250.01116.06
5.6.320.0370.00616.16
5.6.310.0300.00916.33
5.6.300.0330.00916.13
5.6.290.0380.01016.39
5.6.280.0380.01216.11
5.6.270.0370.01216.10
5.6.260.0360.00916.20
5.6.250.0330.00916.27
5.6.240.0300.01116.26
5.6.230.0290.00916.18
5.6.220.0340.00716.21
5.6.210.0350.00916.16
5.6.200.0260.01316.38
5.6.190.0310.01116.48
5.6.180.0320.01016.11
5.6.170.0280.01216.19
5.6.160.0270.01216.55
5.6.150.0310.01216.11
5.6.140.0360.00916.20
5.6.130.0330.00916.31
5.6.120.0280.01216.13
5.6.110.0300.00916.10
5.6.100.0410.01416.20
5.6.90.0280.01116.14
5.6.80.0260.01216.02
5.6.70.0320.00916.30
5.6.60.0320.00916.14
5.6.50.0370.00816.24
5.6.40.0320.00916.34
5.6.30.0340.01116.34
5.6.20.0320.00816.07
5.6.10.0240.01515.83
5.6.00.0290.01116.10
5.5.380.0280.01116.13
5.5.370.0300.00916.46
5.5.360.0280.00816.21
5.5.350.0350.00516.20
5.5.340.0300.01116.14
5.5.330.0290.00916.02
5.5.320.0240.01516.02
5.5.310.0280.01116.15
5.5.300.0420.00816.09
5.5.290.0350.00715.99
5.5.280.0260.01116.14
5.5.270.0280.01315.93
5.5.260.0330.00616.04
5.5.250.0280.01115.92
5.5.240.0310.00716.07
5.5.230.0290.00716.09
5.5.220.0360.00715.92
5.5.210.0280.01116.32
5.5.200.0280.01016.16
5.5.190.0330.01216.27
5.5.180.0240.00916.03
5.5.170.0260.01616.01
5.5.160.0300.01116.17
5.5.150.0280.01316.04
5.5.140.0300.00615.79
5.5.130.0300.00915.89
5.5.120.0300.01015.78
5.5.110.0260.01515.61
5.5.100.0320.00716.04
5.5.90.0290.00716.04
5.5.80.0280.00915.89
5.5.70.0320.00916.21
5.5.60.0290.01016.04
5.5.50.0330.01115.95
5.5.40.0240.01116.26
5.5.30.0310.00916.09
5.5.20.0320.00915.98
5.5.10.0250.00816.10
5.5.00.0230.00816.16
5.4.450.0220.00614.24
5.4.440.0230.00614.24
5.4.430.0270.00214.24
5.4.420.0230.00514.24
5.4.410.0200.00614.24
5.4.400.0240.00414.24
5.4.390.0220.00514.24
5.4.380.0230.00414.24
5.4.370.0240.00514.24
5.4.360.0220.00614.24
5.4.350.0220.00714.24
5.4.340.0220.00714.24
5.4.330.0240.00614.24
5.4.320.0230.00614.24
5.4.310.0280.00614.24
5.4.300.0250.01114.24
5.4.290.0240.00414.24
5.4.280.0260.00314.24
5.4.270.0210.00714.24
5.4.260.0220.00714.24
5.4.250.0260.00914.24
5.4.240.0230.00414.24
5.4.230.0210.00614.24
5.4.220.0220.00714.24
5.4.210.0260.00214.24
5.4.200.0180.00914.24
5.4.190.0220.00414.24
5.4.180.0200.00614.24
5.4.170.0250.00314.24
5.4.160.0210.00714.24
5.4.150.0210.00614.24
5.4.140.0200.00914.24
5.4.130.0240.00514.24
5.4.120.0210.00914.24
5.4.110.0240.01114.24
5.4.100.0200.00714.24
5.4.90.0200.00814.24
5.4.80.0230.00814.24
5.4.70.0220.00814.24
5.4.60.0230.00614.24
5.4.50.0220.00614.24
5.4.40.0220.00614.24
5.4.30.0180.00814.24
5.4.20.0260.00614.24
5.4.10.0240.00614.24
5.4.00.0240.00314.24
5.3.290.0220.00514.24
5.3.280.0210.00714.24
5.3.270.0180.00814.24
5.3.260.0200.00714.24
5.3.250.0230.00414.24
5.3.240.0200.00814.24
5.3.230.0190.00914.24
5.3.220.0190.00814.24
5.3.210.0260.00314.24
5.3.200.0220.00914.24
5.3.190.0230.00614.24
5.3.180.0230.00414.24
5.3.170.0320.00714.24
5.3.160.0180.00914.24
5.3.150.0220.00514.24
5.3.140.0210.00614.24
5.3.130.0190.00914.24
5.3.120.0250.00814.24
5.3.110.0240.00614.24
5.3.100.0160.01014.24
5.3.90.0210.00514.24
5.3.80.0190.00814.24
5.3.70.0210.00614.24
5.3.60.0200.00614.24
5.3.50.0200.00614.24
5.3.40.0200.00914.24
5.3.30.0170.00814.24
5.3.20.0220.00314.24
5.3.10.0170.00914.24
5.3.00.0190.01014.24
5.2.170.0150.00714.24
5.2.160.0150.00814.24
5.2.150.0170.00614.24
5.2.140.0150.00614.24
5.2.130.0200.00314.24
5.2.120.0190.00514.24
5.2.110.0290.00614.24
5.2.100.0150.00814.24
5.2.90.0180.00614.24
5.2.80.0160.01014.24
5.2.70.0170.00714.24
5.2.60.0160.00714.24
5.2.50.0180.00614.24
5.2.40.0210.00714.24
5.2.30.0200.00514.24
5.2.20.0140.00814.24
5.2.10.0180.00514.24
5.2.00.0160.00514.24
5.1.60.0120.00414.24
5.1.50.0120.00414.24
5.1.40.0140.00314.24
5.1.30.0150.00614.24
5.1.20.0140.00714.24
5.1.10.0150.00414.24
5.1.00.0130.00714.24
5.0.50.0100.00414.24
5.0.40.0100.00514.24
5.0.30.0120.00214.24
5.0.20.0100.00414.24
5.0.10.0090.00514.24
5.0.00.0110.00314.24
4.4.90.0060.00214.24
4.4.80.0070.00214.24
4.4.70.0060.00314.24
4.4.60.0070.00214.24
4.4.50.0080.00114.24
4.4.40.0060.00214.24
4.4.30.0090.00014.24
4.4.20.0070.00114.24
4.4.10.0060.00314.24
4.4.00.0080.00114.24
4.3.110.0080.00114.24
4.3.100.0030.00114.24
4.3.90.0060.00114.24
4.3.80.0070.00114.24
4.3.70.0070.00114.24
4.3.60.0090.00014.24
4.3.50.0080.00114.24
4.3.40.0040.00314.24
4.3.30.0040.00214.24
4.3.20.0060.00114.24
4.3.10.0050.00214.24
4.3.00.0060.00114.24

preferences:
33.31 ms | 403 KiB | 5 Q