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]): $args[0] .= 'i'; $query .= '?'; $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.70.0070.00717.11
8.3.60.0120.00318.68
8.3.50.0230.00422.11
8.3.40.0070.00719.07
8.3.30.0070.00719.21
8.3.20.0100.00720.20
8.3.10.0080.00023.71
8.3.00.0030.00519.81
8.2.180.0130.00716.88
8.2.170.0140.00022.96
8.2.160.0140.00020.39
8.2.150.0040.00424.18
8.2.140.0040.00424.66
8.2.130.0040.00426.16
8.2.120.0040.00421.05
8.2.110.0060.00322.38
8.2.100.0080.00317.91
8.2.90.0080.00019.35
8.2.80.0090.00018.00
8.2.70.0080.00017.88
8.2.60.0030.00517.80
8.2.50.0060.00318.07
8.2.40.0000.00820.07
8.2.30.0080.00018.25
8.2.20.0000.00817.88
8.2.10.0000.00818.17
8.2.00.0030.00617.88
8.1.280.0070.00725.92
8.1.270.0040.00423.92
8.1.260.0080.00026.35
8.1.250.0080.00028.09
8.1.240.0060.00323.91
8.1.230.0030.00719.07
8.1.220.0000.00817.78
8.1.210.0030.00518.77
8.1.200.0030.00717.60
8.1.190.0000.00817.48
8.1.180.0000.00818.10
8.1.170.0090.00018.74
8.1.160.0080.00322.04
8.1.150.0000.00818.75
8.1.140.0030.00517.64
8.1.130.0070.00017.93
8.1.120.0000.00817.55
8.1.110.0080.00017.68
8.1.100.0070.00017.53
8.1.90.0080.00017.63
8.1.80.0000.00717.53
8.1.70.0050.00217.59
8.1.60.0080.00017.84
8.1.50.0040.00417.74
8.1.40.0030.00517.69
8.1.30.0030.00517.90
8.1.20.0050.00317.77
8.1.10.0060.00317.69
8.1.00.0050.00517.67
8.0.300.0060.00318.77
8.0.290.0060.00316.88
8.0.280.0060.00318.51
8.0.270.0000.00717.23
8.0.260.0040.00417.19
8.0.250.0040.00417.10
8.0.240.0000.00717.20
8.0.230.0030.00317.11
8.0.220.0000.00817.18
8.0.210.0030.00317.18
8.0.200.0030.00517.06
8.0.190.0000.00817.19
8.0.180.0050.00217.20
8.0.170.0080.00017.16
8.0.160.0060.00317.14
8.0.150.0040.00417.16
8.0.140.0040.00417.08
8.0.130.0030.00313.55
8.0.120.0000.00817.01
8.0.110.0030.00517.05
8.0.100.0040.00416.99
8.0.90.0060.00317.09
8.0.80.0090.00617.20
8.0.70.0000.00717.11
8.0.60.0020.00517.17
8.0.50.0000.00816.92
8.0.30.0060.01517.20
8.0.20.0100.00817.40
8.0.10.0050.00317.31
8.0.00.0130.00516.91
7.4.330.0030.00315.03
7.4.320.0030.00316.69
7.4.300.0030.00316.79
7.4.290.0030.00316.74
7.4.280.0030.00516.74
7.4.270.0000.00716.84
7.4.260.0000.00716.69
7.4.250.0000.00816.61
7.4.240.0020.00516.88
7.4.230.0040.00416.66
7.4.220.0090.00916.96
7.4.210.0090.00616.81
7.4.200.0000.00716.64
7.4.160.0170.00016.67
7.4.150.0150.00317.40
7.4.140.0070.01017.86
7.4.130.0110.00616.89
7.4.120.0110.00916.94
7.4.110.0070.01416.81
7.4.100.0180.00616.90
7.4.90.0070.01116.94
7.4.80.0040.01519.39
7.4.70.0110.00816.55
7.4.60.0110.01116.85
7.4.50.0000.00816.74
7.4.40.0170.00316.71
7.4.30.0080.00816.84
7.4.00.0070.01015.22
7.3.330.0000.00513.60
7.3.320.0030.00313.63
7.3.310.0040.00416.67
7.3.300.0000.00716.58
7.3.290.0040.01116.59
7.3.280.0070.01016.61
7.3.270.0070.01017.40
7.3.260.0100.01316.67
7.3.250.0080.01116.67
7.3.240.0140.00416.62
7.3.230.0080.00916.71
7.3.210.0150.00316.71
7.3.200.0070.01019.39
7.3.190.0090.00916.68
7.3.180.0110.00516.55
7.3.170.0150.00316.71
7.3.160.0060.01116.65
7.3.120.0040.01215.25
7.3.110.0100.00715.14
7.3.100.0090.00615.14
7.3.90.0080.00315.02
7.3.80.0070.00715.07
7.3.70.0060.00615.09
7.3.60.0000.01414.99
7.3.50.0040.01414.88
7.3.40.0060.00915.09
7.3.30.0110.00415.16
7.3.20.0060.00916.59
7.3.10.0060.00916.89
7.3.00.0040.00716.81
7.2.330.0140.00416.92
7.2.320.0080.02016.99
7.2.310.0110.00616.88
7.2.300.0040.01316.89
7.2.290.0100.00716.90
7.2.240.0040.01114.96
7.2.230.0000.01515.50
7.2.220.0120.00315.19
7.2.210.0060.01215.07
7.2.200.0090.00915.20
7.2.190.0090.00615.41
7.2.180.0060.00615.38
7.2.170.0060.01215.11
7.2.160.0070.00715.20
7.2.150.0150.00316.98
7.2.140.0060.01217.18
7.2.130.0040.01117.11
7.2.120.0030.01217.21
7.2.110.0060.00917.12
7.2.100.0030.00917.19
7.2.90.0060.00917.31
7.2.80.0040.01117.31
7.2.70.0030.01417.31
7.2.60.0080.00417.20
7.2.50.0110.00717.14
7.2.40.0070.00717.15
7.2.30.0040.00717.31
7.2.20.0000.01517.10
7.2.10.0040.00716.98
7.2.00.0100.00718.20
7.1.330.0110.00716.00
7.1.320.0110.00716.19
7.1.310.0110.00016.13
7.1.300.0030.01215.97
7.1.290.0050.00515.94
7.1.280.0000.01015.81
7.1.270.0060.00916.17
7.1.260.0030.01215.91
7.1.250.0050.00515.98
7.1.200.0000.01516.04
7.1.100.0070.00716.51
7.1.70.0000.01017.58
7.1.60.0060.01619.70
7.1.50.0140.00717.24
7.1.00.0000.08022.45
7.0.200.0060.00616.73
7.0.140.0000.07321.99
7.0.60.0030.06319.88
7.0.50.0100.05017.91
7.0.40.0070.04020.11
7.0.30.0270.04320.19
7.0.20.0300.06720.32
7.0.10.0100.05320.35
7.0.00.0070.04720.22
5.6.280.0070.07320.88
5.6.210.0070.03720.78
5.6.200.0000.04318.29
5.6.190.0030.07020.68
5.6.180.3330.05020.67
5.6.170.0270.05720.62
5.6.160.0130.08720.41
5.6.150.0030.06718.20
5.6.140.0070.08018.14
5.6.130.0030.04018.15
5.6.120.0000.08321.14
5.6.110.0070.08321.15
5.6.100.0030.08020.98
5.6.90.0000.05021.02
5.6.80.0100.07720.38
5.6.70.4430.04320.39
5.5.350.0130.07720.48
5.5.340.0070.08017.96
5.5.330.0030.05020.32
5.5.320.0330.07320.35
5.5.310.0330.06720.41
5.5.300.0070.03717.95
5.5.290.0070.06717.97
5.5.280.0000.04320.98
5.5.270.0030.08320.75
5.5.260.0100.04020.77
5.5.250.0070.06320.76
5.5.240.0200.07720.17
5.4.450.0270.05319.53
5.4.440.0900.03719.57
5.4.430.0170.04743.92
5.4.420.0100.05043.91
5.4.410.0200.05043.90
5.4.400.0500.03343.90
5.4.390.0170.05043.89
5.4.380.0170.05718.77
5.4.370.0130.05318.75
5.4.360.0170.05718.49
5.4.350.0100.06018.73
5.4.340.0100.05318.75
5.4.320.0090.03812.53
5.4.310.0060.03712.53
5.4.300.0040.04312.52
5.4.290.0050.04012.52
5.4.280.0070.03512.41
5.4.270.0100.03612.41
5.4.260.0070.03812.42
5.4.250.0050.04012.42
5.4.240.0080.03812.41
5.4.230.0060.03812.41
5.4.220.0070.03912.41
5.4.210.0090.03612.41
5.4.200.0050.03912.41
5.4.190.0090.03412.41
5.4.180.0080.04712.41
5.4.170.0080.03712.42
5.4.160.0070.03612.41
5.4.150.0060.03912.41
5.4.140.0070.03712.09
5.4.130.0100.03312.09
5.4.120.0040.03912.04
5.4.110.0090.03312.04
5.4.100.0080.03412.04
5.4.90.0060.04912.04
5.4.80.0070.04312.04
5.4.70.0070.03712.04
5.4.60.0040.05312.03
5.4.50.0070.04912.03
5.4.40.0060.03712.02
5.4.30.0020.04312.02
5.4.20.0080.03812.02
5.4.10.0090.04612.02
5.4.00.0050.04211.51
5.3.290.0110.04112.80
5.3.280.0060.03912.71
5.3.270.0070.03812.72
5.3.260.0060.03912.72
5.3.250.0070.03712.72
5.3.240.0090.03412.71
5.3.230.0080.03612.71
5.3.220.0070.03912.68
5.3.210.0070.03812.68
5.3.200.0110.03112.68
5.3.190.0050.03912.68
5.3.180.0070.04212.67
5.3.170.0080.03912.66
5.3.160.0050.04012.67
5.3.150.0080.03712.67
5.3.140.0030.04012.66
5.3.130.0030.04212.66
5.3.120.0050.04112.66
5.3.110.0050.04412.66
5.3.100.0060.04312.12
5.3.90.0060.04312.11
5.3.80.0080.03712.10
5.3.70.0110.03112.09
5.3.60.0040.03912.08
5.3.50.0060.03812.03
5.3.40.0080.03612.03
5.3.30.0080.03811.98
5.3.20.0070.03711.77
5.3.10.0070.03311.73
5.3.00.0080.03511.72
5.2.170.0040.0349.23
5.2.160.0050.0319.23
5.2.150.0040.0359.23
5.2.140.0030.0339.22
5.2.130.0060.0329.18
5.2.120.0060.0289.18
5.2.110.0060.0339.19
5.2.100.0070.0279.18
5.2.90.0050.0299.18
5.2.80.0060.0309.18
5.2.70.0060.0309.18
5.2.60.0050.0319.13
5.2.50.0030.0339.10
5.2.40.0060.0299.08
5.2.30.0000.0369.05
5.2.20.0050.0309.04
5.2.10.0060.0298.95
5.2.00.0060.0288.81
5.1.60.0050.0248.10
5.1.50.0060.0238.09
5.1.40.0040.0258.07
5.1.30.0090.0218.42
5.1.20.0030.0288.45
5.1.10.0060.0248.18
5.1.00.0060.0238.18
5.0.50.0030.0206.66
5.0.40.0040.0186.51
5.0.30.0010.0336.33
5.0.20.0040.0196.28
5.0.10.0080.0156.26
5.0.00.0050.0346.25
4.4.90.0020.0164.78
4.4.80.0050.0174.75
4.4.70.0020.0184.75
4.4.60.0020.0174.75
4.4.50.0020.0214.77
4.4.40.0040.0304.71
4.4.30.0050.0124.76
4.4.20.0020.0164.84
4.4.10.0030.0154.85
4.4.00.0010.0264.76
4.3.110.0030.0154.67
4.3.100.0050.0124.67
4.3.90.0040.0134.63
4.3.80.0040.0244.58
4.3.70.0020.0154.63
4.3.60.0030.0144.63
4.3.50.0030.0154.63
4.3.40.0030.0234.54
4.3.30.0000.0183.30
4.3.20.0010.0203.28
4.3.10.0020.0183.23
4.3.00.0070.01743.87

preferences:
38.7 ms | 401 KiB | 5 Q