3v4l.org

run code in 300+ PHP versions simultaneously
<?php /** * @return mixed[] An array containing two elements: the modified SQL query (string), and the modified params (array). */ function unnameSqlParameters(string $sql, array $params): array { $newParams = []; $newSql = preg_replace_callback( '/:(\w+)/', static function (array $matches) use ($params, &$newParams): string { $name = $matches[1]; if (!array_key_exists($name, $params)) { throw new \RuntimeException("Cannot find parameter value for :{$name}."); } $newParams[] = $params[$name]; return '?'; }, $sql ); return [$newSql, $newParams]; } [$sql, $params] = unnameSqlParameters( 'INSERT INTO table1 (a, b, c) VALUES (:a, :b, :c)', ['a' => 'ValueA', 'c' => 'ValueC', 'b' => 'ValueB'] ); echo $sql, PHP_EOL; print_r($params);

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.5.10.0080.01016.70
8.5.00.0140.00820.39
8.4.150.0030.00014.05
8.4.140.0100.01217.85
8.4.130.0100.01018.63
8.4.120.0100.00924.36
8.4.110.0110.01120.53
8.4.100.0120.00918.98
8.4.90.0110.00822.09
8.4.80.0120.00917.92
8.4.70.0150.00517.93
8.4.60.0040.00520.38
8.4.50.0130.00718.78
8.4.40.0140.00317.68
8.4.30.0090.00020.52
8.4.20.0100.01018.02
8.4.10.0120.00419.66
8.3.280.0090.01118.76
8.3.270.0080.01116.63
8.3.260.0130.00716.70
8.3.250.0100.00919.05
8.3.240.0120.00717.39
8.3.230.0140.00816.76
8.3.220.0100.01019.05
8.3.210.0100.00916.68
8.3.200.0050.00216.99
8.3.190.0080.01117.29
8.3.180.0110.00816.66
8.3.170.0150.00617.27
8.3.160.0060.01317.10
8.3.150.0160.00316.93
8.3.140.0070.00016.96
8.3.130.0040.00417.48
8.3.120.0080.00020.78
8.3.110.0040.00416.93
8.3.100.0130.00317.16
8.3.90.0070.00726.77
8.3.80.0040.00716.61
8.3.70.0150.00617.00
8.3.60.0110.00418.55
8.3.50.0110.00817.63
8.3.40.0110.00418.97
8.3.30.0100.01019.14
8.3.20.0080.00024.18
8.3.10.0050.00324.66
8.3.00.0030.00626.16
8.2.290.0040.00520.30
8.2.280.0130.00618.62
8.2.270.0110.00817.13
8.2.260.0050.00318.57
8.2.250.0000.00919.21
8.2.240.0130.00716.95
8.2.230.0000.00820.94
8.2.220.0040.00724.06
8.2.210.0040.00726.77
8.2.200.0060.00316.75
8.2.190.0070.01416.63
8.2.180.0070.00725.92
8.2.170.0090.00619.26
8.2.160.0150.00022.96
8.2.150.0070.00025.66
8.2.140.0000.00824.66
8.2.130.0030.00526.16
8.2.120.0080.00026.35
8.2.110.0070.01720.07
8.2.100.0120.00017.91
8.2.90.0030.00517.88
8.2.80.0030.00518.86
8.2.70.0030.00617.75
8.2.60.0050.00318.05
8.2.50.0030.00618.05
8.2.40.0030.00618.12
8.2.30.0090.00318.16
8.2.20.0040.00418.03
8.2.10.0050.00219.42
8.2.00.0000.00719.49
8.1.330.0110.00722.08
8.1.320.0170.00216.46
8.1.310.0090.00318.70
8.1.300.0130.00618.42
8.1.290.0060.00630.84
8.1.280.0130.00725.92
8.1.270.0040.00423.99
8.1.260.0070.00328.09
8.1.250.0070.00028.09
8.1.240.0060.00322.06
8.1.230.0030.01022.66
8.1.220.0040.00417.91
8.1.210.0030.00518.77
8.1.200.0060.00317.50
8.1.190.0030.00617.48
8.1.180.0040.00418.10
8.1.170.0040.00419.03
8.1.160.0040.00418.81
8.1.150.0030.00618.98
8.1.140.0000.00718.93
8.1.130.0040.00422.02
8.1.120.0030.00317.63
8.1.110.0050.00317.68
8.1.100.0040.00417.63
8.1.90.0030.00617.69
8.1.80.0080.00017.52
8.1.70.0000.00717.61
8.1.60.0000.00817.72
8.1.50.0060.00317.76
8.1.40.0000.00917.61
8.1.30.0050.00517.80
8.1.20.0070.00317.82
8.1.10.0000.00817.59
8.1.00.0030.00617.66
8.0.300.0030.00618.77
8.0.290.0000.00717.00
8.0.280.0040.00418.43
8.0.270.0000.01018.23
8.0.260.0070.00020.24
8.0.250.0000.00717.01
8.0.240.0070.00017.09
8.0.230.0030.00317.02
8.0.220.0040.00416.96
8.0.210.0000.00716.96
8.0.200.0030.00317.17
8.0.190.0040.00417.19
8.0.180.0080.00017.18
8.0.170.0040.00417.14
8.0.160.0040.00417.00
8.0.150.0040.00416.89
8.0.140.0040.00417.09
8.0.130.0030.00313.53
8.0.120.0030.00616.92
8.0.110.0000.00716.98
8.0.100.0070.00016.89
8.0.90.0000.00717.11
8.0.80.0080.00916.97
8.0.70.0050.00216.96
8.0.60.0040.00416.89
8.0.50.0060.00316.95
8.0.30.0070.01117.22
8.0.20.0000.01617.13
8.0.10.0140.00617.15
8.0.00.0060.01017.41
7.4.330.0000.00515.55
7.4.320.0030.00316.74
7.4.300.0030.00316.84
7.4.290.0050.00316.59
7.4.280.0030.00616.84
7.4.270.0000.00716.60
7.4.260.0000.00613.52
7.4.250.0000.00716.81
7.4.240.0020.00516.77
7.4.230.0040.00416.91
7.4.220.0030.00316.77
7.4.210.0040.01016.81
7.4.200.0070.00016.92
7.4.160.0070.01016.49
7.4.150.0100.00816.86
7.4.140.0070.01016.59
7.4.130.0080.01116.57
7.4.120.0060.01316.53
7.4.110.0090.00916.60
7.4.100.0090.01216.69
7.4.90.0190.00016.42
7.4.80.0030.01016.82
7.4.70.0090.00616.70
7.4.60.0070.01116.61
7.4.50.0070.00716.61
7.4.40.0080.01116.60
7.4.30.0100.00716.76
7.4.20.0070.01316.72
7.4.10.0170.00316.77
7.4.00.0090.01216.92
7.3.330.0050.00216.50
7.3.320.0030.00313.50
7.3.310.0030.00616.43
7.3.300.0000.00616.53
7.3.290.0090.00716.49
7.3.270.0150.00016.53
7.3.260.0120.00916.81
7.3.250.0120.00616.61
7.3.240.0110.00716.42
7.3.230.0110.00716.57
7.3.220.0050.00916.72
7.3.210.0070.01116.79
7.3.200.0120.00816.81
7.3.190.0110.00616.51
7.3.180.0110.00316.65
7.3.170.0150.00316.57
7.3.160.0130.00616.65
7.3.150.0060.01216.70
7.3.140.0070.01316.58
7.3.130.0070.00716.63
7.3.120.0110.00316.68
7.3.110.0130.00416.60
7.3.100.0060.01216.54
7.3.90.0060.01016.52
7.3.80.0050.00816.80
7.3.70.0110.00716.66
7.3.60.0160.00016.55
7.3.50.0150.00316.63
7.3.40.0090.00916.41
7.3.30.0090.00916.68
7.3.20.0070.01116.70
7.3.10.0750.00716.50
7.3.00.0100.01016.77

preferences:
39.25 ms | 403 KiB | 5 Q