3v4l.org

run code in 300+ PHP versions simultaneously
<?php interface DatabaseStatementInterface extends Traversable { /** * Executes a prepared statement * * @param $args * An array of values with as many elements as there are bound parameters in * the SQL statement being executed. * @param $options * An array of options for this query. * * @return * TRUE on success, or FALSE on failure. */ public function execute($args = array(), $options = array()); /** * Gets the query string of this statement. * * @return * The query string, in its form with placeholders. */ public function getQueryString(); /** * Returns the number of rows affected by the last SQL statement. * * @return * The number of rows affected by the last DELETE, INSERT, or UPDATE * statement executed. */ public function rowCount(); /** * Sets the default fetch mode for this statement. * * See http://php.net/manual/pdo.constants.php for the definition of the * constants used. * * @param $mode * One of the PDO::FETCH_* constants. * @param $a1 * An option depending of the fetch mode specified by $mode: * - for PDO::FETCH_COLUMN, the index of the column to fetch * - for PDO::FETCH_CLASS, the name of the class to create * - for PDO::FETCH_INTO, the object to add the data to * @param $a2 * If $mode is PDO::FETCH_CLASS, the optional arguments to pass to the * constructor. */ // public function setFetchMode($mode, $a1 = NULL, $a2 = array()); /** * Fetches the next row from a result set. * * See http://php.net/manual/pdo.constants.php for the definition of the * constants used. * * @param $mode * One of the PDO::FETCH_* constants. * Default to what was specified by setFetchMode(). * @param $cursor_orientation * Not implemented in all database drivers, don't use. * @param $cursor_offset * Not implemented in all database drivers, don't use. * * @return * A result, formatted according to $mode. */ // public function fetch($mode = NULL, $cursor_orientation = NULL, $cursor_offset = NULL); /** * Returns a single field from the next record of a result set. * * @param $index * The numeric index of the field to return. Defaults to the first field. * * @return * A single field from the next record, or FALSE if there is no next record. */ public function fetchField($index = 0); /** * Fetches the next row and returns it as an object. * * The object will be of the class specified by DatabaseStatementInterface::setFetchMode() * or stdClass if not specified. */ // public function fetchObject(); /** * Fetches the next row and returns it as an associative array. * * This method corresponds to PDOStatement::fetchObject(), but for associative * arrays. For some reason PDOStatement does not have a corresponding array * helper method, so one is added. * * @return * An associative array, or FALSE if there is no next row. */ public function fetchAssoc(); /** * Returns an array containing all of the result set rows. * * @param $mode * One of the PDO::FETCH_* constants. * @param $column_index * If $mode is PDO::FETCH_COLUMN, the index of the column to fetch. * @param $constructor_arguments * If $mode is PDO::FETCH_CLASS, the arguments to pass to the constructor. * * @return * An array of results. */ // function fetchAll($mode = NULL, $column_index = NULL, array $constructor_arguments); /** * Returns an entire single column of a result set as an indexed array. * * Note that this method will run the result set to the end. * * @param $index * The index of the column number to fetch. * * @return * An indexed array, or an empty array if there is no result set. */ public function fetchCol($index = 0); /** * Returns the entire result set as a single associative array. * * This method is only useful for two-column result sets. It will return an * associative array where the key is one column from the result set and the * value is another field. In most cases, the default of the first two columns * is appropriate. * * Note that this method will run the result set to the end. * * @param $key_index * The numeric index of the field to use as the array key. * @param $value_index * The numeric index of the field to use as the array value. * * @return * An associative array, or an empty array if there is no result set. */ public function fetchAllKeyed($key_index = 0, $value_index = 1); /** * Returns the result set as an associative array keyed by the given field. * * If the given key appears multiple times, later records will overwrite * earlier ones. * * @param $key * The name of the field on which to index the array. * @param $fetch * The fetchmode to use. If set to PDO::FETCH_ASSOC, PDO::FETCH_NUM, or * PDO::FETCH_BOTH the returned value with be an array of arrays. For any * other value it will be an array of objects. By default, the fetch mode * set for the query will be used. * * @return * An associative array, or an empty array if there is no result set. */ public function fetchAllAssoc($key, $fetch = NULL); } ?>

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.0190.00318.16
8.3.50.0150.00822.01
8.3.40.0070.00718.71
8.3.30.0120.00319.01
8.3.20.0050.00220.38
8.3.10.0050.00321.90
8.3.00.0000.00819.26
8.2.180.0090.00616.32
8.2.170.0140.00722.96
8.2.160.0100.00320.46
8.2.150.0000.00824.18
8.2.140.0030.00624.66
8.2.130.0020.00526.16
8.2.120.0080.00022.11
8.2.110.0050.00520.52
8.2.100.0100.00017.97
8.2.90.0050.00319.05
8.2.80.0040.00417.97
8.2.70.0030.00617.50
8.2.60.0100.00017.80
8.2.50.0090.00318.07
8.2.40.0020.00518.03
8.2.30.0040.00818.04
8.2.20.0000.00717.52
8.2.10.0040.00417.90
8.2.00.0030.00617.65
8.1.280.0070.01325.92
8.1.270.0090.00022.02
8.1.260.0000.00726.35
8.1.250.0040.00428.09
8.1.240.0040.00423.79
8.1.230.0110.00019.16
8.1.220.0000.00817.74
8.1.210.0000.00818.77
8.1.200.0000.00917.23
8.1.190.0000.00817.23
8.1.180.0040.00418.10
8.1.170.0060.00318.64
8.1.160.0040.00422.09
8.1.150.0000.00818.85
8.1.140.0070.00017.46
8.1.130.0030.00317.85
8.1.120.0030.00317.49
8.1.110.0040.00417.25
8.1.100.0000.00717.38
8.1.90.0000.00717.47
8.1.80.0030.00317.31
8.1.70.0000.00817.42
8.1.60.0040.00417.60
8.1.50.0080.00017.36
8.1.40.0070.00417.36
8.1.30.0000.00817.63
8.1.20.0040.00417.45
8.1.10.0040.00417.46
8.1.00.0040.00417.22
8.0.300.0000.00718.77
8.0.290.0060.00316.75
8.0.280.0030.00318.26
8.0.270.0040.00417.13
8.0.260.0060.00017.26
8.0.250.0070.00016.96
8.0.240.0030.00316.88
8.0.230.0000.00716.86
8.0.220.0000.00716.77
8.0.210.0060.00016.88
8.0.200.0000.01016.80
8.0.190.0040.00416.88
8.0.180.0030.00616.86
8.0.170.0000.00816.76
8.0.160.0040.00416.74
8.0.150.0000.00716.81
8.0.140.0000.00716.71
8.0.130.0000.00613.26
8.0.120.0040.00416.82
8.0.110.0000.00816.68
8.0.100.0000.00716.79
8.0.90.0040.00416.86
8.0.80.0120.00316.91
8.0.70.0040.00416.85
8.0.60.0080.00016.73
8.0.50.0070.00016.92
8.0.30.0120.01117.01
8.0.20.0120.00917.40
8.0.10.0050.00316.96
8.0.00.0090.00916.69
7.4.330.0000.00415.00
7.4.320.0000.00616.43
7.4.300.0040.00416.54
7.4.290.0000.00816.42
7.4.280.0050.00316.59
7.4.270.0070.00016.56
7.4.260.0050.00316.58
7.4.250.0000.00716.53
7.4.240.0040.00316.59
7.4.230.0000.00816.46
7.4.220.0120.00616.51
7.4.210.0100.00816.64
7.4.200.0030.00316.45
7.4.160.0070.01016.59
7.4.150.0130.00417.40
7.4.140.0130.00517.86
7.4.130.0060.01116.45
7.4.120.0110.01016.40
7.4.110.0100.01016.57
7.4.100.0070.01016.63
7.4.90.0070.01016.55
7.4.80.0120.00619.39
7.4.70.0090.01216.35
7.4.60.0060.01016.40
7.4.50.0040.00416.54
7.4.40.0120.00816.56
7.4.30.0100.00716.55
7.4.00.0070.00715.12
7.3.330.0000.00513.20
7.3.320.0000.00513.16
7.3.310.0030.00316.22
7.3.300.0030.00316.16
7.3.290.0060.00916.21
7.3.280.0090.00716.20
7.3.270.0120.00617.40
7.3.260.0150.00316.36
7.3.250.0060.00916.40
7.3.240.0100.00916.20
7.3.230.0070.01516.39
7.3.210.0090.00916.09
7.3.200.0110.00719.39
7.3.190.0100.00716.28
7.3.180.0050.01116.43
7.3.170.0190.00316.34
7.3.160.0100.00716.41
7.3.120.0090.00914.71
7.3.110.0110.00414.98
7.3.100.0110.00414.56
7.3.90.0040.01114.59
7.3.80.0040.00714.75
7.3.70.0100.00314.55
7.3.60.0040.00814.82
7.3.50.0000.00914.64
7.3.40.0070.00714.61
7.3.30.0060.00614.88
7.3.20.0070.00716.56
7.3.10.0040.00716.49
7.3.00.0030.00916.67
7.2.330.0070.01016.38
7.2.320.0070.01516.30
7.2.310.0140.00316.33
7.2.300.0090.00916.28
7.2.290.0050.01116.44
7.2.250.0110.00714.64
7.2.240.0030.01614.66
7.2.230.0000.01414.76
7.2.220.0060.00915.10
7.2.210.0070.00414.89
7.2.200.0100.00714.87
7.2.190.0070.00714.97
7.2.180.0060.01015.02
7.2.170.0130.00614.61
7.2.160.0060.00914.61
7.2.150.0060.00616.66
7.2.140.0080.00816.95
7.2.130.0060.00316.70
7.2.120.0070.00716.66
7.2.110.0030.00616.83
7.2.100.0060.00916.72
7.2.90.0090.00916.52
7.2.80.0040.01116.63
7.2.70.0070.01016.61
7.2.60.0030.01016.81
7.2.50.0100.00016.67
7.2.40.0120.00316.61
7.2.30.0100.00316.70
7.2.20.0000.01116.77
7.2.10.0060.00916.67
7.2.00.0050.00718.14
7.1.330.0040.00915.39
7.1.320.0100.00315.56
7.1.310.0070.00715.70
7.1.300.0120.00015.69
7.1.290.0040.00815.62
7.1.280.0040.01115.58
7.1.270.0070.00715.43
7.1.260.0070.00715.56
7.1.250.0000.01115.42
7.1.240.0110.00315.43
7.1.230.0000.01115.39
7.1.220.0030.00915.84
7.1.210.0000.00915.77
7.1.200.0070.00715.27
7.1.190.0070.00715.57
7.1.180.0060.00615.57
7.1.170.0030.00615.36
7.1.160.0070.00315.58
7.1.150.0000.01315.82
7.1.140.0100.00315.34
7.1.130.0110.00315.64
7.1.120.0060.00615.74
7.1.110.0060.00915.63
7.1.100.0060.00916.83
7.1.90.0040.01115.46
7.1.80.0100.00715.59
7.1.70.0070.00316.28
7.1.60.0030.01517.53
7.1.50.0050.00516.24
7.1.40.0070.00715.30
7.1.30.0040.00815.57
7.1.20.0100.00015.59
7.1.10.0060.00315.40
7.1.00.0050.04019.22
7.0.330.0000.01315.26
7.0.320.0000.01315.07
7.0.310.0060.00615.27
7.0.300.0030.01015.04
7.0.290.0040.00915.23
7.0.280.0070.00315.30
7.0.270.0060.01015.14
7.0.260.0070.00715.42
7.0.250.0100.00315.39
7.0.240.0000.01515.42
7.0.230.0030.00815.25
7.0.220.0100.00015.40
7.0.210.0030.00915.25
7.0.200.0000.00916.11
7.0.190.0040.01115.11
7.0.180.0060.00615.25
7.0.170.0090.00015.04
7.0.160.0040.00415.29
7.0.150.0070.00715.12
7.0.140.0130.03218.56
7.0.130.0070.00715.29
7.0.120.0060.01015.27
7.0.110.0060.00615.14
7.0.100.0000.01115.32
7.0.90.0100.00615.33
7.0.80.0030.00614.91
7.0.70.2500.02717.68
7.0.60.0090.03917.62
7.0.50.0080.02516.50
7.0.40.0070.04716.60
7.0.30.0050.02516.62
7.0.20.0210.03816.71
7.0.10.0160.02816.84
7.0.00.0050.04816.70
5.6.400.0030.00914.34
5.6.390.0040.01114.09
5.6.380.0040.01113.85
5.6.370.0100.00314.29
5.6.360.0080.00314.20
5.6.350.0070.00713.77
5.6.340.0090.00914.19
5.6.330.0060.00814.27
5.6.320.0080.00414.32
5.6.310.0100.00313.96
5.6.300.0090.00914.14
5.6.290.0030.00714.36
5.6.280.0020.04217.66
5.6.270.0030.00614.14
5.6.260.0040.00714.33
5.6.250.0070.00313.87
5.6.240.0030.00914.44
5.6.230.0000.01114.27
5.6.220.0000.00814.28
5.6.210.0070.05017.29
5.6.200.0020.02616.20
5.6.190.0030.02817.44
5.6.180.0190.04017.41
5.6.170.0180.04417.25
5.6.160.0030.05117.36
5.6.150.0080.02616.29
5.6.140.0070.04916.25
5.6.130.0060.02516.05
5.6.120.0070.02917.48
5.6.110.0070.02517.54
5.6.100.0030.02717.61
5.6.90.0060.04617.79
5.6.80.0080.04417.29
5.6.70.0150.03817.23
5.6.60.0080.00014.03
5.6.50.0110.00414.26
5.6.40.0080.00614.19
5.6.30.0040.00714.13
5.6.20.0090.00313.98
5.6.10.0060.00914.04
5.6.00.0040.00814.05
5.5.380.0110.00413.69
5.5.370.0090.00314.09
5.5.360.0030.00914.00
5.5.350.0070.04317.38
5.5.340.0050.03715.93
5.5.330.0100.02217.36
5.5.320.0030.04417.04
5.5.310.0220.02017.08
5.5.300.0050.02716.08
5.5.290.0050.04716.04
5.5.280.0070.04317.23
5.5.270.0050.04517.36
5.5.260.0070.04717.52
5.5.250.0080.02117.34
5.5.240.0050.04217.18
5.5.230.0070.00714.06
5.5.220.0000.00814.18
5.5.210.0070.00713.89
5.5.200.0030.01013.62
5.5.190.0040.00814.21
5.5.180.0060.00613.95
5.5.170.0030.01314.02
5.5.160.0060.00614.00
5.5.150.0000.00913.82
5.5.140.0040.00713.90
5.5.130.0000.01214.09
5.5.120.0110.00414.11
5.5.110.0030.01313.55
5.5.100.0030.01013.95
5.5.90.0100.00313.89
5.5.80.0000.00913.85
5.5.70.0030.01013.93
5.5.60.0140.00013.77
5.5.50.0060.00614.20
5.5.40.0030.00614.12
5.5.30.0000.01414.38
5.5.20.0000.01413.59
5.5.10.0120.00014.33
5.5.00.0030.00714.11
5.4.450.0150.02315.17
5.4.440.0300.02715.07
5.4.430.0180.02615.23
5.4.420.0350.00415.18
5.4.410.0310.00315.07
5.4.400.0330.00314.88
5.4.390.0320.00414.99
5.4.380.0360.00214.92
5.4.370.0360.00014.97
5.4.360.0350.00214.92
5.4.350.0330.00214.88
5.4.340.0070.01911.45
5.4.330.0040.00410.83
5.4.320.0070.01811.60
5.4.310.0050.02411.64
5.4.300.0040.02211.75
5.4.290.0050.02111.67
5.4.280.0080.01911.44
5.4.270.0080.01911.59
5.4.260.0060.02011.69
5.4.250.0050.02411.76
5.4.240.0070.01711.56
5.4.230.0070.02011.66
5.4.220.0020.02111.59
5.4.210.0050.02011.43
5.4.200.0030.02211.59
5.4.190.0080.02311.71
5.4.180.0070.02011.58
5.4.170.0030.02211.63
5.4.160.0070.01911.58
5.4.150.0040.02211.67
5.4.140.0030.02411.49
5.4.130.0040.02311.49
5.4.120.0060.02311.44
5.4.110.0060.02511.41
5.4.100.0060.01911.50
5.4.90.0050.02011.45
5.4.80.0050.02411.47
5.4.70.0070.02011.53
5.4.60.0060.01911.42
5.4.50.0040.02111.39
5.4.40.0060.01911.48
5.4.30.0050.02011.32
5.4.20.0070.01811.43
5.4.10.0020.02711.53
5.4.00.0050.02011.18
5.3.290.0050.03912.80
5.3.280.0070.03512.71
5.3.270.0090.03812.72
5.3.260.0040.04912.72
5.3.250.0080.03812.72
5.3.240.0080.03412.72
5.3.230.0060.03712.70
5.3.220.0050.03712.68
5.3.210.0090.03512.68
5.3.200.0050.03612.68
5.3.190.0080.03512.68
5.3.180.0040.03712.68
5.3.170.0050.03612.67
5.3.160.0120.03012.67
5.3.150.0090.04012.67
5.3.140.0070.03512.66
5.3.130.0070.03812.65
5.3.120.0070.03712.66
5.3.110.0100.03412.65
5.3.100.0060.03512.14
5.3.90.0050.03912.12
5.3.80.0030.03912.10
5.3.70.0050.04112.10
5.3.60.0070.03312.09
5.3.50.0050.04412.03
5.3.40.0090.03612.04
5.3.30.0070.03612.00
5.3.20.0050.03511.78
5.3.10.0070.04011.74
5.3.00.0040.03811.73
5.2.170.0050.0309.23
5.2.160.0060.0289.23
5.2.150.0060.0319.23
5.2.140.0040.0369.23
5.2.130.0050.0319.19
5.2.120.0080.0269.18
5.2.110.0030.0339.20
5.2.100.0060.0309.20
5.2.90.0040.0329.20
5.2.80.0050.0299.19
5.2.70.0050.0339.18
5.2.60.0050.0309.15
5.2.50.0070.0279.12
5.2.40.0080.0329.10
5.2.30.0040.0349.07
5.2.20.0040.0309.05
5.2.10.0070.0258.96
5.2.00.0060.0278.82
5.1.60.0050.0228.11
5.1.50.0020.0268.10
5.1.40.0060.0238.08
5.1.30.0010.0298.43
5.1.20.0040.0278.45
5.1.10.0040.0268.18
5.1.00.0030.0268.18
5.0.50.0040.0206.65
5.0.40.0030.0206.52
5.0.30.0040.0316.32
5.0.20.0060.0176.29
5.0.10.0020.0216.28
5.0.00.0050.0306.27
4.4.90.0020.0164.78
4.4.80.0020.0164.76
4.4.70.0010.0194.75
4.4.60.0020.0164.75
4.4.50.0010.0174.77
4.4.40.0020.0244.71
4.4.30.0040.0134.76
4.4.20.0050.0134.85
4.4.10.0020.0164.85
4.4.00.0050.0234.76
4.3.110.0030.0164.67
4.3.100.0040.0134.66
4.3.90.0010.0164.64
4.3.80.0060.0204.58
4.3.70.0010.0184.63
4.3.60.0040.0174.63
4.3.50.0000.0184.63
4.3.40.0020.0254.54
4.3.30.0020.0163.29
4.3.20.0020.0163.26
4.3.10.0020.0153.22
4.3.00.0070.02013.71

preferences:
45.57 ms | 401 KiB | 5 Q