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", 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.0090.00918.80
8.3.50.0070.01418.30
8.3.40.0090.00619.06
8.3.30.0060.00918.99
8.3.20.0060.00320.29
8.3.10.0040.00423.70
8.3.00.0040.00419.66
8.2.180.0160.00616.88
8.2.170.0110.00422.96
8.2.160.0030.01020.52
8.2.150.0000.00824.18
8.2.140.0080.00024.66
8.2.130.0000.00826.16
8.2.120.0050.00321.13
8.2.110.0060.00322.23
8.2.100.0090.00318.09
8.2.90.0030.00519.09
8.2.80.0040.00417.97
8.2.70.0060.00317.88
8.2.60.0000.00918.04
8.2.50.0000.00818.07
8.2.40.0080.00019.92
8.2.30.0000.00918.36
8.2.20.0050.00217.94
8.2.10.0000.00818.14
8.2.00.0000.00817.93
8.1.280.0100.00725.92
8.1.270.0060.00323.91
8.1.260.0040.00426.35
8.1.250.0070.00028.09
8.1.240.0060.00323.78
8.1.230.0040.00819.21
8.1.220.0050.00317.91
8.1.210.0040.00418.77
8.1.200.0070.00317.50
8.1.190.0000.00817.60
8.1.180.0050.00318.10
8.1.170.0040.00418.84
8.1.160.0060.00322.08
8.1.150.0040.00418.72
8.1.140.0000.00817.63
8.1.130.0030.00317.77
8.1.120.0000.00717.64
8.1.110.0030.00617.53
8.1.100.0000.00717.53
8.1.90.0040.00417.68
8.1.80.0000.00717.68
8.1.70.0000.00717.63
8.1.60.0040.00417.71
8.1.50.0070.00017.75
8.1.40.0000.00817.61
8.1.30.0030.00517.88
8.1.20.0000.00817.83
8.1.10.0040.00417.63
8.1.00.0000.01217.73
8.0.300.0000.00918.77
8.0.290.0000.00716.88
8.0.280.0040.00418.49
8.0.270.0000.00717.25
8.0.260.0000.00717.20
8.0.250.0030.00317.15
8.0.240.0030.00517.10
8.0.230.0030.00417.14
8.0.220.0060.00217.10
8.0.210.0000.00717.10
8.0.200.0080.00017.18
8.0.190.0070.00017.08
8.0.180.0050.00317.00
8.0.170.0080.00017.12
8.0.160.0000.00817.13
8.0.150.0040.00417.01
8.0.140.0040.00417.09
8.0.130.0000.00613.50
8.0.120.0030.00517.00
8.0.110.0000.00817.12
8.0.100.0080.00017.13
8.0.90.0000.00716.99
8.0.80.0150.00317.04
8.0.70.0040.00417.09
8.0.60.0040.00416.88
8.0.50.0040.00417.04
8.0.30.0120.01217.41
8.0.20.0050.01517.40
8.0.10.0000.00717.21
8.0.00.0090.00916.92
7.4.330.0030.00315.05
7.4.320.0030.00316.76
7.4.300.0070.00016.67
7.4.290.0070.00016.89
7.4.280.0040.00416.76
7.4.270.0060.00316.75
7.4.260.0040.00416.88
7.4.250.0040.00416.83
7.4.240.0020.00616.80
7.4.230.0040.00416.80
7.4.220.0120.01516.79
7.4.210.0040.01216.80
7.4.200.0000.00716.60
7.4.160.0280.01016.75
7.4.150.0130.00717.40
7.4.140.0100.00617.86
7.4.130.0110.00616.83
7.4.120.0110.01116.78
7.4.110.0080.01416.49
7.4.100.0150.00316.56
7.4.90.0080.01216.89
7.4.80.0100.00716.70
7.4.70.0160.00316.87
7.4.60.0120.01316.65
7.4.50.0090.00916.57
7.4.40.0060.01316.55
7.4.30.0120.00616.55
7.4.20.0100.01016.83
7.4.10.0120.00916.53
7.4.00.0100.00815.76
7.3.330.0050.00013.54
7.3.320.0000.00613.40
7.3.310.0000.00716.37
7.3.300.0070.00016.59
7.3.290.0040.01216.57
7.3.280.0110.00816.60
7.3.270.0160.00317.40
7.3.260.0060.01216.81
7.3.250.0100.00816.83
7.3.240.0060.01016.79
7.3.230.0100.00716.78
7.3.210.0180.00016.56
7.3.200.0100.01119.39
7.3.190.0150.00716.52
7.3.180.0150.01216.86
7.3.170.0150.00416.87
7.3.160.0130.00716.42
7.3.150.0090.00916.68
7.3.140.0070.01316.84
7.3.130.0060.01216.76
7.3.120.0030.01215.94
7.3.110.0090.00916.75
7.3.100.0080.00816.67
7.3.90.0110.00716.75
7.3.80.0040.01316.73
7.3.70.0060.01216.73
7.3.60.0060.01016.57
7.3.50.0070.01016.50
7.3.40.0090.00916.49
7.3.30.0130.00416.55
7.3.20.0000.01916.66
7.3.10.0120.00816.60
7.3.00.0120.00616.74
7.2.330.0040.01516.88
7.2.320.0090.01216.79
7.2.310.0150.01216.67
7.2.300.0060.01316.61
7.2.290.0080.01116.80
7.2.280.0070.01116.86
7.2.270.0030.01716.91
7.2.260.0100.00716.84
7.2.250.0090.00916.70
7.2.240.0080.00817.02
7.2.230.0180.00016.84
7.2.220.0110.00716.79
7.2.210.0110.00716.71
7.2.200.0140.00717.00
7.2.190.0140.00716.80
7.2.180.0110.00716.97
7.2.170.0070.01316.82
7.2.160.0150.00316.78
7.2.150.0130.00616.87
7.2.140.0070.01316.81
7.2.130.0130.00717.03
7.2.120.0030.01716.93
7.2.110.0110.00716.89
7.2.100.0170.00816.95
7.2.90.0100.01316.79
7.2.80.0140.01016.82
7.2.70.0080.01416.86
7.2.60.0110.01416.77
7.2.50.0140.00916.87
7.2.40.0030.01616.87
7.2.30.0160.00816.71
7.2.20.0120.01616.81
7.2.10.0120.00816.79
7.2.00.0060.01118.36
7.1.330.0170.01015.74
7.1.320.0260.00315.90
7.1.310.0420.01015.87
7.1.300.0100.01715.68
7.1.290.0190.01215.81
7.1.280.0240.00515.78
7.1.270.0250.00415.82
7.1.260.0220.00915.68
7.1.250.0270.00915.80
7.1.240.0200.00815.72
7.1.230.0480.00715.88
7.1.220.0220.00915.93
7.1.210.0240.00815.79
7.1.200.0210.01315.80
7.1.190.0230.00915.66
7.1.180.0230.00715.63
7.1.170.0210.00915.66
7.1.160.0250.00415.66
7.1.150.0180.01815.94
7.1.140.0230.01015.86
7.1.130.0240.01215.73
7.1.120.0200.01215.74
7.1.110.0250.01015.89
7.1.100.0090.01417.11
7.1.90.0200.01215.88
7.1.80.0250.01115.96
7.1.70.0110.01016.63
7.1.60.0130.00916.68
7.1.50.0150.01216.38
7.1.40.0220.01415.92
7.1.30.0220.01115.75
7.1.20.0370.00815.91
7.1.10.0250.00615.82
7.1.00.0120.04119.05
7.0.330.0170.01115.45
7.0.320.0310.00315.48
7.0.310.0260.00315.53
7.0.300.0120.01515.59
7.0.290.0400.01315.61
7.0.280.0410.00315.61
7.0.270.0250.00715.52
7.0.260.0160.01415.59
7.0.250.0230.00615.36
7.0.240.0300.00415.46
7.0.230.0060.02415.46
7.0.220.0220.00715.67
7.0.210.0270.01015.32
7.0.200.0160.00616.23
7.0.190.0240.00615.50
7.0.180.0240.00715.50
7.0.170.0150.01415.56
7.0.160.0220.01115.49
7.0.150.0240.00415.58
7.0.140.0110.04218.76
7.0.130.0230.00815.53
7.0.120.0190.01115.53
7.0.110.0220.00915.60
7.0.100.0110.02115.48
7.0.90.0100.02315.40
7.0.80.0200.01215.49
7.0.70.0220.01015.44
7.0.60.0160.04317.84
7.0.50.0090.02516.64
7.0.40.0140.02317.84
7.0.30.0280.04117.89
7.0.20.0330.03517.70
7.0.10.0110.04317.83
7.0.00.0170.02317.95
5.6.400.0270.00316.25
5.6.390.0230.00616.37
5.6.380.0210.01516.23
5.6.370.0180.01216.15
5.6.360.0200.01516.32
5.6.350.0240.00715.98
5.6.340.0190.01916.02
5.6.330.0180.01516.20
5.6.320.0170.01715.81
5.6.310.0270.00716.43
5.6.300.0140.01816.30
5.6.290.0210.01115.98
5.6.280.0100.04218.78
5.6.270.0240.00716.36
5.6.260.0240.00716.24
5.6.250.0170.01316.30
5.6.240.0210.00816.21
5.6.230.0220.01116.30
5.6.220.0320.00016.36
5.6.210.0080.02818.42
5.6.200.0100.04617.11
5.6.190.0170.04318.37
5.6.180.0170.02918.29
5.6.170.0250.02218.35
5.6.160.0190.04218.40
5.6.150.0250.01717.07
5.6.140.0100.05017.14
5.6.130.0130.04617.29
5.6.120.0170.03118.55
5.6.110.0190.03818.55
5.6.100.0150.04518.52
5.6.90.0120.04818.62
5.6.80.0120.04618.23
5.6.70.0160.01216.02
5.6.60.0200.01315.90
5.6.50.0140.01315.99
5.6.40.0070.01715.63
5.6.30.0260.00316.33
5.6.20.0210.00916.18
5.6.10.0200.00916.27
5.6.00.0130.01715.98
5.5.380.0260.00716.30
5.5.370.0230.01415.92
5.5.360.0200.01216.41
5.5.350.0180.04818.26
5.5.340.0180.04117.02
5.5.330.0200.03618.21
5.5.320.0210.04218.19
5.5.310.0180.02518.25
5.5.300.0130.03017.07
5.5.290.0150.03217.09
5.5.280.0130.04118.54
5.5.270.0180.02918.56
5.5.260.0170.04318.58
5.5.250.0140.03918.30
5.5.240.0140.03818.05
5.5.230.0190.01116.16
5.5.220.0180.01116.01
5.5.210.0200.01215.99
5.5.200.0270.00815.89
5.5.190.0260.00616.03
5.5.180.0120.01516.16
5.5.170.0240.00516.04
5.5.160.0250.01116.05
5.5.150.0130.01615.87
5.5.140.0110.01415.88
5.5.130.0230.00816.00
5.5.120.0150.01516.03
5.5.110.0140.01516.11
5.5.100.0220.01116.00
5.5.90.0140.01716.08
5.5.80.0190.01215.86
5.5.70.0180.01216.02
5.5.60.0260.01116.11
5.5.50.0190.01015.93
5.5.40.0160.01315.98
5.5.30.0180.01116.01
5.5.20.0210.01215.84
5.5.10.0230.01216.00
5.5.00.0170.01715.81
5.4.450.0310.02116.29
5.4.440.0270.02628.41
5.4.430.0280.02728.44
5.4.420.0080.03028.37
5.4.410.0260.02428.47
5.4.400.0240.02228.39
5.4.390.0250.02828.39
5.4.380.0210.03615.84
5.4.370.0260.02915.82
5.4.360.0260.02615.79
5.4.350.0300.03015.71
5.4.340.0300.04115.93
5.4.330.0130.01012.81
5.4.320.0160.02312.67
5.4.310.0120.02412.71
5.4.300.0110.02212.76
5.4.290.0120.02412.78
5.4.280.0090.02712.57
5.4.270.0110.02212.67
5.4.260.0100.02412.72
5.4.250.0120.02412.78
5.4.240.0120.02112.54
5.4.230.0100.02512.69
5.4.220.0110.02212.66
5.4.210.0100.02212.67
5.4.200.0150.02112.65
5.4.190.0130.02012.64
5.4.180.0100.02212.64
5.4.170.0150.01912.60
5.4.160.0100.02612.73
5.4.150.0090.02512.69
5.4.140.0140.02112.48
5.4.130.0120.02412.37
5.4.120.0110.02312.57
5.4.110.0160.01812.41
5.4.100.0110.02612.48
5.4.90.0160.02012.44
5.4.80.0110.02312.48
5.4.70.0110.02612.49
5.4.60.0110.02012.53
5.4.50.0160.01912.47
5.4.40.0130.02212.40
5.4.30.0070.02612.55
5.4.20.0080.02312.51
5.4.10.0130.02112.53
5.4.00.0110.02312.17
5.3.290.0140.02512.82
5.3.280.0130.02612.72
5.3.270.0110.02412.86
5.3.260.0130.02412.75
5.3.250.0140.02412.76
5.3.240.0090.02512.80
5.3.230.0140.02312.75
5.3.220.0080.02712.69
5.3.210.0130.02612.81
5.3.200.0120.02112.70
5.3.190.0120.02312.73
5.3.180.0120.02112.79
5.3.170.0120.02412.75
5.3.160.0130.01912.80
5.3.150.0080.03012.79
5.3.140.0050.02812.75
5.3.130.0190.02012.73
5.3.120.0160.02112.71
5.3.110.0090.02712.72
5.3.100.0110.02312.43
5.3.90.0120.02112.51
5.3.80.0070.02512.44
5.3.70.0100.02212.45
5.3.60.0110.02212.46
5.3.50.0090.02512.41
5.3.40.0120.02112.37
5.3.30.0130.02112.34
5.3.20.0140.01812.23
5.3.10.0130.02112.10
5.3.00.0090.02312.15
5.2.170.0110.01710.55
5.2.160.0060.02310.49
5.2.150.0090.01810.54
5.2.140.0060.02010.56
5.2.130.0100.02610.48
5.2.120.0110.01910.50
5.2.110.0070.02210.46
5.2.100.0080.02110.45
5.2.90.0090.02010.47
5.2.80.0130.01710.43
5.2.70.0100.01710.46
5.2.60.0050.02210.41
5.2.50.0090.02410.44
5.2.40.0110.01810.40
5.2.30.0070.02010.39
5.2.20.0060.02310.42
5.2.10.0070.02110.23
5.2.00.0090.02410.12
5.1.60.0090.0179.44
5.1.50.0150.0149.45
5.1.40.0060.0169.61
5.1.30.0090.0169.73
5.1.20.0080.0169.64
5.1.10.0110.0159.57
5.1.00.0100.0149.43
5.0.50.0080.0138.39
5.0.40.0070.0158.32
5.0.30.0050.0208.18
5.0.20.0080.0118.18
5.0.10.0080.0108.15
5.0.00.0070.0188.15
4.4.90.0080.0087.41
4.4.80.0070.0127.40
4.4.70.0070.0097.40
4.4.60.0060.0097.40
4.4.50.0050.0097.41
4.4.40.0050.0137.38
4.4.30.0050.0127.40
4.4.20.0030.0127.45
4.4.10.0050.0117.44
4.4.00.0030.0167.40
4.3.110.0060.0097.36
4.3.100.0040.0107.36
4.3.90.0050.0097.34
4.3.80.0060.0157.31
4.3.70.0060.0097.34
4.3.60.0030.0117.33
4.3.50.0030.0117.33
4.3.40.0030.0157.29
4.3.30.0040.0106.67
4.3.20.0030.0136.66
4.3.10.0010.0146.64
4.3.00.0200.00826.96

preferences:
61 ms | 400 KiB | 5 Q