3v4l.org

run code in 300+ PHP versions simultaneously
<?php class SlightlyLessBollocksMySQLi { public function prepareWithParams($query, $params) { $tokens = $this->getQueryTokens($query); $query = ''; $args = ['']; $paramRefs = []; $i = 1; foreach ($tokens as $token) { if ($token !== '?') { $query .= $token; continue; } $paramRefs[$i] = array_shift($params); switch (true) { case is_array($paramRefs[$i]): $query .= implode(', ', array_fill(0, count($paramRefs[$i]), '?')); $tmp = $paramRefs[$i]; array_splice($paramRefs, $i, 1, $tmp); foreach ($tmp as $val) { switch (true) { case is_int($val): $args[0] .= 'i'; break; case is_float($val): $args[0] .= 'd'; break; default: $args[0] .= 's'; break; } } for ($j = $i; isset($paramRefs[$j]); $j++) { $args[] = &$paramRefs[$j]; } $i = $j; break; case is_int($paramRefs[$i]): case is_bool($paramRefs[$i]): $args[0] .= 'i'; $query .= '?'; $paramRefs[$i] = (int)$paramRefs[$i]; $args[] = &$paramRefs[$i++]; break; case is_float($paramRefs[$i]): $args[0] .= 'd'; $query .= '?'; $args[] = &$paramRefs[$i++]; break; default: $args[0] .= 's'; $query .= '?'; $paramRefs[$i] = (string)$paramRefs[$i]; $args[] = &$paramRefs[$i++]; break; } } var_dump($query, $args); } /** * @param string $token * @return bool */ private function isQuotedString($token) { return in_array($token[0], array('"', "'")) && $token[0] == $token[strlen($token) - 1]; } /** * "Tokenize" the query * * Actually all this does is split the query up into things that are and are not quoted strings, to avoid treating * a literal question mark as a placeholder. * * @param string $query * @return string[] */ private function getQueryTokens($query) { static $expr = '/("(?:[^"\\\\]*(?:\\\\.[^"\\\\]*)*)"|\'(?:[^\'\\\\]*(?:\\\\.[^\'\\\\]*)*)\')/'; $tokens = []; foreach (preg_split($expr, $query, -1, PREG_SPLIT_DELIM_CAPTURE | PREG_SPLIT_NO_EMPTY) as $token) { if ($this->isQuotedString($token)) { $tokens[] = $token; } else { $tokens = array_merge($tokens, preg_split('/(\?)/', $token, -1, PREG_SPLIT_DELIM_CAPTURE)); } } return $tokens; } } (new SlightlyLessBollocksMySQLi)->prepareWithParams("SELECT * FROM foo WHERE 'a' = b AND foo = ? AND bar IN(?)", [2, [1, 2, 12.345, "hello", true]]);

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.0120.00318.81
8.3.50.0210.00721.98
8.3.40.0070.00719.00
8.3.30.0090.00619.21
8.3.20.0040.00420.33
8.3.10.0080.00023.66
8.3.00.0000.00819.69
8.2.180.0130.01016.63
8.2.170.0110.00422.96
8.2.160.0070.00720.39
8.2.150.0000.00824.18
8.2.140.0050.00324.66
8.2.130.0070.01026.16
8.2.120.0060.00321.10
8.2.110.0090.00022.32
8.2.100.0040.00818.16
8.2.90.0000.00819.25
8.2.80.0040.00417.97
8.2.70.0030.00617.75
8.2.60.0000.00918.04
8.2.50.0060.00318.07
8.2.40.0000.00818.34
8.2.30.0000.00818.31
8.2.20.0000.00818.00
8.2.10.0040.00418.18
8.2.00.0040.00417.87
8.1.280.0040.01125.92
8.1.270.0050.00323.91
8.1.260.0080.00026.35
8.1.250.0000.00828.09
8.1.240.0030.00623.87
8.1.230.0040.00819.11
8.1.220.0000.00817.78
8.1.210.0040.00418.77
8.1.200.0030.00617.50
8.1.190.0030.00617.47
8.1.180.0040.00418.10
8.1.170.0060.00318.89
8.1.160.0030.00622.06
8.1.150.0040.00418.81
8.1.140.0030.00617.68
8.1.130.0000.00817.69
8.1.120.0050.00217.63
8.1.110.0040.00417.65
8.1.100.0000.00717.55
8.1.90.0040.00417.68
8.1.80.0040.00417.54
8.1.70.0040.00417.55
8.1.60.0000.00917.66
8.1.50.0060.00317.66
8.1.40.0000.00817.80
8.1.30.0000.00817.91
8.1.20.0000.00817.82
8.1.10.0060.00317.67
8.1.00.0070.00317.71
8.0.300.0080.00018.77
8.0.290.0060.00317.00
8.0.280.0000.00718.41
8.0.270.0040.00417.18
8.0.260.0070.00017.01
8.0.250.0070.00017.02
8.0.240.0030.00317.18
8.0.230.0000.00717.14
8.0.220.0040.00417.05
8.0.210.0000.00716.97
8.0.200.0000.00817.04
8.0.190.0040.00417.18
8.0.180.0040.00417.07
8.0.170.0030.00517.07
8.0.160.0080.00017.14
8.0.150.0040.00417.09
8.0.140.0000.00817.01
8.0.130.0030.00313.50
8.0.120.0040.00417.02
8.0.110.0030.00517.07
8.0.100.0000.00817.10
8.0.90.0040.00416.95
8.0.80.0080.01317.03
8.0.70.0080.00017.20
8.0.60.0000.00717.10
8.0.50.0000.00717.11
8.0.30.0080.01117.54
8.0.20.0110.00917.52
8.0.10.0050.00317.18
8.0.00.0070.01117.14
7.4.330.0050.00015.18
7.4.320.0030.00316.61
7.4.300.0040.00416.75
7.4.290.0070.00016.86
7.4.280.0040.00416.84
7.4.270.0040.00416.86
7.4.260.0040.00416.73
7.4.250.0030.00616.65
7.4.240.0020.00516.86
7.4.230.0040.00416.88
7.4.220.0070.02116.87
7.4.210.0080.00816.75
7.4.200.0030.00316.94
7.4.160.0130.00316.82
7.4.150.0030.01417.40
7.4.140.0080.01017.86
7.4.130.0110.00516.64
7.4.120.0120.01016.86
7.4.110.0070.01016.84
7.4.100.0060.01216.71
7.4.90.0080.00916.85
7.4.80.0130.01019.39
7.4.70.0090.00616.70
7.4.60.0100.00716.92
7.4.50.0040.00016.67
7.4.40.0060.01016.72
7.4.30.0030.01316.85
7.4.00.0060.00915.04
7.3.330.0000.00613.50
7.3.320.0000.00513.31
7.3.310.0040.00416.55
7.3.300.0050.00216.52
7.3.290.0030.01016.58
7.3.280.0100.01016.57
7.3.270.0120.00617.40
7.3.260.0200.00316.60
7.3.250.0090.01216.63
7.3.240.0070.01016.53
7.3.230.0060.01116.41
7.3.210.0160.00316.57
7.3.200.0030.01419.39
7.3.190.0170.00616.52
7.3.180.0160.00616.42
7.3.170.0190.00416.61
7.3.160.0120.01016.56
7.3.120.0040.01114.95
7.3.110.0080.00415.01
7.3.100.0110.00715.08
7.3.90.0040.00815.02
7.3.80.0030.00715.19
7.3.70.0090.00614.91
7.3.60.0070.01015.06
7.3.50.0090.00615.04
7.3.40.0080.00315.08
7.3.30.0140.00014.71
7.3.20.0000.01516.94
7.3.10.0040.00716.89
7.3.00.0060.00816.64
7.2.330.0120.01216.94
7.2.320.0070.01116.93
7.2.310.0000.01716.85
7.2.300.0090.00916.83
7.2.290.0030.01417.11
7.2.240.0030.00715.50
7.2.230.0070.00714.94
7.2.220.0030.01015.29
7.2.210.0090.00614.98
7.2.200.0030.00915.04
7.2.190.0040.01215.30
7.2.180.0070.01015.45
7.2.170.0030.01415.45
7.2.160.0060.01215.36
7.2.150.0120.00317.18
7.2.140.0000.01717.23
7.2.130.0000.01117.31
7.2.120.0130.00317.18
7.2.110.0060.00917.09
7.2.100.0100.00717.23
7.2.90.0060.00616.96
7.2.80.0030.01217.16
7.2.70.0060.00917.00
7.2.60.0060.00917.14
7.2.50.0090.00617.30
7.2.40.0070.00717.25
7.2.30.0110.00717.33
7.2.20.0070.01117.20
7.2.10.0040.01417.22
7.2.00.0070.00717.10
7.1.330.0060.00916.05
7.1.320.0000.01016.19
7.1.310.0080.00316.03
7.1.300.0030.00716.04
7.1.290.0100.00316.07
7.1.280.0040.00716.12
7.1.270.0070.01015.62
7.1.260.0040.01115.95
7.1.250.0100.00316.09
7.1.200.0030.00716.07
7.1.100.0000.01018.39
7.1.70.0000.01017.55
7.1.60.0060.01819.70
7.1.50.0100.01317.21
7.1.00.0000.08022.33
7.0.200.0040.00916.63
7.0.140.0070.07021.96
7.0.60.0130.06020.07
7.0.50.0100.05717.92
7.0.40.0130.05320.43
7.0.30.0200.04320.11
7.0.20.0200.04720.25
7.0.10.0070.06020.26
7.0.00.0100.06320.21
5.6.280.0030.07320.80
5.6.210.0070.07320.52
5.6.200.0070.06018.19
5.6.190.0170.04020.50
5.6.180.0030.08320.77
5.6.170.0230.04020.71
5.6.160.0000.04320.46
5.6.150.0130.07018.19
5.6.140.0070.05318.19
5.6.130.0000.04318.15
5.6.120.0170.06021.15
5.6.110.0100.08021.04
5.6.100.0070.03721.13
5.6.90.0000.09021.03
5.6.80.0200.07320.30
5.6.70.4070.03720.52
5.5.350.0030.07320.42
5.5.340.0130.06017.96
5.5.330.0070.04020.19
5.5.320.0270.08320.27
5.5.310.0300.07320.27
5.5.300.0130.07317.95
5.5.290.0070.08018.01
5.5.280.0000.09320.89
5.5.270.0070.08720.84
5.5.260.0100.07320.65
5.5.250.0070.05720.49
5.5.240.0170.07320.23
5.4.450.0600.04719.32
5.4.440.0370.04344.26
5.4.430.0330.04343.92
5.4.420.0330.04343.91
5.4.410.0370.04043.90
5.4.400.0330.04043.90
5.4.390.0370.03343.89
5.4.380.0230.05318.79
5.4.370.0200.04718.73
5.4.360.0170.04718.66
5.4.350.0130.05718.78
5.4.340.0170.05018.69
5.4.320.0060.03812.53
5.4.310.0110.04512.52
5.4.300.0050.03712.52
5.4.290.0070.03712.52
5.4.280.0060.03612.41
5.4.270.0070.03512.42
5.4.260.0080.03712.41
5.4.250.0030.04312.42
5.4.240.0070.03612.42
5.4.230.0040.04112.41
5.4.220.0060.03612.41
5.4.210.0060.03712.41
5.4.200.0040.04012.41
5.4.190.0090.03312.40
5.4.180.0080.03512.40
5.4.170.0070.03512.41
5.4.160.0020.04012.42
5.4.150.0040.04212.41
5.4.140.0040.04112.09
5.4.130.0060.03512.08
5.4.120.0020.04612.04
5.4.110.0050.03812.04
5.4.100.0090.03212.03
5.4.90.0070.03612.03
5.4.80.0090.03512.04
5.4.70.0110.03012.04
5.4.60.0040.04212.03
5.4.50.0070.03912.03
5.4.40.0080.03312.02
5.4.30.0060.03812.02
5.4.20.0050.03712.02
5.4.10.0060.03512.02
5.4.00.0070.03911.51
5.3.290.0090.04812.80
5.3.280.0070.03712.71
5.3.270.0060.03812.72
5.3.260.0090.03612.72
5.3.250.0070.03512.72
5.3.240.0080.03812.72
5.3.230.0090.03412.71
5.3.220.0040.03912.68
5.3.210.0060.04012.68
5.3.200.0070.04212.68
5.3.190.0070.04712.68
5.3.180.0030.03912.67
5.3.170.0090.03312.67
5.3.160.0090.03312.67
5.3.150.0050.03912.67
5.3.140.0080.03812.66
5.3.130.0050.04112.66
5.3.120.0050.04012.66
5.3.110.0060.04112.65
5.3.100.0060.03712.13
5.3.90.0090.03512.10
5.3.80.0060.03612.09
5.3.70.0040.03812.10
5.3.60.0040.03812.08
5.3.50.0090.03312.03
5.3.40.0040.03812.03
5.3.30.0060.03511.98
5.3.20.0060.03511.77
5.3.10.0110.03611.73
5.3.00.0070.03911.72
5.2.170.0040.0309.22
5.2.160.0040.0299.23
5.2.150.0030.0329.23
5.2.140.0050.0319.23
5.2.130.0040.0299.19
5.2.120.0050.0359.18
5.2.110.0060.0329.19
5.2.100.0040.0299.18
5.2.90.0050.0279.18
5.2.80.0050.0319.18
5.2.70.0050.0299.18
5.2.60.0050.0369.14
5.2.50.0060.0299.10
5.2.40.0100.0269.08
5.2.30.0030.0309.05
5.2.20.0030.0379.05
5.2.10.0080.0278.95
5.2.00.0050.0298.81
5.1.60.0030.0248.10
5.1.50.0020.0278.09
5.1.40.0070.0298.08
5.1.30.0020.0288.42
5.1.20.0050.0308.45
5.1.10.0070.0308.17
5.1.00.0030.0268.18
5.0.50.0020.0226.65
5.0.40.0030.0216.50
5.0.30.0050.0306.32
5.0.20.0050.0186.28
5.0.10.0050.0186.27
5.0.00.0040.0306.25
4.4.90.0020.0154.78
4.4.80.0050.0164.76
4.4.70.0040.0184.75
4.4.60.0040.0154.76
4.4.50.0040.0234.77
4.4.40.0020.0324.71
4.4.30.0030.0214.76
4.4.20.0010.0244.85
4.4.10.0010.0194.85
4.4.00.0030.0244.76
4.3.110.0030.0154.67
4.3.100.0050.0134.66
4.3.90.0030.0144.64
4.3.80.0030.0244.59
4.3.70.0060.0124.63
4.3.60.0020.0204.63
4.3.50.0030.0204.63
4.3.40.0040.0254.54
4.3.30.0020.0173.30
4.3.20.0020.0163.28
4.3.10.0020.0163.23
4.3.00.0100.01343.87

preferences:
40.78 ms | 401 KiB | 5 Q