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[$i] = &$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"]]);

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.95
8.3.30.0070.00719.21
8.3.20.0070.00320.30
8.3.10.0060.00323.61
8.3.00.0040.00419.81
8.2.170.0130.00322.96
8.2.160.0100.00320.39
8.2.150.0030.00624.18
8.2.140.0080.00024.66
8.2.130.0000.00826.16
8.2.120.0000.00821.28
8.2.110.0040.00420.52
8.2.100.0110.00017.84
8.2.90.0060.00319.21
8.2.80.0040.00417.97
8.2.70.0060.00317.88
8.2.60.0030.00517.90
8.2.50.0040.00418.07
8.2.40.0050.00318.22
8.2.30.0040.00418.39
8.2.20.0030.00517.98
8.2.10.0040.00418.25
8.2.00.0040.00417.93
8.1.270.0050.00323.82
8.1.260.0000.00726.35
8.1.250.0050.00328.09
8.1.240.0030.00623.92
8.1.230.0000.01219.14
8.1.220.0000.00817.91
8.1.210.0050.00318.77
8.1.200.0070.00317.50
8.1.190.0000.01017.60
8.1.180.0000.00818.10
8.1.170.0080.00018.71
8.1.160.0100.00021.98
8.1.150.0080.00018.72
8.1.140.0000.00717.55
8.1.130.0030.00317.88
8.1.120.0000.00717.64
8.1.110.0030.00517.70
8.1.100.0000.00817.67
8.1.90.0000.00817.66
8.1.80.0020.00517.64
8.1.70.0030.00317.59
8.1.60.0000.00817.80
8.1.50.0000.00817.67
8.1.40.0050.00317.72
8.1.30.0040.00417.81
8.1.20.0040.00417.79
8.1.10.0000.00717.66
8.1.00.0000.01217.53
8.0.300.0050.00318.77
8.0.290.0000.00817.00
8.0.280.0050.00218.42
8.0.270.0040.00417.31
8.0.260.0000.00717.38
8.0.250.0040.00417.18
8.0.240.0030.00317.16
8.0.230.0000.00717.16
8.0.220.0000.01017.08
8.0.210.0000.00717.11
8.0.200.0050.00317.13
8.0.190.0000.00817.03
8.0.180.0000.00717.11
8.0.170.0040.00417.00
8.0.160.0030.00517.06
8.0.150.0040.00416.96
8.0.140.0050.00317.05
8.0.130.0040.00413.46
8.0.120.0000.00817.01
8.0.110.0000.00817.07
8.0.100.0030.00616.91
8.0.90.0070.00017.06
8.0.80.0070.01317.00
8.0.70.0000.00816.91
8.0.60.0000.00716.91
8.0.50.0040.00417.09
8.0.30.0110.00817.49
8.0.20.0090.01017.40
8.0.10.0040.00417.06
8.0.00.0100.01116.93
7.4.330.0000.00515.07
7.4.320.0030.00316.70
7.4.300.0030.00316.80
7.4.290.0030.00316.83
7.4.280.0040.00416.76
7.4.270.0030.00316.72
7.4.260.0070.00016.88
7.4.250.0050.00216.70
7.4.240.0020.00516.81
7.4.230.0050.00216.74
7.4.220.0090.01016.89
7.4.210.0080.01116.96
7.4.200.0040.00416.69
7.4.160.0090.00916.79
7.4.150.0030.01717.40
7.4.140.0100.00717.86
7.4.130.0100.00816.69
7.4.120.0100.01016.76
7.4.110.0070.01116.61
7.4.100.0040.01416.77
7.4.90.0070.01016.80
7.4.80.0200.00319.39
7.4.70.0060.01216.70
7.4.60.0130.00616.85
7.4.50.0030.00616.86
7.4.40.0070.01016.61
7.4.30.0070.01416.97
7.4.00.0070.00714.95
7.3.330.0000.00613.41
7.3.320.0050.00013.49
7.3.310.0000.00716.57
7.3.300.0030.00316.56
7.3.290.0000.01416.48
7.3.280.0090.01116.55
7.3.270.0090.00917.40
7.3.260.0150.00616.72
7.3.250.0060.01216.77
7.3.240.0090.00916.58
7.3.230.0070.01016.75
7.3.210.0110.00716.75
7.3.200.0130.01019.39
7.3.190.0090.00916.68
7.3.180.0070.01016.43
7.3.170.0090.00916.55
7.3.160.0030.01316.76
7.3.120.0070.01115.04
7.3.10.0130.00916.79
7.3.00.0170.00316.84
7.2.330.0120.00616.91
7.2.320.0130.00417.04
7.2.310.0040.01416.66
7.2.300.0180.00016.94
7.2.290.0070.01016.93
7.2.130.0070.01116.92
7.2.120.0030.01316.90
7.2.110.0070.01417.15
7.2.100.0040.00817.08
7.2.90.0110.00916.95
7.2.80.0160.01917.17
7.2.70.0100.01016.83
7.2.60.0070.01116.87
7.2.50.0120.01216.97
7.2.40.0180.00617.24
7.2.30.0090.00917.06
7.2.20.0090.00916.92
7.2.10.0180.00917.21
7.2.00.0140.00617.99
7.1.250.0130.00615.84
7.1.100.0100.00316.66
7.1.70.0070.01017.43
7.1.60.0130.01019.70
7.1.50.0170.00717.16
7.1.00.0030.07322.38
7.0.200.0000.01016.70
7.0.140.0030.07021.95
7.0.60.0130.07719.86
7.0.50.0070.08717.92
7.0.40.0000.07720.20
7.0.30.0500.07020.23
7.0.20.0200.04320.25
7.0.10.0100.09020.25
7.0.00.0030.04720.20
5.6.280.0030.07020.89
5.6.210.0030.08020.63
5.6.200.0030.09018.14
5.6.190.0130.05020.48
5.6.180.4030.04020.55
5.6.170.0470.06320.50
5.6.160.0100.04720.55
5.6.150.0070.06018.15
5.6.140.0070.08718.18
5.6.130.0070.04318.17
5.6.120.0100.06321.03
5.6.110.0130.07721.03
5.6.100.0030.09321.04
5.6.90.0100.07721.05
5.6.80.0100.08320.39
5.6.70.4600.03020.42
5.5.350.0070.04320.54
5.5.340.0130.06717.99
5.5.330.0030.04020.35
5.5.320.0270.05320.27
5.5.310.0270.08020.26
5.5.300.0270.06318.01
5.5.290.0070.07717.93
5.5.280.0130.06320.75
5.5.270.0070.08020.74
5.5.260.0000.08720.88
5.5.250.0070.07720.70
5.5.240.0300.07320.37
5.4.450.0830.03319.46
5.4.440.0170.04043.99
5.4.430.0400.05043.92
5.4.420.0200.05043.91
5.4.410.0200.05343.90
5.4.400.0330.04043.90
5.4.390.0400.04343.89
5.4.380.0200.06318.57
5.4.370.0130.05718.74
5.4.360.0070.06018.61
5.4.350.0130.05318.63
5.4.340.0170.05018.55
5.4.320.0040.04812.52
5.4.310.0080.04012.52
5.4.300.0050.04112.52
5.4.290.0090.04112.52
5.4.280.0070.03912.42
5.4.270.0080.04112.42
5.4.260.0080.03812.42
5.4.250.0070.04212.41
5.4.240.0050.03812.42
5.4.230.0090.03512.41
5.4.220.0050.03912.41
5.4.210.0060.03612.41
5.4.200.0090.03412.41
5.4.190.0030.04012.41
5.4.180.0070.03412.41
5.4.170.0040.03712.42
5.4.160.0060.03512.41
5.4.150.0060.03512.41
5.4.140.0110.03812.09
5.4.130.0060.03512.08
5.4.120.0040.03912.04
5.4.110.0070.04612.03
5.4.100.0110.04012.04
5.4.90.0050.03812.04
5.4.80.0040.03812.04
5.4.70.0060.04212.03
5.4.60.0080.04912.03
5.4.50.0100.03112.04
5.4.40.0090.03712.02
5.4.30.0040.03812.02
5.4.20.0040.03712.02
5.4.10.0050.03612.02
5.4.00.0040.04111.50
5.3.290.0050.04112.80
5.3.280.0080.04012.71
5.3.270.0050.05012.72
5.3.260.0080.04912.72
5.3.250.0080.04212.72
5.3.240.0060.03812.72
5.3.230.0090.04012.71
5.3.220.0070.03612.68
5.3.210.0030.04312.68
5.3.200.0080.04212.68
5.3.190.0100.03712.68
5.3.180.0070.03712.67
5.3.170.0080.04212.67
5.3.160.0070.03612.67
5.3.150.0040.04512.67
5.3.140.0070.03912.66
5.3.130.0080.04012.66
5.3.120.0080.04012.66
5.3.110.0100.03512.66
5.3.100.0080.04012.13
5.3.90.0100.04812.11
5.3.80.0090.04012.09
5.3.70.0040.03912.10
5.3.60.0070.03612.08
5.3.50.0050.03912.03
5.3.40.0030.04012.03
5.3.30.0080.03411.99
5.3.20.0020.04111.77
5.3.10.0040.03611.73
5.3.00.0060.03611.72
5.2.170.0050.0319.23
5.2.160.0040.0309.23
5.2.150.0050.0309.23
5.2.140.0040.0309.22
5.2.130.0070.0289.19
5.2.120.0070.0259.19
5.2.110.0040.0349.19
5.2.100.0030.0309.18
5.2.90.0060.0349.18
5.2.80.0050.0309.18
5.2.70.0070.0299.17
5.2.60.0030.0309.13
5.2.50.0080.0349.11
5.2.40.0040.0319.08
5.2.30.0040.0319.05
5.2.20.0050.0359.04
5.2.10.0080.0388.95
5.2.00.0060.0298.81
5.1.60.0020.0268.09
5.1.50.0040.0258.09
5.1.40.0020.0268.08
5.1.30.0050.0278.42
5.1.20.0030.0288.45
5.1.10.0050.0258.18
5.1.00.0040.0258.17
5.0.50.0040.0206.65
5.0.40.0060.0176.50
5.0.30.0020.0326.32
5.0.20.0020.0216.28
5.0.10.0030.0206.26
5.0.00.0030.0306.25
4.4.90.0040.0144.78
4.4.80.0020.0154.75
4.4.70.0030.0154.75
4.4.60.0030.0154.75
4.4.50.0020.0164.77
4.4.40.0030.0254.71
4.4.30.0010.0174.75
4.4.20.0040.0154.85
4.4.10.0020.0214.85
4.4.00.0020.0314.75
4.3.110.0030.0154.67
4.3.100.0040.0144.66
4.3.90.0030.0144.63
4.3.80.0040.0234.58
4.3.70.0040.0134.63
4.3.60.0030.0204.62
4.3.50.0060.0144.63
4.3.40.0040.0244.54
4.3.30.0010.0173.30
4.3.20.0010.0173.29
4.3.10.0010.0163.24
4.3.00.0000.02043.87

preferences:
45.82 ms | 400 KiB | 5 Q