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.0120.00318.56
8.3.50.0070.01022.20
8.3.40.0070.00719.14
8.3.30.0070.00719.27
8.3.20.0060.00320.14
8.3.10.0000.00823.53
8.3.00.0080.00019.81
8.2.180.0190.00016.63
8.2.170.0000.01522.96
8.2.160.0140.00020.34
8.2.150.0040.00424.18
8.2.140.0060.00324.66
8.2.130.0030.00526.16
8.2.120.0080.00021.20
8.2.110.0030.00622.20
8.2.100.0080.00418.00
8.2.90.0030.00519.35
8.2.80.0030.00717.97
8.2.70.0040.00417.75
8.2.60.0090.00018.04
8.2.50.0060.00318.07
8.2.40.0040.00420.07
8.2.30.0000.00818.44
8.2.20.0050.00317.83
8.2.10.0000.00818.23
8.2.00.0050.00317.84
8.1.280.0070.01025.92
8.1.270.0050.00323.96
8.1.260.0040.00426.35
8.1.250.0050.00328.09
8.1.240.0090.00023.90
8.1.230.0050.00519.10
8.1.220.0050.00317.79
8.1.210.0030.00618.77
8.1.200.0050.00517.48
8.1.190.0030.00617.48
8.1.180.0000.00918.10
8.1.170.0000.00818.75
8.1.160.0040.00421.98
8.1.150.0040.00418.72
8.1.140.0050.00317.55
8.1.130.0070.00017.81
8.1.120.0000.00817.54
8.1.110.0080.00017.66
8.1.100.0040.00417.55
8.1.90.0030.00517.63
8.1.80.0040.00417.64
8.1.70.0000.00717.54
8.1.60.0000.00917.77
8.1.50.0000.00817.68
8.1.40.0080.00017.73
8.1.30.0080.00017.72
8.1.20.0040.00417.75
8.1.10.0080.00017.75
8.1.00.0070.00317.59
8.0.300.0000.00718.77
8.0.290.0060.00316.88
8.0.280.0030.00518.43
8.0.270.0000.00817.32
8.0.260.0000.00718.42
8.0.250.0080.00017.05
8.0.240.0030.00317.05
8.0.230.0000.00717.05
8.0.220.0060.00317.10
8.0.210.0030.00316.92
8.0.200.0000.01017.19
8.0.190.0030.00517.14
8.0.180.0040.00417.08
8.0.170.0000.00817.02
8.0.160.0050.00217.14
8.0.150.0040.00417.06
8.0.140.0000.00816.95
8.0.130.0000.00613.47
8.0.120.0040.00417.00
8.0.110.0050.00317.13
8.0.100.0040.00416.97
8.0.90.0050.00316.95
8.0.80.0080.00817.04
8.0.70.0040.00417.12
8.0.60.0000.00817.07
8.0.50.0000.00817.07
8.0.30.0120.00817.39
8.0.20.0130.00617.40
8.0.10.0050.00317.02
8.0.00.0060.01317.04
7.4.330.0030.00315.23
7.4.320.0030.00316.76
7.4.300.0030.00316.73
7.4.290.0070.00016.75
7.4.280.0040.00416.76
7.4.270.0050.00316.83
7.4.260.0040.00416.73
7.4.250.0000.00916.73
7.4.240.0070.00016.83
7.4.230.0040.00416.94
7.4.220.0070.01116.91
7.4.210.0090.00516.94
7.4.200.0000.00716.96
7.4.160.0040.01216.53
7.4.150.0080.00817.40
7.4.140.0130.00617.86
7.4.130.0120.00516.69
7.4.120.0110.00716.77
7.4.110.0090.00916.82
7.4.100.0060.01216.65
7.4.90.0060.01216.82
7.4.80.0030.01519.39
7.4.70.0090.00616.85
7.4.60.0070.01016.73
7.4.50.0020.00216.79
7.4.40.0120.00416.82
7.4.30.0130.00316.76
7.4.10.0070.01015.12
7.4.00.0060.01115.29
7.3.330.0030.00313.57
7.3.320.0030.00313.41
7.3.310.0000.00816.66
7.3.300.0030.00316.43
7.3.290.0060.00916.54
7.3.280.0110.00916.56
7.3.270.0100.00717.40
7.3.260.0130.01216.79
7.3.250.0070.01016.71
7.3.240.0140.00316.87
7.3.230.0130.00616.85
7.3.210.0150.00416.48
7.3.200.0100.01019.39
7.3.190.0070.01016.81
7.3.180.0080.00816.79
7.3.170.0120.00616.62
7.3.160.0040.01216.73
7.3.130.0100.00715.37
7.3.120.0040.01215.27
7.3.110.0030.01615.15
7.3.100.0040.00815.32
7.3.90.0090.00915.18
7.3.80.0060.00615.34
7.3.70.0070.00414.91
7.3.60.0090.00314.91
7.3.50.0000.01415.03
7.3.40.0080.00314.95
7.3.30.0070.00415.13
7.3.20.0040.01116.99
7.3.10.0030.01017.06
7.3.00.0070.00716.68
7.2.330.0070.01116.99
7.2.320.0190.00017.00
7.2.310.0030.01417.01
7.2.300.0090.00917.02
7.2.290.0110.00617.04
7.2.260.0060.01315.34
7.2.250.0060.01215.19
7.2.240.0030.01015.34
7.2.230.0030.01415.29
7.2.220.0000.01515.43
7.2.210.0060.00315.37
7.2.200.0000.01114.91
7.2.190.0140.00415.06
7.2.180.0080.00415.24
7.2.170.0030.01015.12
7.2.160.0030.00715.30
7.2.150.0000.01117.23
7.2.140.0070.01017.02
7.2.130.0040.00817.04
7.2.120.0040.01117.02
7.2.110.0000.01417.06
7.2.100.0100.00717.04
7.2.90.0100.01017.25
7.2.80.0090.01017.05
7.2.70.0000.01617.40
7.2.60.0030.01417.28
7.2.50.0090.00617.34
7.2.40.0030.00717.29
7.2.30.0030.01317.13
7.2.20.0030.01316.90
7.2.10.0070.01017.21
7.2.00.0030.01017.18
7.1.330.0030.01315.98
7.1.320.0040.01115.75
7.1.310.0000.01415.89
7.1.300.0040.01115.81
7.1.290.0000.01115.79
7.1.280.0070.00716.06
7.1.270.0060.00915.62
7.1.260.0060.00915.92
7.1.250.0070.00716.13
7.1.240.0000.01016.02
7.1.230.0030.00915.76
7.1.220.0060.00916.13
7.1.210.0030.01016.05
7.1.200.0060.00915.95
7.1.190.0030.01015.95
7.1.180.0070.00716.03
7.1.170.0060.00616.15
7.1.160.0030.01416.06
7.1.150.0090.00616.01
7.1.140.0060.00615.93
7.1.130.0090.00616.02
7.1.120.0060.00616.10
7.1.110.0030.00916.02
7.1.100.0030.00817.28
7.1.90.0080.00816.13
7.1.80.0030.01015.95
7.1.70.0020.00916.68
7.1.60.0030.00916.48
7.1.50.0070.01016.59
7.1.40.0090.00016.05
7.1.30.0150.00016.12
7.1.20.0090.00415.99
7.1.10.0060.00616.00
7.1.00.0050.03919.17
7.0.330.0070.00715.73
7.0.320.0030.00715.25
7.0.310.0000.01115.63
7.0.300.0070.00615.61
7.0.290.0130.00315.67
7.0.280.0130.00615.52
7.0.270.0070.01015.53
7.0.260.0090.00315.63
7.0.250.0060.00615.39
7.0.240.0060.00915.77
7.0.230.0000.01415.63
7.0.220.0000.00815.64
7.0.210.0060.00915.45
7.0.200.0100.00516.29
7.0.190.0040.01115.74
7.0.180.0120.00315.63
7.0.170.0030.01015.52
7.0.160.0060.00915.42
7.0.150.0060.00315.53
7.0.140.0030.04218.84
7.0.130.0110.00315.69
7.0.120.0060.01015.60
7.0.110.0030.00615.72
7.0.100.0030.00915.77
7.0.90.0120.00315.56
7.0.80.0030.01015.49
7.0.70.0030.01015.46
7.0.60.0180.03517.89
7.0.50.0020.03916.76
7.0.40.0110.02317.13
7.0.30.0100.02416.94
7.0.20.0190.02116.83
7.0.10.0200.03816.91
7.0.00.0050.03017.08
5.6.400.0030.00614.48
5.6.390.0000.01714.59
5.6.380.0100.00614.62
5.6.370.0070.00714.61
5.6.360.0030.01414.18
5.6.350.0070.00714.18
5.6.340.0060.01314.73
5.6.330.0100.00714.92
5.6.320.0030.01314.66
5.6.310.0060.00914.96
5.6.300.0090.00314.21
5.6.290.0060.00814.36
5.6.280.0020.04417.88
5.6.270.0030.00714.65
5.6.260.0070.00414.61
5.6.250.0110.00414.51
5.6.240.0110.00314.52
5.6.230.0090.00314.72
5.6.220.0000.01014.63
5.6.210.0060.04417.68
5.6.200.0020.05016.49
5.6.190.0090.04217.82
5.6.180.0060.02817.55
5.6.170.0250.03517.66
5.6.160.0050.05016.32
5.6.150.0060.04616.39
5.6.140.0100.04516.30
5.6.130.0030.02716.42
5.6.120.0080.04517.78
5.6.110.0030.03817.86
5.6.100.0120.03817.85
5.6.90.0070.04717.82
5.6.80.0130.02717.59
5.6.70.0030.00614.36
5.6.60.0030.01014.65
5.6.50.0030.01514.28
5.6.40.0100.00314.52
5.6.30.0030.00614.19
5.6.20.0090.00314.58
5.6.10.0130.00014.50
5.6.00.0030.01314.46
5.5.380.0040.00814.24
5.5.370.0040.01114.68
5.5.360.0070.00414.77
5.5.350.0110.04217.47
5.5.340.0080.02916.07
5.5.330.0030.03517.64
5.5.320.0200.04517.46
5.5.310.0090.02417.34
5.5.300.0020.02616.33
5.5.290.0090.04316.16
5.5.280.0110.03917.79
5.5.270.0110.02517.83
5.5.260.0020.03517.55
5.5.250.0080.04717.37
5.5.240.0130.04017.27
5.5.230.0030.00914.37
5.5.220.0000.00914.64
5.5.210.0060.00614.46
5.5.200.0060.00614.32
5.5.190.0000.01314.52
5.5.180.0080.00014.44
5.5.170.0000.01514.62
5.5.160.0090.00314.41
5.5.150.0030.01014.37
5.5.140.0030.00714.27
5.5.130.0000.00914.58
5.5.120.0070.00714.32
5.5.110.0030.01114.39
5.5.100.0060.00314.67
5.5.90.0050.00814.63
5.5.80.0030.01314.39
5.5.70.0080.00314.24
5.5.60.0060.00914.40
5.5.50.0070.00714.27
5.5.40.0060.00614.58
5.5.30.0090.00414.44
5.5.20.0090.00014.29
5.5.10.0060.00914.57
5.5.00.0050.00514.50
5.4.450.0250.02515.34
5.4.440.0220.02827.83
5.4.430.0120.02727.71
5.4.420.0120.02427.71
5.4.410.0120.02227.65
5.4.400.0120.02527.63
5.4.390.0160.02527.52
5.4.380.0150.02514.97
5.4.370.0140.02914.93
5.4.360.0070.03015.05
5.4.350.0150.03114.95
5.4.340.0030.03214.94
5.4.330.0060.00611.18
5.4.320.0050.02011.83
5.4.310.0020.02511.97
5.4.300.0030.02311.80
5.4.290.0050.02312.01
5.4.280.0010.02511.77
5.4.270.0050.02711.90
5.4.260.0050.02011.77
5.4.250.0070.02411.74
5.4.240.0060.02211.80
5.4.230.0040.02611.84
5.4.220.0070.02111.97
5.4.210.0040.02211.86
5.4.200.0020.02611.91
5.4.190.0060.02011.86
5.4.180.0080.02111.95
5.4.170.0020.02511.74
5.4.160.0040.02011.88
5.4.150.0060.02211.76
5.4.140.0070.02011.58
5.4.130.0060.02211.76
5.4.120.0040.02411.65
5.4.110.0050.02211.64
5.4.100.0030.02311.66
5.4.90.0090.01911.78
5.4.80.0050.02211.77
5.4.70.0060.01911.61
5.4.60.0070.02311.61
5.4.50.0070.02011.69
5.4.40.0040.02211.70
5.4.30.0050.02011.67
5.4.20.0040.02111.68
5.4.10.0060.02011.68
5.4.00.0040.02211.46
5.3.290.0040.02611.93
5.3.280.0060.02311.89
5.3.270.0050.02311.89
5.3.260.0020.02611.89
5.3.250.0050.02211.89
5.3.240.0050.02211.89
5.3.230.0080.02111.89
5.3.220.0040.02511.88
5.3.210.0080.02011.87
5.3.200.0050.02111.88
5.3.190.0070.02211.87
5.3.180.0050.02511.87
5.3.170.0020.02311.87
5.3.160.0030.02511.87
5.3.150.0060.02211.87
5.3.140.0050.02111.86
5.3.130.0040.02211.86
5.3.120.0090.02411.86
5.3.110.0070.02311.86
5.3.100.0040.02011.59
5.3.90.0030.02211.58
5.3.80.0070.02011.58
5.3.70.0080.02111.58
5.3.60.0020.02111.57
5.3.50.0030.02311.55
5.3.40.0070.01911.55
5.3.30.0020.02111.53
5.3.20.0070.01911.42
5.3.10.0060.02011.40
5.3.00.0070.02311.39
5.2.170.0060.0299.23
5.2.160.0040.0379.23
5.2.150.0060.0319.23
5.2.140.0050.0359.22
5.2.130.0040.0299.18
5.2.120.0040.0289.19
5.2.110.0050.0289.20
5.2.100.0090.0259.18
5.2.90.0040.0309.18
5.2.80.0040.0319.18
5.2.70.0050.0299.17
5.2.60.0040.0339.13
5.2.50.0080.0279.11
5.2.40.0040.0299.08
5.2.30.0040.0309.05
5.2.20.0060.0279.04
5.2.10.0080.0378.95
5.2.00.0050.0318.81
5.1.60.0030.0298.09
5.1.50.0030.0308.09
5.1.40.0040.0258.08
5.1.30.0040.0308.41
5.1.20.0020.0318.45
5.1.10.0040.0268.17
5.1.00.0090.0258.17
5.0.50.0020.0216.65
5.0.40.0060.0176.50
5.0.30.0040.0336.32
5.0.20.0010.0276.28
5.0.10.0030.0196.26
5.0.00.0040.0336.25
4.4.90.0030.0154.78
4.4.80.0010.0194.75
4.4.70.0020.0164.75
4.4.60.0080.0164.75
4.4.50.0040.0184.77
4.4.40.0030.0254.71
4.4.30.0020.0164.76
4.4.20.0020.0174.84
4.4.10.0060.0174.84
4.4.00.0040.0254.76
4.3.110.0030.0164.67
4.3.100.0040.0184.67
4.3.90.0060.0124.63
4.3.80.0040.0244.59
4.3.70.0040.0154.63
4.3.60.0040.0154.63
4.3.50.0040.0184.63
4.3.40.0020.0284.54
4.3.30.0030.0173.30
4.3.20.0000.0223.28
4.3.10.0030.0153.23
4.3.00.0000.02043.87

preferences:
48.99 ms | 401 KiB | 5 Q