3v4l.org

run code in 300+ PHP versions simultaneously
<?php function pdo_named_in_clause_from_array($array, $name = 'in') { $in = $data = array(); $i = 0; $name = preg_replace('/[^a-z0-9_]+/', '', (string)$name); if (!preg_match('/^[a-z]/i', $name)) { throw new \InvalidArgumentException('Placeholder name ' . $name . ': must begin with a letter'); } foreach ($array as $value) { $key = $name . $i++; $in[] = ':' . $key; $data[$key] = $value; } return array(implode(', ', $in), $data); } $inList = [1, 2, 3]; list($inClause, $inData) = pdo_named_in_clause_from_array($inList); $query = "UPDATE table SET value1 = :val1, value2 = :val2, WHERE id IN ($inClause)"; $data = array('val1' => 'Hello', 'val2' => 'World') + $inData; var_dump($query, $data); /* $stmt = $db->prepare($query); $stmt->execute($data); */

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.0080.01218.58
8.3.50.0040.01116.63
8.3.40.0150.00319.07
8.3.30.0070.00719.13
8.3.20.0040.00420.39
8.3.10.0000.00723.66
8.3.00.0030.00519.50
8.2.180.0040.01116.88
8.2.170.0150.00022.96
8.2.160.0110.00720.39
8.2.150.0080.00024.18
8.2.140.0030.00524.66
8.2.130.0040.00426.16
8.2.120.0040.00422.37
8.2.110.0000.00920.41
8.2.100.0040.00718.09
8.2.90.0000.00819.25
8.2.80.0030.00618.00
8.2.70.0030.00617.88
8.2.60.0060.00618.03
8.2.50.0000.00818.07
8.2.40.0030.00520.06
8.2.30.0070.00018.15
8.2.20.0050.00317.93
8.2.10.0000.00718.29
8.2.00.0000.00718.04
8.1.280.0140.00325.92
8.1.270.0080.00022.24
8.1.260.0000.00726.35
8.1.250.0000.00828.09
8.1.240.0060.00323.91
8.1.230.0090.00318.98
8.1.220.0080.00017.79
8.1.210.0050.00318.77
8.1.200.0000.00917.47
8.1.190.0040.00417.36
8.1.180.0000.00818.10
8.1.170.0000.00818.63
8.1.160.0000.00722.05
8.1.150.0070.00018.86
8.1.140.0020.00517.53
8.1.130.0070.00019.55
8.1.120.0000.00717.63
8.1.110.0040.00417.66
8.1.100.0000.00717.64
8.1.90.0040.00417.65
8.1.80.0030.00317.60
8.1.70.0040.00417.60
8.1.60.0060.00317.81
8.1.50.0060.00317.62
8.1.40.0000.00817.57
8.1.30.0040.00417.76
8.1.20.0000.00917.87
8.1.10.0000.00817.75
8.1.00.0000.01017.67
8.0.300.0030.00618.77
8.0.290.0070.00016.88
8.0.280.0040.00418.37
8.0.270.0000.00717.27
8.0.260.0050.00317.22
8.0.250.0000.00717.07
8.0.240.0070.00017.20
8.0.230.0050.00217.23
8.0.220.0030.00317.13
8.0.210.0000.00717.02
8.0.200.0000.00717.27
8.0.190.0060.00317.25
8.0.180.0050.00517.19
8.0.170.0050.00317.13
8.0.160.0000.00717.14
8.0.150.0000.00717.20
8.0.140.0050.00317.08
8.0.130.0050.00313.55
8.0.120.0040.00417.14
8.0.110.0040.00417.04
8.0.100.0080.00017.03
8.0.90.0000.00817.12
8.0.80.0000.01617.04
8.0.70.0040.00417.02
8.0.60.0000.00717.00
8.0.50.0030.00516.99
8.0.30.0160.00817.30
8.0.20.0150.01217.40
8.0.10.0000.00917.24
8.0.00.0140.00516.94
7.4.330.0000.00615.02
7.4.320.0030.00616.73
7.4.300.0070.00016.81
7.4.290.0000.00716.61
7.4.280.0000.01016.82
7.4.270.0040.00416.70
7.4.260.0070.00016.75
7.4.250.0000.00716.72
7.4.240.0030.00416.85
7.4.230.0000.00716.94
7.4.220.0120.00816.78
7.4.210.0060.01316.77
7.4.200.0030.00516.50
7.4.160.0090.00616.55
7.4.150.0110.00617.40
7.4.140.0120.00617.86
7.4.130.0120.00716.67
7.4.120.0070.01016.83
7.4.110.0100.00716.50
7.4.100.0120.00616.72
7.4.90.0060.01116.91
7.4.80.0080.01319.39
7.4.70.0160.00616.73
7.4.60.0120.00616.48
7.4.50.0040.00416.77
7.4.40.0070.01016.72
7.4.30.0090.01216.87
7.4.00.0060.00915.14
7.3.330.0000.00613.54
7.3.320.0000.00613.38
7.3.310.0080.00016.61
7.3.300.0000.00716.44
7.3.290.0090.00816.54
7.3.280.0090.00716.53
7.3.270.0130.00517.40
7.3.260.0130.00616.56
7.3.250.0080.00916.71
7.3.240.0120.00616.52
7.3.230.0150.02516.64
7.3.210.0080.01116.57
7.3.200.0000.01719.39
7.3.190.0060.01616.77
7.3.180.0060.00916.50
7.3.170.0040.01716.51
7.3.160.0080.00816.71
7.3.10.0030.01216.40
7.3.00.0060.01016.82
7.2.330.0110.00616.85
7.2.320.0090.01217.02
7.2.310.0000.01616.88
7.2.300.0040.01316.89
7.2.290.0170.00616.70
7.2.130.0030.01316.91
7.2.120.0080.00316.75
7.2.110.0070.00716.73
7.2.100.0030.01016.99
7.2.90.0030.00916.75
7.2.80.0090.00317.15
7.2.70.0130.00316.78
7.2.60.0020.01316.98
7.2.50.0140.00716.72
7.2.40.0140.00017.01
7.2.30.0060.01217.13
7.2.20.0110.00816.86
7.2.10.0070.01117.04
7.2.00.0020.01418.28
7.1.250.0090.00016.00
7.1.200.0160.01215.71
7.1.100.0100.00318.32
7.1.70.0030.00717.57
7.1.60.0070.01719.11
7.1.50.0140.01117.14
7.1.00.0030.07722.29
7.0.200.0030.00616.99
7.0.140.0030.07322.11
7.0.110.0030.05319.96
7.0.100.0170.07719.95
7.0.90.0430.08719.88
7.0.80.0500.05320.08
7.0.70.0430.04019.90
7.0.60.0500.08319.94
7.0.50.0470.07720.39
7.0.40.0070.06720.28
7.0.30.0030.08020.19
7.0.20.0100.08020.27
7.0.10.0200.06320.07
7.0.00.0030.08320.23
5.6.280.0000.07721.16
5.6.260.0030.09020.89
5.6.250.0130.07720.72
5.6.240.0100.08720.67
5.6.230.0070.08320.68
5.6.220.0030.05020.70
5.6.210.0200.07020.63
5.6.200.0030.05021.14
5.6.190.0070.08721.22
5.6.180.0030.08721.03
5.6.170.0070.08021.03
5.6.160.0000.09021.02
5.6.150.0030.08321.09
5.6.140.0170.06721.05
5.6.130.0030.08721.09
5.6.120.0170.07020.90
5.6.110.0100.08020.95
5.6.100.0070.07320.94
5.6.90.0000.05721.25
5.6.80.0030.06720.37
5.6.70.0030.06720.48
5.6.60.0070.07720.52
5.6.50.0000.08020.36
5.6.40.0130.05720.64
5.6.30.0030.08020.59
5.6.20.0130.07020.50
5.6.10.0100.07320.50
5.6.00.0100.07320.63
5.5.380.0130.06720.54
5.5.370.0030.08020.57
5.5.360.0000.08020.48
5.5.350.0100.08020.45
5.5.340.0070.08020.96
5.5.330.0200.05020.90
5.5.320.0130.07720.77
5.5.310.0070.07320.97
5.5.300.0100.07320.90
5.5.290.0100.08020.70
5.5.280.0070.08320.85
5.5.270.0100.08021.01
5.5.260.0070.08020.89
5.5.250.0130.07020.80
5.5.240.0030.04020.34
5.5.230.0030.05020.28
5.5.220.0170.06720.19
5.5.210.0130.07020.19
5.5.200.0030.08320.26
5.5.190.0030.08320.13
5.5.180.0100.08020.26
5.5.160.0100.04720.16
5.5.150.0030.08320.05
5.5.140.0070.08020.11
5.5.130.0070.07720.10
5.5.120.0100.07020.10
5.5.110.0170.06020.16
5.5.100.0130.07320.20
5.5.90.0000.04320.27
5.5.80.0070.07720.25
5.5.70.0030.05720.22
5.5.60.0030.06020.22
5.5.50.0170.06020.22
5.5.40.0100.07320.20
5.5.30.0070.07720.13
5.5.20.0030.05320.13
5.5.10.0070.07720.13
5.5.00.0100.07020.00
5.4.450.0130.04319.64
5.4.440.0100.07019.51
5.4.430.0130.04319.56
5.4.420.0100.08019.35
5.4.410.0070.08019.43
5.4.400.0030.07719.17
5.4.390.0130.07019.17
5.4.380.0200.06719.19
5.4.370.0170.06018.95
5.4.360.0130.06719.07
5.4.350.0100.07019.09
5.4.340.0070.08019.23
5.4.320.0130.06719.18
5.4.310.0000.05018.99
5.4.300.0030.07019.18
5.4.290.0030.08019.22
5.4.280.0070.07719.14
5.4.270.0070.04319.23
5.4.260.0130.06719.02
5.4.250.0100.07019.23
5.4.240.0030.04718.98
5.4.230.0030.03719.02
5.4.220.0100.07719.08
5.4.210.0070.06318.90
5.4.200.0070.08018.98
5.4.190.0000.05318.98
5.4.180.0030.07718.95
5.4.170.0100.06319.30
5.4.160.0030.07318.99
5.4.150.0100.06318.93
5.4.140.0070.07016.39
5.4.130.0030.07716.70
5.4.120.0030.07016.44
5.4.110.0100.07316.70
5.4.100.0100.05016.46
5.4.90.0100.07716.71
5.4.80.0100.05716.48
5.4.70.0070.06716.55
5.4.60.0070.06716.52
5.4.50.0070.04316.34
5.4.40.0100.06716.60
5.4.30.0070.05716.40
5.4.20.0070.07716.33
5.4.10.0170.06016.62
5.4.00.0030.07715.98
5.3.290.0000.05314.75
5.3.280.0030.07314.72
5.3.270.0000.08014.84
5.3.260.0070.07014.62
5.3.250.0100.06014.60
5.3.240.0000.08014.69
5.3.230.0100.07314.61
5.3.220.0070.07314.66
5.3.210.0070.07714.59
5.3.200.0030.05714.59
5.3.190.0100.06714.70
5.3.180.0130.06314.80
5.3.170.0200.03314.71
5.3.160.0070.07314.58
5.3.150.0100.06714.58
5.3.140.0070.07014.52
5.3.130.0070.08014.55
5.3.120.0070.05014.54
5.3.110.0030.07714.78
5.3.100.0070.07314.03
5.3.90.0030.07014.00
5.3.80.0070.05014.04
5.3.70.0070.06713.88
5.3.60.0070.07014.02
5.3.50.0030.04014.03
5.3.40.0030.07314.07
5.3.30.0070.07314.01
5.3.20.0000.05013.71
5.3.10.0130.06713.71
5.3.00.0030.07313.66
5.2.170.0070.06311.88
5.2.160.0030.03711.88
5.2.150.0070.03311.88
5.2.140.0030.06011.88
5.2.130.0070.06011.88
5.2.120.0100.05711.88
5.2.110.0100.03011.88
5.2.100.0000.06311.88
5.2.90.0000.06311.88
5.2.80.0030.06011.88
5.2.70.0030.06311.88
5.2.60.0000.06711.88
5.2.50.0070.06011.88
5.2.40.0030.06711.88
5.2.30.0070.06311.88
5.2.20.0070.06011.88
5.2.10.0000.06711.88
5.2.00.0070.05711.88
5.1.60.0070.05011.88
5.1.50.0070.05011.88
5.1.40.0030.05311.88
5.1.30.0000.06011.88
5.1.20.0000.05711.88
5.1.10.0070.05311.88
5.1.00.0100.05011.88
5.0.50.0070.03311.88
5.0.40.0030.02711.88
5.0.30.0000.05011.88
5.0.20.0070.04011.88
5.0.10.0030.03711.88
5.0.00.0070.05711.88
4.4.90.0030.03311.88
4.4.80.0030.03311.88
4.4.70.0000.02011.88
4.4.60.0030.03311.88
4.4.50.0030.03711.88
4.4.40.0070.04311.88
4.4.30.0000.03711.88
4.4.20.0030.03311.88
4.4.10.0030.03311.88
4.4.00.0030.05311.88
4.3.110.0000.03711.88
4.3.100.0000.03711.88
4.3.90.0070.02711.88
4.3.80.0000.05711.88
4.3.70.0100.02711.88
4.3.60.0000.03711.88
4.3.50.0000.03711.88
4.3.40.0000.05311.88
4.3.30.0000.03311.88
4.3.20.0000.02011.88
4.3.10.0000.03311.88
4.3.00.0000.03711.88

preferences:
64.85 ms | 400 KiB | 5 Q