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]), '?')); 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; } } 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(?) OR yomama = ?", [2, [1, 2, 12.345, "hello", true], "gay"]);

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.0070.00718.55
8.3.50.0090.00922.05
8.3.40.0110.00418.92
8.3.30.0070.00719.04
8.3.20.0060.00320.25
8.3.10.0080.00023.48
8.3.00.0080.00019.79
8.2.180.0180.00416.63
8.2.170.0090.01322.96
8.2.160.0100.00320.57
8.2.150.0040.00424.18
8.2.140.0050.00324.66
8.2.130.0040.01226.16
8.2.120.0030.00521.02
8.2.110.0040.00422.30
8.2.100.0040.00819.82
8.2.90.0050.00319.30
8.2.80.0000.00817.97
8.2.70.0030.00617.88
8.2.60.0080.00018.03
8.2.50.0040.00418.07
8.2.40.0030.00518.34
8.2.30.0030.00518.44
8.2.20.0040.00417.79
8.2.10.0080.00018.06
8.2.00.0040.00417.89
8.1.280.0070.01425.92
8.1.270.0040.00423.89
8.1.260.0040.00426.35
8.1.250.0070.00028.09
8.1.240.0070.01123.84
8.1.230.0110.00019.22
8.1.220.0000.00817.91
8.1.210.0000.00818.77
8.1.200.0090.00017.60
8.1.190.0030.00517.25
8.1.180.0040.00418.10
8.1.170.0000.00818.76
8.1.160.0020.00522.06
8.1.150.0000.00718.78
8.1.140.0030.00517.57
8.1.130.0030.00317.88
8.1.120.0000.00717.54
8.1.110.0040.00417.66
8.1.100.0040.00417.65
8.1.90.0030.00517.71
8.1.80.0050.00317.63
8.1.70.0080.00017.61
8.1.60.0060.00317.70
8.1.50.0060.00317.69
8.1.40.0080.00417.75
8.1.30.0000.00817.84
8.1.20.0000.00817.67
8.1.10.0030.00517.60
8.1.00.0080.00317.72
8.0.300.0000.00718.77
8.0.290.0020.00516.88
8.0.280.0070.00018.42
8.0.270.0040.00417.43
8.0.260.0040.00417.33
8.0.250.0000.00717.14
8.0.240.0050.00317.10
8.0.230.0040.00417.02
8.0.220.0030.00617.00
8.0.210.0070.00016.96
8.0.200.0090.00017.16
8.0.190.0040.00417.10
8.0.180.0000.00717.09
8.0.170.0080.00016.98
8.0.160.0000.00717.02
8.0.150.0040.00416.95
8.0.140.0030.00316.94
8.0.130.0030.00313.49
8.0.120.0080.00016.96
8.0.110.0040.00416.96
8.0.100.0040.00417.14
8.0.90.0050.00317.00
8.0.80.0130.00717.00
8.0.70.0050.00316.86
8.0.60.0030.00516.91
8.0.50.0040.00417.14
8.0.30.0130.00717.32
8.0.20.0160.00317.42
8.0.10.0040.00417.02
8.0.00.0090.00916.91
7.4.330.0000.00515.11
7.4.320.0050.00216.74
7.4.300.0000.00616.81
7.4.290.0050.00316.63
7.4.280.0000.00816.84
7.4.270.0030.00516.86
7.4.260.0060.00316.82
7.4.250.0000.00816.67
7.4.240.0020.00516.73
7.4.230.0040.00416.59
7.4.220.0160.00316.86
7.4.210.0030.01216.94
7.4.200.0000.00716.74
7.4.160.0080.00816.88
7.4.150.0060.01817.40
7.4.140.0140.00317.86
7.4.130.0090.00916.79
7.4.120.0060.01216.87
7.4.110.0130.01316.79
7.4.100.0070.01016.72
7.4.90.0120.00616.85
7.4.80.0140.00419.39
7.4.70.0100.00716.77
7.4.60.0130.00316.59
7.4.50.0030.00616.71
7.4.40.0140.00416.66
7.4.30.0060.01016.63
7.4.00.0150.00015.26
7.3.330.0000.00613.31
7.3.320.0050.00013.36
7.3.310.0040.00416.68
7.3.300.0070.00016.42
7.3.290.0070.00716.52
7.3.280.0100.00816.57
7.3.270.0040.01517.40
7.3.260.0120.00616.85
7.3.250.0150.00316.62
7.3.240.0120.00616.88
7.3.230.0080.00816.69
7.3.210.0080.00816.55
7.3.200.0060.01019.39
7.3.190.0160.00616.71
7.3.180.0130.00316.69
7.3.170.0100.00716.80
7.3.160.0140.01016.87
7.3.120.0040.01115.08
7.3.110.0060.00815.06
7.3.100.0070.01114.94
7.3.90.0070.00715.00
7.3.80.0130.00315.21
7.3.70.0030.00915.05
7.3.60.0040.00815.20
7.3.50.0030.01414.74
7.3.40.0120.00314.65
7.3.30.0040.01215.13
7.3.20.0030.01016.97
7.3.10.0110.00316.89
7.3.00.0060.01016.97
7.2.330.0060.01216.91
7.2.320.0090.00916.70
7.2.310.0090.00917.02
7.2.300.0060.01516.92
7.2.290.0120.00316.73
7.2.240.0100.00715.25
7.2.230.0030.01315.41
7.2.220.0030.01415.30
7.2.210.0070.00715.27
7.2.200.0070.00715.19
7.2.190.0060.00915.36
7.2.180.0060.00915.20
7.2.170.0130.00615.42
7.2.160.0090.00615.13
7.2.150.0030.00917.12
7.2.140.0030.01016.90
7.2.130.0120.00317.09
7.2.120.0040.01417.25
7.2.110.0030.01317.20
7.2.100.0060.00917.00
7.2.90.0080.00417.34
7.2.80.0030.00817.22
7.2.70.0120.00317.27
7.2.60.0060.00916.98
7.2.50.0060.00617.35
7.2.40.0030.01317.03
7.2.30.0130.00317.23
7.2.20.0130.00617.06
7.2.10.0060.00917.17
7.2.00.0070.01017.05
7.1.330.0070.00715.98
7.1.320.0070.00715.99
7.1.310.0090.00616.03
7.1.300.0000.01816.14
7.1.290.0060.00615.77
7.1.280.0030.01315.90
7.1.270.0040.00816.06
7.1.260.0100.00615.99
7.1.250.0090.00615.93
7.1.70.0040.00417.48
7.1.60.0110.01519.70
7.1.50.0060.01917.05
7.1.00.0070.07322.43
7.0.200.0000.00916.79
7.0.140.0070.07021.98
7.0.60.0070.08019.97
7.0.50.0070.04717.94
7.0.40.0030.05320.26
7.0.30.0530.07320.23
7.0.20.0200.08720.35
7.0.10.0300.07320.21
7.0.00.0070.08320.09
5.6.280.0030.07021.16
5.6.210.0000.04320.57
5.6.200.0170.05318.14
5.6.190.0030.09020.39
5.6.180.0300.08020.50
5.6.170.0270.04020.41
5.6.160.0030.08720.55
5.6.150.0070.08018.15
5.6.140.0000.06718.23
5.6.130.0100.07718.18
5.6.120.0130.04321.04
5.6.110.0100.06321.03
5.6.100.0100.07320.98
5.6.90.0070.08721.12
5.6.80.0130.07020.30
5.6.70.4530.04020.42
5.5.350.0100.08320.35
5.5.340.0100.05017.94
5.5.330.0030.05320.13
5.5.320.0270.04720.36
5.5.310.0300.07320.30
5.5.300.0030.05317.95
5.5.290.0070.08018.04
5.5.280.0170.07720.99
5.5.270.0070.06020.75
5.5.260.0070.08020.70
5.5.250.0100.07720.52
5.5.240.0000.07720.14
5.4.450.0800.04319.41
5.4.440.0200.05043.99
5.4.430.0400.04343.92
5.4.420.0300.04743.91
5.4.410.0230.03743.90
5.4.400.0300.04043.90
5.4.390.0830.03043.89
5.4.380.0230.05018.48
5.4.370.0230.04318.76
5.4.360.0200.04318.62
5.4.350.0200.05018.49
5.4.340.0330.04718.73
5.4.320.0100.03812.53
5.4.310.0070.03712.52
5.4.300.0080.04112.53
5.4.290.0050.04312.52
5.4.280.0050.03812.42
5.4.270.0090.03712.42
5.4.260.0060.03812.42
5.4.250.0060.03712.42
5.4.240.0070.03412.42
5.4.230.0050.04012.41
5.4.220.0090.03912.41
5.4.210.0080.03512.41
5.4.200.0020.04712.41
5.4.190.0070.03512.40
5.4.180.0080.03812.41
5.4.170.0060.03512.41
5.4.160.0050.04212.41
5.4.150.0060.04012.41
5.4.140.0090.04512.10
5.4.130.0060.03512.08
5.4.120.0080.03312.04
5.4.110.0070.03512.03
5.4.100.0040.03912.03
5.4.90.0100.03312.03
5.4.80.0070.03712.04
5.4.70.0050.03612.04
5.4.60.0030.03812.04
5.4.50.0030.03812.03
5.4.40.0070.03812.02
5.4.30.0040.03812.02
5.4.20.0060.04112.02
5.4.10.0110.03412.02
5.4.00.0030.04311.51
5.3.290.0040.04912.80
5.3.280.0050.04112.71
5.3.270.0130.04012.72
5.3.260.0040.04012.72
5.3.250.0060.03712.72
5.3.240.0050.03912.72
5.3.230.0050.03812.71
5.3.220.0040.03912.68
5.3.210.0050.03912.68
5.3.200.0040.03812.68
5.3.190.0080.04112.68
5.3.180.0070.03712.67
5.3.170.0030.03812.67
5.3.160.0050.03612.67
5.3.150.0060.03712.67
5.3.140.0010.04112.66
5.3.130.0080.03712.65
5.3.120.0010.04412.66
5.3.110.0050.03912.66
5.3.100.0090.03312.13
5.3.90.0070.03712.11
5.3.80.0050.03712.10
5.3.70.0090.03612.09
5.3.60.0070.03612.08
5.3.50.0080.03812.03
5.3.40.0040.04112.03
5.3.30.0070.03811.99
5.3.20.0090.03511.77
5.3.10.0050.03611.73
5.3.00.0040.03811.72
5.2.170.0050.0299.22
5.2.160.0060.0319.23
5.2.150.0050.0299.23
5.2.140.0030.0319.23
5.2.130.0040.0349.18
5.2.120.0070.0269.19
5.2.110.0050.0299.20
5.2.100.0040.0299.18
5.2.90.0040.0309.18
5.2.80.0030.0329.18
5.2.70.0040.0329.18
5.2.60.0030.0319.13
5.2.50.0050.0319.11
5.2.40.0060.0269.08
5.2.30.0040.0309.05
5.2.20.0040.0369.04
5.2.10.0090.0268.95
5.2.00.0050.0368.81
5.1.60.0050.0278.10
5.1.50.0040.0258.09
5.1.40.0030.0328.07
5.1.30.0060.0238.42
5.1.20.0060.0278.45
5.1.10.0070.0258.17
5.1.00.0060.0228.18
5.0.50.0040.0266.65
5.0.40.0030.0196.50
5.0.30.0040.0316.32
5.0.20.0040.0216.29
5.0.10.0040.0186.26
5.0.00.0070.0376.25
4.4.90.0010.0174.77
4.4.80.0030.0144.75
4.4.70.0050.0124.75
4.4.60.0030.0154.75
4.4.50.0030.0144.77
4.4.40.0030.0254.71
4.4.30.0030.0154.76
4.4.20.0040.0144.84
4.4.10.0010.0194.85
4.4.00.0050.0244.76
4.3.110.0020.0204.67
4.3.100.0020.0194.66
4.3.90.0060.0154.63
4.3.80.0030.0274.59
4.3.70.0030.0194.63
4.3.60.0010.0204.63
4.3.50.0020.0164.63
4.3.40.0020.0264.54
4.3.30.0060.0253.30
4.3.20.0010.0173.29
4.3.10.0030.0153.24
4.3.00.0170.02043.87

preferences:
38.95 ms | 401 KiB | 5 Q