3v4l.org

run code in 300+ PHP versions simultaneously
<?php function checkParameters(string $sql) { $countNamed = 0; $countUnnamed = 0; $inQuote = false; for ($i = 0; $i < strlen($sql); ++ $i) { if ($inQuote) { if ($sql[$i] == $quote) { $inQuote = false; continue; } } else { if (in_array($sql[$i], ['"', "'"])) { $quote = $sql[$i]; continue; } } if ($sql[$i] == ':') { $countUnnamed ++; } elseif ($sql[$i] == '?') { $countNamed ++; } } if ($countNamed && $countUnnamed) { throw new Exception("mixed parms in: $sql" . PHP_EOL); } } $sql = "SELECT a, b FROM someTable WHERE a = '?' AND b = :id"; // checkParameters($sql); $sql = "SELECT a, b FROM someTable WHERE a = ? AND b = :id"; // checkParameters($sql); $sql = "SELECT a, b FROM someTable WHERE a = '?' AND b = :id"; checkParameters($sql);

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.54
8.3.30.0040.01118.67
8.3.20.0080.00020.90
8.3.10.0040.00421.94
8.3.00.0060.00321.68
8.2.170.0140.00322.96
8.2.160.0110.00419.25
8.2.150.0040.00424.18
8.2.140.0090.00024.66
8.2.130.0000.00818.03
8.2.120.0070.00026.35
8.2.110.0030.00721.00
8.2.100.0040.00817.84
8.2.90.0030.00618.28
8.2.80.0040.00417.97
8.2.70.0030.00618.05
8.2.60.0000.00818.22
8.2.50.0030.00618.10
8.2.40.0080.00019.34
8.2.30.0000.00720.55
8.2.20.0070.00018.14
8.2.10.0070.00019.40
8.2.00.0040.00418.12
8.1.270.0040.00422.19
8.1.260.0080.00026.35
8.1.250.0070.00028.09
8.1.240.0090.00022.50
8.1.230.0110.00022.81
8.1.220.0000.00917.79
8.1.210.0050.00318.84
8.1.200.0070.00317.23
8.1.190.0080.00017.35
8.1.180.0060.00318.10
8.1.170.0000.00918.55
8.1.160.0050.00319.02
8.1.150.0040.00418.83
8.1.140.0000.00719.04
8.1.130.0030.00320.27
8.1.120.0000.00717.46
8.1.110.0030.00317.56
8.1.100.0000.00817.45
8.1.90.0030.00517.41
8.1.80.0030.00517.38
8.1.70.0030.00317.37
8.1.60.0060.00317.62
8.1.50.0100.00017.55
8.1.40.0040.00417.43
8.1.30.0050.00317.66
8.1.20.0030.00517.73
8.1.10.0000.00717.48
8.1.00.0050.00217.55
8.0.300.0000.00819.89
8.0.290.0080.00016.75
8.0.280.0030.00518.48
8.0.270.0080.00017.18
8.0.260.0000.00618.39
8.0.250.0030.00317.00
8.0.240.0000.01016.93
8.0.230.0050.00216.90
8.0.220.0040.00416.93
8.0.210.0030.00317.06
8.0.200.0030.00316.93
8.0.190.0080.00017.00
8.0.180.0000.00717.04
8.0.170.0000.00816.89
8.0.160.0040.00416.87
8.0.150.0000.00716.81
8.0.140.0040.00416.93
8.0.130.0050.00013.43
8.0.120.0030.00616.99
8.0.110.0040.00416.93
8.0.100.0040.00416.82
8.0.90.0070.00016.85
8.0.80.0140.00016.93
8.0.70.0000.00816.82
8.0.60.0030.00516.78
8.0.50.0040.00417.00
8.0.30.0080.01217.04
8.0.20.0110.00817.34
8.0.10.0070.00017.09
8.0.00.0140.00416.80
7.4.330.0000.00516.65
7.4.320.0030.00316.59
7.4.300.0000.00716.54
7.4.290.0070.00016.60
7.4.280.0030.00316.47
7.4.270.0030.00316.55
7.4.260.0040.00416.61
7.4.250.0070.00016.51
7.4.240.0050.00316.63
7.4.230.0030.00316.47
7.4.220.0030.00516.33
7.4.210.0100.01016.54
7.4.200.0030.00316.55
7.4.160.0040.01216.57
7.4.140.0150.00417.86
7.4.130.0140.00316.56
7.4.120.0110.00816.60
7.4.110.0120.00616.57
7.4.100.0090.00916.61
7.4.90.0100.00616.46
7.4.80.0070.01419.39
7.4.70.0060.01116.60
7.4.60.0120.00316.28
7.4.50.0040.01016.62
7.4.40.0100.00716.46
7.4.00.0070.00714.91
7.3.330.0000.00613.33
7.3.320.0000.00513.24
7.3.310.0070.00016.49
7.3.300.0060.00016.41
7.3.290.0070.00016.32
7.3.280.0090.01016.38
7.3.260.0120.00716.54
7.3.240.0150.00216.59
7.3.230.0000.01716.40
7.3.210.0070.01116.47
7.3.200.0110.00616.71
7.3.190.0060.01216.71
7.3.180.0100.00716.64
7.3.170.0060.01216.51
7.3.160.0050.01616.45
7.3.40.0060.01414.66
7.3.30.0100.00714.86
7.3.20.0160.00016.54
7.3.10.0210.00316.70
7.3.00.0110.00016.63
7.2.330.0130.00316.53
7.2.320.0090.00916.82
7.2.310.0170.00316.36
7.2.300.0140.00416.89
7.2.290.0100.01016.77
7.2.170.0110.00315.21
7.2.160.0090.01215.13
7.2.150.0100.00316.73
7.2.140.0110.00317.02
7.2.130.0180.00317.14
7.2.120.0180.00616.68
7.2.110.0120.00917.00
7.2.100.0030.01016.89
7.2.90.0030.00916.96
7.2.80.0130.00917.05
7.2.70.0100.00316.80
7.2.60.0080.00416.74
7.2.50.0110.00316.98
7.2.40.0030.00917.00
7.2.30.0080.00416.96
7.2.20.0030.00916.96
7.2.10.0070.00717.01
7.2.00.0030.01016.83
7.1.280.0050.00815.77
7.1.270.0100.01015.53
7.1.260.0030.00715.86
7.1.250.0190.00315.65

preferences:
59.18 ms | 400 KiB | 5 Q