3v4l.org

run code in 300+ PHP versions simultaneously
<?php function buildQuery($retrievables, $table, $limit = 0, $conditions = "", $orderCondition = "", $orderDirection = "") { $query = "SELECT $retrievables FROM $table"; // if we have conditions - add them to the query $query .= ($conditions != "" ? " WHERE " . $conditions : ""); // if we have a limit - add it to the query $query .= ($limit != 0 ? " LIMIT " . $limit : ""); // if we have to order the results - add it to the query $query .= ($orderCondition != "" ? " ORDER BY " . $orderCondition . " " . $orderDirection : ""); // first we create a "dictionary" which translates $niceValues that are used throughout the code // to $realValues which are used in the MySQL database // since the $realValues are different in every table - we must account to that switch ($table) { case 'usersTable': $niceValues = array("userID", "userName", "userAge", "userLocation", "userSex", "userIntention", "usersTable"); $realValues = array("uid", "uname", "user_bdate", "user_from", "name", "user_intrest", "nuke_users"); // yeah - the field "name" is really the sex of the user break; case 'articlesTable': $niceValues = array("articleID", "articleTitle", "articleLead", "articleBody", "articlesTable"); $realValues = array("sid", "title", "hometext", "bodytext", "nuke_stories"); break; default: $realValues = array(); } // we then replace $niceValues with $realValues $modifiedQuery = str_ireplace($niceValues, $realValues, $query); return $modifiedQuery; } print_r(buildQuery($retrievables, "usersTable", "", "uid=$userID")); ?>

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.0170.00316.50
8.3.50.0170.00622.10
8.3.40.0140.00418.79
8.3.30.0090.00919.12
8.3.20.0040.00420.15
8.3.10.0080.00023.66
8.3.00.0080.00022.52
8.2.180.0100.01016.63
8.2.170.0110.00422.96
8.2.160.0070.00721.98
8.2.150.0040.00424.18
8.2.140.0030.00624.66
8.2.130.0070.00026.16
8.2.120.0000.00722.12
8.2.110.0060.00322.29
8.2.100.0040.00817.97
8.2.90.0000.00819.17
8.2.80.0000.00818.05
8.2.70.0080.00017.63
8.2.60.0030.00918.05
8.2.50.0060.00318.07
8.2.40.0040.00418.16
8.2.30.0040.00418.06
8.2.20.0040.00417.91
8.2.10.0060.00319.59
8.2.00.0000.00817.70
8.1.280.0150.00025.92
8.1.270.0000.00824.01
8.1.260.0040.00426.35
8.1.250.0000.00728.09
8.1.240.0060.00323.91
8.1.230.0070.00419.10
8.1.220.0040.00417.78
8.1.210.0040.00418.77
8.1.200.0000.01117.35
8.1.190.0040.00417.50
8.1.180.0000.00918.10
8.1.170.0050.00318.59
8.1.160.0080.00322.04
8.1.150.0030.00518.57
8.1.140.0000.00717.48
8.1.130.0030.00519.24
8.1.120.0040.00417.46
8.1.110.0040.00417.51
8.1.100.0050.00317.50
8.1.90.0080.00417.49
8.1.80.0030.00517.47
8.1.70.0000.00717.45
8.1.60.0040.00417.57
8.1.50.0030.00617.44
8.1.40.0050.00317.58
8.1.30.0030.00517.52
8.1.20.0040.00417.62
8.1.10.0030.00517.53
8.1.00.0030.00517.46
8.0.300.0030.00618.77
8.0.290.0070.00017.17
8.0.280.0030.00318.48
8.0.270.0000.00917.30
8.0.260.0030.00316.95
8.0.250.0030.00317.08
8.0.240.0040.00416.93
8.0.230.0030.00316.92
8.0.220.0000.00716.88
8.0.210.0040.00416.89
8.0.200.0000.00716.91
8.0.190.0070.00017.11
8.0.180.0040.00416.89
8.0.170.0000.00817.06
8.0.160.0040.00416.96
8.0.150.0060.00316.96
8.0.140.0030.00316.91
8.0.130.0000.00613.42
8.0.120.0050.00216.96
8.0.110.0000.00716.87
8.0.100.0050.00317.02
8.0.90.0000.00716.99
8.0.80.0060.00916.97
8.0.70.0050.00316.98
8.0.60.0030.00516.98
8.0.50.0070.00016.79
8.0.30.0130.00917.06
8.0.20.0120.00917.40
8.0.10.0050.00217.07
8.0.00.0080.01316.98
7.4.330.0060.00015.00
7.4.320.0070.00016.46
7.4.300.0030.00316.63
7.4.290.0060.00016.52
7.4.280.0000.00816.63
7.4.270.0030.00616.52
7.4.260.0030.00316.63
7.4.250.0040.00416.51
7.4.240.0060.00216.60
7.4.230.0040.00416.63
7.4.220.0070.01016.67
7.4.210.0070.00916.54
7.4.200.0070.00016.74
7.4.190.0050.00316.79
7.4.160.0040.01116.59
7.4.150.0080.01117.40
7.4.140.0080.00917.86
7.4.130.0090.00816.56
7.4.120.0040.01616.55
7.4.110.0110.00616.57
7.4.100.0060.01116.71
7.4.90.0120.00916.62
7.4.80.0060.01119.39
7.4.70.0140.00316.48
7.4.60.0070.01016.35
7.4.50.0000.00916.50
7.4.40.0070.00722.77
7.4.30.0060.00916.61
7.4.00.0000.01414.83
7.3.330.0030.00613.36
7.3.320.0050.00013.43
7.3.310.0030.00316.28
7.3.300.0040.00416.47
7.3.290.0030.01216.47
7.3.280.0110.00816.40
7.3.270.0110.00917.40
7.3.260.0070.01516.37
7.3.250.0140.00916.54
7.3.240.0160.00016.38
7.3.230.0140.00416.62
7.3.210.0170.00016.47
7.3.200.0030.01419.39
7.3.190.0090.00916.43
7.3.180.0100.00716.39
7.3.170.0040.01216.43
7.3.160.0090.00616.38
7.3.120.0030.01214.93
7.2.330.0080.00816.81
7.2.320.0070.01016.62
7.2.310.0060.01016.62
7.2.300.0030.01316.81
7.2.290.0060.01516.74
7.2.00.0030.01019.43
7.1.100.0030.00918.00
7.1.70.0020.00517.18
7.1.60.0040.01919.29
7.1.50.0160.01616.61
7.1.00.0000.04722.45
7.0.200.0080.00316.92
7.0.140.0000.07722.08
7.0.80.0600.07720.00
7.0.70.0570.07720.05
7.0.60.0470.06019.99
7.0.50.0600.07720.35
7.0.40.0030.08720.09
7.0.30.0070.08320.13
7.0.20.0100.06020.14
7.0.10.0030.08320.18
7.0.00.0030.08320.07
5.6.280.0070.07320.91
5.6.230.0130.08020.67
5.6.220.0130.07320.57
5.6.210.0230.06020.49
5.6.200.0100.08321.05
5.6.190.0130.07020.96
5.6.180.0070.07721.05
5.6.170.0100.08021.10
5.6.160.0100.08321.08
5.6.150.0100.08021.11
5.6.140.0100.08021.09
5.6.130.0170.07721.06
5.6.120.0200.07321.09
5.6.110.0100.07721.09
5.6.100.0030.08321.09
5.6.90.0070.08321.17
5.6.80.0070.07320.48
5.6.70.0070.07720.47
5.6.60.0100.07320.43
5.6.50.0070.06020.51
5.6.40.0170.06320.47
5.6.30.0070.04320.33
5.6.20.0130.08020.40
5.6.10.0100.07020.45
5.6.00.0230.05020.37
5.5.370.0000.09320.46
5.5.360.0130.07320.57
5.5.350.0070.06020.43
5.5.340.0100.08320.82
5.5.330.0130.07720.81
5.5.320.0130.07020.94
5.5.310.0100.08020.81
5.5.300.0070.04320.66
5.5.290.0030.08320.65
5.5.280.0030.04320.92
5.5.270.0030.06720.93
5.5.260.0170.07720.76
5.5.250.0000.08720.65
5.5.240.0170.07020.26
5.5.230.0130.05020.16
5.5.220.0000.07720.19
5.5.210.0070.06020.26
5.5.200.0030.05720.16
5.5.190.0000.08020.27
5.5.180.0000.07320.14
5.5.160.0030.07320.22
5.5.150.0100.08320.13
5.5.140.0070.07320.19
5.5.130.0070.08020.24
5.5.120.0100.07320.25
5.5.110.0100.06720.23
5.5.100.0030.05020.18
5.5.90.0100.07020.02
5.5.80.0070.07319.99
5.5.70.0070.07720.17
5.5.60.0300.06020.09
5.5.50.0130.03020.11
5.5.40.0100.06019.95
5.5.30.0070.06020.08
5.5.20.0130.04319.94
5.5.10.0100.07020.03
5.5.00.0100.07320.04
5.4.450.0070.07719.51
5.4.440.0170.07319.42
5.4.430.0170.07019.55
5.4.420.0030.08019.35
5.4.410.0030.08319.23
5.4.400.0070.08018.88
5.4.390.0100.06318.88
5.4.380.0130.07018.85
5.4.370.0030.04718.88
5.4.360.0030.08019.18
5.4.350.0070.05019.04
5.4.340.0030.04718.91
5.4.320.0170.07018.88
5.4.310.0100.06719.18
5.4.300.0130.07018.90
5.4.290.0130.07718.87
5.4.280.0130.06719.04
5.4.270.0130.07719.12
5.4.260.0130.05719.02
5.4.250.0300.06019.09
5.4.240.0000.04719.12
5.4.230.0100.07319.17
5.4.220.0100.08019.12
5.4.210.0000.06719.20
5.4.200.0030.08718.94
5.4.190.0070.07719.02
5.4.180.0130.06719.14
5.4.170.0100.07319.12
5.4.160.0130.06719.13
5.4.150.0070.08318.83
5.4.140.0100.07316.25
5.4.130.0030.06016.45
5.4.120.0130.06316.49
5.4.110.0030.05316.39
5.4.100.0170.07016.40
5.4.90.0100.06316.47
5.4.80.0100.06316.53
5.4.70.0000.06016.37
5.4.60.0070.07316.37
5.4.50.0100.06716.41
5.4.40.0030.05016.53
5.4.30.0030.04316.48
5.4.20.0030.07016.48
5.4.10.0030.06716.33
5.4.00.0130.06715.87
5.3.290.0030.08014.77
5.3.280.0030.07714.54
5.3.270.0130.04314.57
5.3.260.0100.07314.65
5.3.250.0100.07714.63
5.3.240.0100.08014.57
5.3.230.0100.07014.57
5.3.220.0100.07714.72
5.3.210.0070.08014.57
5.3.200.0030.07714.52
5.3.190.0070.07014.65
5.3.180.0070.07314.72
5.3.170.0070.08014.72
5.3.160.0000.05014.70
5.3.150.0100.06714.54
5.3.140.0070.07014.53
5.3.130.0170.03714.52
5.3.120.0000.08314.68
5.3.110.0070.07714.71
5.3.100.0030.07314.07
5.3.90.0030.07014.17
5.3.80.0130.07014.05
5.3.70.0100.07314.08
5.3.60.0100.07014.02
5.3.50.0030.07714.10
5.3.40.0100.07314.05
5.3.30.0000.08014.06
5.3.20.0070.05013.82
5.3.10.0070.06713.73
5.3.00.0000.06713.79
5.2.170.0030.06711.64
5.2.160.0000.06711.64
5.2.150.0030.07011.64
5.2.140.0100.05011.64
5.2.130.0070.06011.64
5.2.120.0100.05711.64
5.2.110.0000.05311.64
5.2.100.0130.05311.64
5.2.90.0030.06311.64
5.2.80.0070.06311.64
5.2.70.0030.05711.64
5.2.60.0030.04311.64
5.2.50.0030.06011.64
5.2.40.0070.06311.64
5.2.30.0030.06311.64
5.2.20.0030.05711.64
5.2.10.0030.06311.64
5.2.00.0070.06011.64
5.1.60.0070.05311.64
5.1.50.0130.04311.64
5.1.40.0070.04711.64
5.1.30.0030.05711.64
5.1.20.0100.04311.64
5.1.10.0030.05711.64
5.1.00.0030.05311.64
5.0.50.0030.04311.64
5.0.40.0030.04011.64
5.0.30.0070.05011.64
5.0.20.0070.03011.64
5.0.10.0030.04011.64
5.0.00.0070.06011.64
4.4.90.0070.01711.64
4.4.80.0000.04011.64
4.4.70.0000.04011.64
4.4.60.0030.03711.64
4.4.50.0070.03011.64
4.4.40.0000.05011.64
4.4.30.0000.04011.64
4.4.20.0000.03711.64
4.4.10.0030.03311.64
4.4.00.0000.06011.64
4.3.110.0000.04011.64
4.3.100.0000.02711.64
4.3.90.0070.02311.64
4.3.80.0000.05711.64
4.3.70.0100.02011.64
4.3.60.0000.03311.64
4.3.50.0000.03711.64
4.3.40.0000.04711.64
4.3.30.0000.03311.64
4.3.20.0000.03711.64
4.3.10.0030.03311.64
4.3.00.0000.03311.64

preferences:
42.26 ms | 401 KiB | 5 Q