3v4l.org

run code in 300+ PHP versions simultaneously
<?php class SlightlyLessBollocksMySQLi extends mysqli { 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]), '?')); array_splice($paramRefs, $i, 1, $paramRefs[$i]); for ($j = $i; isset($paramRefs[$j]); $j++) { switch (true) { case is_int($paramRefs[$j]): case is_bool($paramRefs[$j]): $args[0] .= 'i'; $paramRefs[$j] = (int)$paramRefs[$j]; break; case is_float($paramRefs[$j]): $args[0] .= 'd'; break; default: $args[0] .= 's'; $paramRefs[$j] = (string)$paramRefs[$j]; break; } $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; } } $stmt = $this->prepare($query); call_user_func_array([$stmt, 'bind_param'], $args); return $stmt; } /** * @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.0040.01118.68
8.3.50.0110.00821.93
8.3.40.0070.00718.69
8.3.30.0040.01118.94
8.3.20.0040.00420.16
8.3.10.0080.00023.65
8.3.00.0080.00019.80
8.2.180.0040.01516.88
8.2.170.0140.00722.96
8.2.160.0100.00320.39
8.2.150.0000.00824.18
8.2.140.0040.00424.66
8.2.130.0000.00826.16
8.2.120.0050.00321.09
8.2.110.0040.00422.07
8.2.100.0110.00018.09
8.2.90.0040.00419.05
8.2.80.0040.00417.97
8.2.70.0040.00417.63
8.2.60.0110.00017.93
8.2.50.0060.00318.07
8.2.40.0080.00018.03
8.2.30.0050.00218.29
8.2.20.0040.00417.66
8.2.10.0000.00818.02
8.2.00.0000.00817.66
8.1.280.0040.01425.92
8.1.270.0040.00423.83
8.1.260.0040.00426.35
8.1.250.0070.00028.09
8.1.240.0030.00623.92
8.1.230.0100.00019.00
8.1.220.0000.00817.74
8.1.210.0090.00018.77
8.1.200.0000.01117.23
8.1.190.0050.00317.22
8.1.180.0080.00018.10
8.1.170.0040.00418.71
8.1.160.0000.00721.99
8.1.150.0080.00018.55
8.1.140.0000.00817.32
8.1.130.0040.00417.75
8.1.120.0050.00217.48
8.1.110.0040.00417.41
8.1.100.0000.00717.45
8.1.90.0040.00417.30
8.1.80.0000.00717.32
8.1.70.0000.00817.42
8.1.60.0030.00517.59
8.1.50.0000.00817.40
8.1.40.0080.00017.39
8.1.30.0040.00417.53
8.1.20.0030.00617.53
8.1.10.0040.00417.50
8.1.00.0030.00917.40
8.0.300.0040.00418.77
8.0.290.0040.00416.88
8.0.280.0070.00018.39
8.0.270.0040.00417.34
8.0.260.0060.00018.39
8.0.250.0000.00717.09
8.0.240.0030.00316.96
8.0.230.0030.00317.05
8.0.220.0070.00316.89
8.0.210.0000.00716.99
8.0.200.0080.00017.04
8.0.190.0050.00217.00
8.0.180.0040.00416.91
8.0.170.0080.00017.02
8.0.160.0040.00416.82
8.0.150.0040.00416.92
8.0.140.0000.00717.01
8.0.130.0030.00313.40
8.0.120.0060.00317.00
8.0.110.0000.00716.95
8.0.100.0000.00716.99
8.0.90.0000.00716.86
8.0.80.0040.02016.92
8.0.70.0000.00817.10
8.0.60.0040.00416.84
8.0.50.0040.00416.84
8.0.30.0090.01317.13
8.0.20.0130.00717.40
8.0.10.0000.00817.03
8.0.00.0080.00916.79
7.4.330.0020.00215.03
7.4.320.0000.00716.43
7.4.300.0000.00716.45
7.4.290.0050.00316.63
7.4.280.0060.00316.48
7.4.270.0000.00716.42
7.4.260.0030.00616.43
7.4.250.0000.00816.43
7.4.240.0040.00416.44
7.4.230.0030.00316.57
7.4.220.0150.00416.57
7.4.210.0040.01116.59
7.4.200.0050.00216.60
7.4.160.0070.01116.76
7.4.150.0090.00917.40
7.4.140.0140.00317.86
7.4.130.0110.00916.56
7.4.120.0090.00916.47
7.4.110.0130.00616.46
7.4.100.0120.00616.74
7.4.90.0070.01016.57
7.4.80.0040.01819.39
7.4.70.0110.01116.56
7.4.60.0060.00916.65
7.4.50.0060.00316.51
7.4.40.0120.00616.51
7.4.30.0130.00316.30
7.4.00.0120.00314.94
7.3.330.0000.00613.29
7.3.320.0050.00013.10
7.3.310.0040.00316.33
7.3.300.0000.00716.33
7.3.290.0000.01416.36
7.3.280.0070.01016.30
7.3.270.0110.00717.40
7.3.260.0030.01416.43
7.3.250.0050.01216.47
7.3.240.0080.00916.56
7.3.230.0120.00416.61
7.3.210.0110.00616.63
7.3.200.0070.00819.39
7.3.190.0120.01016.59
7.3.180.0000.01816.43
7.3.170.0140.00716.32
7.3.160.0070.01016.42
7.3.120.0100.00714.88
7.2.330.0190.00316.38
7.2.320.0140.00916.63
7.2.310.0030.01316.48
7.2.300.0130.01016.49
7.2.290.0100.00616.55
7.2.60.0120.00616.78
7.1.200.0070.00715.71
7.1.100.0070.00717.57
7.1.70.0070.00016.82
7.1.60.0000.02319.70
7.1.50.0070.01716.52
7.1.00.0100.07022.45
7.0.200.0000.00716.27
7.0.140.0130.06322.10
7.0.60.0100.07720.09
7.0.50.0100.04317.85
7.0.40.0100.07720.14
7.0.30.0470.03720.15
7.0.20.0430.08020.08
7.0.10.0230.04320.26
7.0.00.0130.07320.07
5.6.280.0030.07320.88
5.6.210.0130.07320.54
5.6.200.0070.06718.18
5.6.190.0030.07720.67
5.6.180.0030.05720.50
5.6.170.0230.03320.50
5.6.160.0130.07320.46
5.6.150.0000.04718.24
5.6.140.0030.07718.18
5.6.130.0070.05018.26
5.6.120.0100.08021.16
5.6.110.0070.04021.04
5.6.100.0030.09720.98
5.6.90.0070.06321.02
5.6.80.0100.06720.40
5.6.70.0270.07020.40
5.5.350.0030.07020.32
5.5.340.0030.05018.00
5.5.330.0100.05020.46
5.5.320.0370.05020.24
5.5.310.0200.04020.27
5.5.300.0070.08317.94
5.5.290.0030.07317.94
5.5.280.0130.04320.90
5.5.270.0070.08020.66
5.5.260.0070.04020.89
5.5.250.0030.09020.64
5.5.240.0100.06720.25
5.4.450.0430.04019.45
5.4.440.0300.04044.53
5.4.430.0370.03019.52
5.4.420.0400.04343.91
5.4.410.0530.03743.90
5.4.400.0370.04043.90
5.4.390.0370.04343.89
5.4.380.0300.06018.60
5.4.370.0130.06318.55
5.4.360.0130.05318.69
5.4.350.0200.05018.52
5.4.340.0070.06018.61
5.4.320.0090.03512.52
5.4.310.0080.04812.52
5.4.300.0080.03412.52
5.4.290.0060.03712.52
5.4.280.0050.03612.42
5.4.270.0070.03512.41
5.4.260.0100.04012.41
5.4.250.0070.03712.42
5.4.240.0060.03512.41
5.4.230.0050.03812.40
5.4.220.0060.03512.41
5.4.210.0040.03712.41
5.4.200.0100.03912.41
5.4.190.0080.03912.40
5.4.180.0060.03712.40
5.4.170.0110.04412.41
5.4.160.0040.04012.41
5.4.150.0050.04312.41
5.4.140.0080.03912.09
5.4.130.0030.03812.08
5.4.120.0050.04612.04
5.4.110.0060.04712.03
5.4.100.0070.03912.03
5.4.90.0040.04612.03
5.4.80.0060.03812.04
5.4.70.0040.04412.02
5.4.60.0110.04012.03
5.4.50.0050.04912.03
5.4.40.0070.04412.01
5.4.30.0080.03512.01
5.4.20.0080.03912.01
5.4.10.0070.03712.01
5.4.00.0050.04311.50
5.3.290.0050.04412.80
5.3.280.0130.03912.71
5.3.270.0110.04412.73
5.3.260.0060.04612.72
5.3.250.0090.04012.72
5.3.240.0070.04812.72
5.3.230.0100.04012.70
5.3.220.0060.04312.68
5.3.210.0100.03712.68
5.3.200.0060.04412.68
5.3.190.0100.04512.68
5.3.180.0090.04512.68
5.3.170.0080.04212.66
5.3.160.0050.03812.67
5.3.150.0080.03612.67
5.3.140.0040.04612.66
5.3.130.0060.04412.65
5.3.120.0060.03912.66
5.3.110.0090.03912.66
5.3.100.0110.03712.13
5.3.90.0070.04112.11
5.3.80.0070.04512.09
5.3.70.0060.04812.10
5.3.60.0080.05012.08
5.3.50.0090.04412.03
5.3.40.0060.03812.03
5.3.30.0060.04111.98
5.3.20.0060.04211.77
5.3.10.0060.03511.73
5.3.00.0080.03511.72
5.2.170.0080.0309.22
5.2.160.0050.0369.23
5.2.150.0080.0309.23
5.2.140.0050.0389.23
5.2.130.0080.0339.18
5.2.120.0080.0279.18
5.2.110.0050.0379.19
5.2.100.0070.0289.18
5.2.90.0050.0289.18
5.2.80.0070.0329.18
5.2.70.0050.0319.17
5.2.60.0040.0319.13
5.2.50.0040.0349.11
5.2.40.0050.0299.08
5.2.30.0050.0299.05
5.2.20.0050.0299.04
5.2.10.0050.0268.95
5.2.00.0030.0308.80
5.1.60.0030.0268.10
5.1.50.0050.0248.10
5.1.40.0050.0328.08
5.1.30.0060.0268.42
5.1.20.0070.0238.45
5.1.10.0030.0268.18
5.1.00.0070.0238.18
5.0.50.0040.0226.65
5.0.40.0010.0216.50
5.0.30.0020.0336.32
5.0.20.0030.0226.28
5.0.10.0040.0206.26
5.0.00.0030.0326.26
4.4.90.0030.0154.78
4.4.80.0020.0164.75
4.4.70.0040.0154.76
4.4.60.0050.0144.75
4.4.50.0020.0234.77
4.4.40.0050.0244.71
4.4.30.0040.0164.76
4.4.20.0010.0174.85
4.4.10.0040.0154.85
4.4.00.0000.0284.76
4.3.110.0030.0224.67
4.3.100.0020.0154.67
4.3.90.0020.0154.63
4.3.80.0040.0234.58
4.3.70.0030.0214.63
4.3.60.0010.0164.63
4.3.50.0030.0144.63
4.3.40.0040.0224.54
4.3.30.0010.0173.30
4.3.20.0010.0163.29
4.3.10.0010.0173.24
4.3.00.0070.01343.88

preferences:
61.91 ms | 401 KiB | 5 Q