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(?)", [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.0070.00718.45
8.3.50.0100.01022.24
8.3.40.0000.01518.95
8.3.30.0040.01119.04
8.3.20.0080.00020.38
8.3.10.0080.00023.54
8.3.00.0000.00919.92
8.2.180.0070.01017.00
8.2.170.0110.00419.04
8.2.160.0140.00722.96
8.2.150.0040.00424.18
8.2.140.0000.00824.66
8.2.130.0040.00426.16
8.2.120.0080.00021.10
8.2.110.0030.00622.21
8.2.100.0080.00817.90
8.2.90.0040.00419.22
8.2.80.0040.00417.97
8.2.70.0060.00317.88
8.2.60.0030.00918.04
8.2.50.0030.00618.07
8.2.40.0040.00418.14
8.2.30.0040.00418.32
8.2.20.0000.00918.00
8.2.10.0040.00418.24
8.2.00.0000.00817.81
8.1.280.0110.00425.92
8.1.270.0080.00023.83
8.1.260.0080.00026.35
8.1.250.0070.00028.09
8.1.240.0100.00023.79
8.1.230.0060.00619.16
8.1.220.0000.00817.74
8.1.210.0000.00818.77
8.1.200.0030.00617.60
8.1.190.0050.00317.38
8.1.180.0080.00018.10
8.1.170.0000.00918.75
8.1.160.0040.00422.07
8.1.150.0040.00418.77
8.1.140.0040.00417.70
8.1.130.0080.00017.82
8.1.120.0000.00717.57
8.1.110.0000.00817.64
8.1.100.0000.00717.55
8.1.90.0040.00417.55
8.1.80.0040.00417.64
8.1.70.0030.00517.61
8.1.60.0000.00817.60
8.1.50.0000.00917.77
8.1.40.0030.00517.75
8.1.30.0030.00617.68
8.1.20.0000.00817.77
8.1.10.0030.00517.83
8.1.00.0060.00617.59
8.0.300.0090.00018.77
8.0.290.0060.00317.00
8.0.280.0040.00418.61
8.0.270.0040.00418.75
8.0.260.0040.00417.32
8.0.250.0000.00717.19
8.0.240.0070.00017.05
8.0.230.0040.00417.09
8.0.220.0030.00617.07
8.0.210.0050.00216.98
8.0.200.0050.00317.00
8.0.190.0070.00017.23
8.0.180.0000.00717.06
8.0.170.0060.00316.99
8.0.160.0000.00717.13
8.0.150.0040.00416.98
8.0.140.0000.00817.06
8.0.130.0060.00013.55
8.0.120.0040.00417.08
8.0.110.0070.00016.96
8.0.100.0080.00016.86
8.0.90.0000.00716.95
8.0.80.0110.01117.10
8.0.70.0040.00416.95
8.0.60.0000.00817.07
8.0.50.0040.00417.07
8.0.30.0130.00617.42
8.0.20.0070.01117.53
8.0.10.0040.00417.16
8.0.00.0080.01017.03
7.4.330.0050.00015.17
7.4.320.0030.00316.66
7.4.300.0060.00016.72
7.4.290.0000.00816.74
7.4.280.0060.00316.85
7.4.270.0040.00416.68
7.4.260.0070.00016.77
7.4.250.0040.00416.82
7.4.240.0050.00216.89
7.4.230.0000.00716.57
7.4.220.0110.01116.84
7.4.210.0060.00916.90
7.4.200.0050.00216.86
7.4.160.0060.01616.72
7.4.150.0100.01417.40
7.4.140.0080.01017.86
7.4.130.0140.00316.71
7.4.120.0120.00816.79
7.4.110.0150.00616.68
7.4.100.0120.00616.87
7.4.90.0070.01016.63
7.4.80.0090.01519.39
7.4.70.0060.01116.71
7.4.60.0130.00316.73
7.4.50.0000.00416.77
7.4.40.0100.00716.69
7.4.30.0070.01016.79
7.4.00.0000.01515.07
7.3.330.0050.00013.47
7.3.320.0000.00613.56
7.3.310.0000.00716.54
7.3.300.0040.00416.53
7.3.290.0070.00716.58
7.3.280.0100.00616.58
7.3.270.0100.01617.40
7.3.260.0070.01116.57
7.3.250.0140.00716.59
7.3.240.0070.01116.60
7.3.230.0090.00916.58
7.3.210.0080.00816.67
7.3.200.0100.00619.39
7.3.190.0100.00716.63
7.3.180.0080.00816.55
7.3.170.0070.01016.63
7.3.160.0070.01416.75
7.3.120.0030.01315.07
7.3.10.0030.01016.29
7.3.00.0090.00916.41
7.2.330.0130.01016.67
7.2.320.0060.01216.66
7.2.310.0070.01116.96
7.2.300.0070.01116.66
7.2.290.0110.00616.81
7.2.130.0070.00716.91
7.2.120.0090.00617.01
7.2.110.0080.00916.88
7.2.100.0100.00616.90
7.2.90.0060.00616.95
7.2.80.0100.00717.02
7.2.70.0100.01017.18
7.2.60.0000.01817.06
7.2.50.0120.00417.09
7.2.40.0090.00916.80
7.2.30.0040.01516.94
7.2.20.0110.00716.94
7.2.10.0110.01117.04
7.2.00.0090.00918.50
7.1.250.0070.01015.74
7.1.100.0030.00618.46
7.1.70.0000.01017.29
7.1.60.0110.01419.70
7.1.50.0070.01816.82
7.1.00.0070.07322.35
7.0.200.0050.00316.62
7.0.140.0070.07021.96
7.0.60.0130.08019.91
7.0.50.0070.07718.01
7.0.40.0030.05020.07
7.0.30.0200.04020.13
7.0.20.0330.07020.11
7.0.10.0330.08320.14
7.0.00.0030.04020.18
5.6.280.0030.07020.96
5.6.210.0000.04320.63
5.6.200.0070.08318.25
5.6.190.0030.04720.46
5.6.180.0070.06720.47
5.6.170.0300.08020.62
5.6.160.0070.03720.46
5.6.150.0070.07718.18
5.6.140.0100.04018.18
5.6.130.0070.08318.16
5.6.120.0170.07320.98
5.6.110.0130.07720.99
5.6.100.0100.06021.04
5.6.90.0000.04321.02
5.6.80.0130.07020.53
5.6.70.0300.07320.52
5.5.350.0030.07320.45
5.5.340.0100.06317.95
5.5.330.0030.04720.53
5.5.320.0400.05020.27
5.5.310.0200.03320.32
5.5.300.0030.09017.95
5.5.290.0030.04717.98
5.5.280.0130.08020.79
5.5.270.0130.06320.88
5.5.260.0030.05320.79
5.5.250.0100.06720.73
5.5.240.0070.06020.39
5.4.450.0230.04719.42
5.4.440.0270.03719.38
5.4.430.0200.04019.49
5.4.420.0200.04719.20
5.4.410.0270.05019.29
5.4.400.0230.03718.98
5.4.390.0200.04718.84
5.4.380.0200.03718.95
5.4.370.0130.06718.95
5.4.360.0170.04019.07
5.4.350.0170.04018.88
5.4.340.0070.07718.84
5.4.320.0130.04318.98
5.4.310.0130.04019.15
5.4.300.0170.03719.16
5.4.290.0200.03719.21
5.4.280.0170.04019.26
5.4.270.0170.03718.98
5.4.260.0200.03319.06
5.4.250.0170.06318.97
5.4.240.0200.03319.08
5.4.230.0300.04019.21
5.4.220.0200.07018.97
5.4.210.0200.04719.04
5.4.200.0130.05018.82
5.4.190.0300.03319.21
5.4.180.0230.07019.05
5.4.170.0230.07018.94
5.4.160.0330.06019.13
5.4.150.0200.04719.20
5.4.140.0200.04716.36
5.4.130.0270.06316.38
5.4.120.0200.06716.56
5.4.110.0270.06016.58
5.4.100.0200.04716.45
5.4.90.0170.04316.32
5.4.80.0330.05316.44
5.4.70.0400.07016.57
5.4.60.0230.04016.38
5.4.50.0100.06716.54
5.4.40.0200.03316.54
5.4.30.0270.05316.49
5.4.20.0230.05316.54
5.4.10.0270.07016.34
5.4.00.0170.05315.84
5.3.290.0200.06714.67
5.3.280.0230.04014.56
5.3.270.0200.03714.61
5.3.260.0200.08014.51
5.3.250.0230.03714.57
5.3.240.0300.06314.68
5.3.230.0370.05714.57
5.3.220.0430.06714.54
5.3.210.0230.07014.48
5.3.200.0300.03014.57
5.3.190.0170.07714.62
5.3.180.0230.03714.64
5.3.170.0200.04314.72
5.3.160.0230.04314.64
5.3.150.0170.05014.46
5.3.140.0100.04714.45
5.3.130.0200.06314.56
5.3.120.0070.03314.45
5.3.110.0030.07314.54
5.3.100.0100.07314.12
5.3.90.1400.05014.14
5.3.80.2270.04713.99
5.3.70.2270.04313.94
5.3.60.2330.03713.91
5.3.50.2170.04714.17
5.3.40.2300.03713.87
5.3.30.2230.04314.05
5.3.20.2230.04313.81
5.3.10.2270.03713.56
5.3.00.2200.03713.55
5.2.170.1970.03711.13
5.2.160.1870.02711.22
5.2.150.2030.03311.13
5.2.140.1800.02711.06
5.2.130.1930.02711.02
5.2.120.1670.02711.02
5.2.110.1930.02711.16
5.2.100.2000.03011.22
5.2.90.2030.02311.16
5.2.80.2100.03011.01
5.2.70.1930.03311.11
5.2.60.2030.03011.17
5.2.50.1500.03310.93
5.2.40.1500.02311.12
5.2.30.1470.03010.88
5.2.20.1500.02711.11
5.2.10.1070.02710.98
5.2.00.1500.02710.68
5.1.60.1430.0239.94
5.1.50.1530.03010.17
5.1.40.1700.0309.88
5.1.30.1500.02710.45
5.1.20.1800.02710.27
5.1.10.1430.03010.07
5.1.00.1630.02710.23
5.0.50.0830.0308.53
5.0.40.0770.0178.54
5.0.30.0700.0338.21
5.0.20.0870.0238.28
5.0.10.0770.0278.27
5.0.00.0930.0338.39
4.4.90.0870.0137.85
4.4.80.0530.0107.85
4.4.70.0000.0177.85
4.4.60.0030.0137.85
4.4.50.0000.0177.85
4.4.40.0000.0237.85
4.4.30.0000.0237.85
4.4.20.0030.0137.85
4.4.10.0030.0177.85
4.4.00.0000.0237.85
4.3.110.0070.0107.85
4.3.100.0000.0207.85
4.3.90.0370.0137.85
4.3.80.0700.0277.85
4.3.70.0930.0177.85
4.3.60.0730.0177.85
4.3.50.0700.0177.85
4.3.40.0700.0237.85
4.3.30.0430.0107.85
4.3.20.0400.0177.85
4.3.10.0430.0207.85
4.3.00.0400.0107.85

preferences:
68.39 ms | 401 KiB | 5 Q