3v4l.org

run code in 300+ PHP versions simultaneously
<?php function getFormattedSQL($sql_raw) { if( empty($sql_raw) || !is_string($sql_raw) ) { return false; } $sql_reserved_all = array ( 'ACCESSIBLE', 'ACTION', 'ADD', 'AFTER', 'AGAINST', 'AGGREGATE', 'ALGORITHM', 'ALL', 'ALTER', 'ANALYSE', 'ANALYZE', 'AND', 'AS', 'ASC', 'AUTOCOMMIT', 'AUTO_INCREMENT', 'AVG_ROW_LENGTH', 'BACKUP', 'BEGIN', 'BETWEEN', 'BINLOG', 'BOTH', 'BY', 'CASCADE', 'CASE', 'CHANGE', 'CHANGED', 'CHARSET', 'CHECK', 'CHECKSUM', 'COLLATE', 'COLLATION', 'COLUMN', 'COLUMNS', 'COMMENT', 'COMMIT', 'COMMITTED', 'COMPRESSED', 'CONCURRENT', 'CONSTRAINT', 'CONTAINS', 'CONVERT', 'CREATE', 'CROSS', 'CURRENT_TIMESTAMP', 'DATABASE', 'DATABASES', 'DAY', 'DAY_HOUR', 'DAY_MINUTE', 'DAY_SECOND', 'DEFINER', 'DELAYED', 'DELAY_KEY_WRITE', 'DELETE', 'DESC', 'DESCRIBE', 'DETERMINISTIC', 'DISTINCT', 'DISTINCTROW', 'DIV', 'DO', 'DROP', 'DUMPFILE', 'DUPLICATE', 'DYNAMIC', 'ELSE', 'ENCLOSED', 'END', 'ENGINE', 'ENGINES', 'ESCAPE', 'ESCAPED', 'EVENTS', 'EXECUTE', 'EXISTS', 'EXPLAIN', 'EXTENDED', 'FAST', 'FIELDS', 'FILE', 'FIRST', 'FIXED', 'FLUSH', 'FOR', 'FORCE', 'FOREIGN', 'FROM', 'FULL', 'FULLTEXT', 'FUNCTION', 'GEMINI', 'GEMINI_SPIN_RETRIES', 'GLOBAL', 'GRANT', 'GRANTS', 'GROUP', 'HAVING', 'HEAP', 'HIGH_PRIORITY', 'HOSTS', 'HOUR', 'HOUR_MINUTE', 'HOUR_SECOND', 'IDENTIFIED', 'IF', 'IGNORE', 'IN', 'INDEX', 'INDEXES', 'INFILE', 'INNER', 'INSERT', 'INSERT_ID', 'INSERT_METHOD', 'INTERVAL', 'INTO', 'INVOKER', 'IS', 'ISOLATION', 'JOIN', 'KEY', 'KEYS', 'KILL', 'LAST_INSERT_ID', 'LEADING', 'LEFT', 'LEVEL', 'LIKE', 'LIMIT', 'LINEAR', 'LINES', 'LOAD', 'LOCAL', 'LOCK', 'LOCKS', 'LOGS', 'LOW_PRIORITY', 'MARIA', 'MASTER', 'MASTER_CONNECT_RETRY', 'MASTER_HOST', 'MASTER_LOG_FILE', 'MASTER_LOG_POS', 'MASTER_PASSWORD', 'MASTER_PORT', 'MASTER_USER', 'MATCH', 'MAX_CONNECTIONS_PER_HOUR', 'MAX_QUERIES_PER_HOUR', 'MAX_ROWS', 'MAX_UPDATES_PER_HOUR', 'MAX_USER_CONNECTIONS', 'MEDIUM', 'MERGE', 'MINUTE', 'MINUTE_SECOND', 'MIN_ROWS', 'MODE', 'MODIFY', 'MONTH', 'MRG_MYISAM', 'MYISAM', 'NAMES', 'NATURAL', 'NOT', 'NULL', 'OFFSET', 'ON', 'OPEN', 'OPTIMIZE', 'OPTION', 'OPTIONALLY', 'OR', 'ORDER', 'OUTER', 'OUTFILE', 'PACK_KEYS', 'PAGE', 'PARTIAL', 'PARTITION', 'PARTITIONS', 'PASSWORD', 'PRIMARY', 'PRIVILEGES', 'PROCEDURE', 'PROCESS', 'PROCESSLIST', 'PURGE', 'QUICK', 'RAID0', 'RAID_CHUNKS', 'RAID_CHUNKSIZE', 'RAID_TYPE', 'RANGE', 'READ', 'READ_ONLY', 'READ_WRITE', 'REFERENCES', 'REGEXP', 'RELOAD', 'RENAME', 'REPAIR', 'REPEATABLE', 'REPLACE', 'REPLICATION', 'RESET', 'RESTORE', 'RESTRICT', 'RETURN', 'RETURNS', 'REVOKE', 'RIGHT', 'RLIKE', 'ROLLBACK', 'ROW', 'ROWS', 'ROW_FORMAT', 'SECOND', 'SECURITY', 'SELECT', 'SEPARATOR', 'SERIALIZABLE', 'SESSION', 'SET', 'SHARE', 'SHOW', 'SHUTDOWN', 'SLAVE', 'SONAME', 'SOUNDS', 'SQL', 'SQL_AUTO_IS_NULL', 'SQL_BIG_RESULT', 'SQL_BIG_SELECTS', 'SQL_BIG_TABLES', 'SQL_BUFFER_RESULT', 'SQL_CACHE', 'SQL_CALC_FOUND_ROWS', 'SQL_LOG_BIN', 'SQL_LOG_OFF', 'SQL_LOG_UPDATE', 'SQL_LOW_PRIORITY_UPDATES', 'SQL_MAX_JOIN_SIZE', 'SQL_NO_CACHE', 'SQL_QUOTE_SHOW_CREATE', 'SQL_SAFE_UPDATES', 'SQL_SELECT_LIMIT', 'SQL_SLAVE_SKIP_COUNTER', 'SQL_SMALL_RESULT', 'SQL_WARNINGS', 'START', 'STARTING', 'STATUS', 'STOP', 'STORAGE', 'STRAIGHT_JOIN', 'STRING', 'STRIPED', 'SUPER', 'TABLE', 'TABLES', 'TEMPORARY', 'TERMINATED', 'THEN', 'TO', 'TRAILING', 'TRANSACTIONAL', 'TRUNCATE', 'TYPE', 'TYPES', 'UNCOMMITTED', 'UNION', 'UNIQUE', 'UNLOCK', 'UPDATE', 'USAGE', 'USE', 'USING', 'VALUES', 'VARIABLES', 'VIEW', 'WHEN', 'WHERE', 'WITH', 'WORK', 'WRITE', 'XOR', 'YEAR_MONTH' ); $sql_skip_reserved_words = array('AS', 'ON', 'USING'); $sql_special_reserved_words = array('(', ')'); $sql_raw = str_replace("\n", " ", $sql_raw); $sql_formatted = ""; $prev_word = ""; $word = ""; for( $i=0, $j = strlen($sql_raw); $i < $j; $i++ ) { $word .= $sql_raw[$i]; $word_trimmed = trim($word); if($sql_raw[$i] == " " || in_array($sql_raw[$i], $sql_special_reserved_words)) { $word_trimmed = trim($word); $trimmed_special = false; if( in_array($sql_raw[$i], $sql_special_reserved_words) ) { $word_trimmed = substr($word_trimmed, 0, -1); $trimmed_special = true; } $word_trimmed = strtoupper($word_trimmed); if( in_array($word_trimmed, $sql_reserved_all) && !in_array($word_trimmed, $sql_skip_reserved_words) ) { if(in_array($prev_word, $sql_reserved_all)) { $sql_formatted .= '<b>'.strtoupper(trim($word)).'</b>'.'&nbsp;'; } else { $sql_formatted .= '<br/>&nbsp;'; $sql_formatted .= '<b>'.strtoupper(trim($word)).'</b>'.'&nbsp;'; } $prev_word = $word_trimmed; $word = ""; } else { $sql_formatted .= trim($word).'&nbsp;'; $prev_word = $word_trimmed; $word = ""; } } } $sql_formatted .= trim($word); return $sql_formatted; } echo getFormattedSQL("SELECT * FROM someTableName WHERE 1=1 AND name = 'foo';");

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.0150.00016.61
8.3.50.0290.00322.05
8.3.40.0140.00718.80
8.3.30.0100.00319.04
8.3.20.0000.00820.16
8.3.10.0030.00623.36
8.3.00.0030.00618.04
8.2.180.0040.01516.75
8.2.170.0150.00022.96
8.2.160.0130.00320.39
8.2.150.0040.00424.18
8.2.140.0030.00524.66
8.2.130.0080.00026.16
8.2.120.0000.00820.96
8.2.110.0110.00020.58
8.2.100.0090.00317.91
8.2.90.0000.00818.34
8.2.80.0030.00717.97
8.2.70.0080.00017.63
8.2.60.0030.00618.04
8.2.50.0000.00918.07
8.2.40.0000.00919.88
8.2.30.0030.00518.45
8.2.20.0080.00017.70
8.2.10.0040.00418.09
8.2.00.0040.00417.79
8.1.280.0070.00725.92
8.1.270.0060.00323.79
8.1.260.0080.00026.35
8.1.250.0040.00428.09
8.1.240.0040.00422.27
8.1.230.0040.00820.98
8.1.220.0050.00317.78
8.1.210.0030.00619.15
8.1.200.0000.01017.47
8.1.190.0000.00817.35
8.1.180.0000.00818.10
8.1.170.0000.00818.71
8.1.160.0040.00422.06
8.1.150.0050.00319.01
8.1.140.0000.00717.41
8.1.130.0070.00017.89
8.1.120.0040.00417.55
8.1.110.0030.00517.57
8.1.100.0040.00417.57
8.1.90.0070.00017.51
8.1.80.0040.00417.45
8.1.70.0000.00717.52
8.1.60.0040.00417.54
8.1.50.0030.00617.48
8.1.40.0040.00417.57
8.1.30.0030.00517.76
8.1.20.0040.00417.68
8.1.10.0000.00917.54
8.1.00.0040.00417.59
8.0.300.0050.00320.29
8.0.290.0030.00516.75
8.0.280.0000.00718.52
8.0.270.0050.00217.23
8.0.260.0030.00317.36
8.0.250.0030.00317.01
8.0.240.0030.00617.09
8.0.230.0000.00716.99
8.0.220.0070.00016.96
8.0.210.0040.00416.99
8.0.200.0000.00616.98
8.0.190.0000.00917.07
8.0.180.0000.00717.00
8.0.170.0040.00417.01
8.0.160.0040.00416.94
8.0.150.0030.00516.80
8.0.140.0030.00516.83
8.0.130.0060.00013.38
8.0.120.0000.00816.86
8.0.110.0000.00816.93
8.0.100.0000.00816.86
8.0.90.0040.00416.78
8.0.80.0120.00416.98
8.0.70.0000.00716.89
8.0.60.0000.00716.92
8.0.50.0050.00216.89
8.0.30.0070.01217.23
8.0.20.0070.01317.40
8.0.10.0050.00316.95
8.0.00.0070.01016.82
7.4.330.0060.00015.14
7.4.320.0000.00616.63
7.4.300.0030.00316.60
7.4.290.0030.00316.68
7.4.280.0030.00616.47
7.4.270.0000.00716.58
7.4.260.0040.00416.63
7.4.250.0000.00916.63
7.4.240.0030.00516.64
7.4.230.0000.00716.57
7.4.220.0170.00316.60
7.4.210.0000.01816.63
7.4.200.0000.00816.68
7.4.160.0120.00416.66
7.4.150.0110.00617.40
7.4.140.0030.01417.86
7.4.130.0120.00516.56
7.4.120.0080.01116.52
7.4.110.0120.00416.57
7.4.100.0070.01116.46
7.4.90.0070.01016.73
7.4.80.0120.01219.39
7.4.70.0060.01016.72
7.4.60.0160.00316.73
7.4.50.0000.00816.63
7.4.40.0050.01016.35
7.4.30.0100.00716.52
7.4.10.0070.01315.04
7.4.00.0090.00715.06
7.3.330.0030.00513.29
7.3.320.0050.00013.25
7.3.310.0030.00316.39
7.3.300.0000.00716.40
7.3.290.0030.01016.37
7.3.280.0070.01116.41
7.3.270.0140.00317.40
7.3.260.0090.00916.41
7.3.250.0080.00816.56
7.3.240.0080.01116.65
7.3.230.0000.01616.50
7.3.210.0130.00316.71
7.3.200.0100.01019.39
7.3.190.0030.01516.68
7.3.180.0140.00316.44
7.3.170.0160.00616.56
7.3.160.0170.00016.46
7.3.130.0060.01014.77
7.3.120.0070.00814.86
7.3.110.0030.01114.75
7.3.100.0060.01014.91
7.3.90.0080.00814.96
7.3.80.0080.00614.78
7.3.70.0040.01114.94
7.3.60.0050.00814.74
7.3.50.0040.00914.82
7.3.40.0040.00914.81
7.3.30.0050.00914.61
7.3.20.0070.00816.66
7.3.10.0040.01216.72
7.3.00.0060.00516.41
7.2.330.0120.00616.82
7.2.320.0170.00016.80
7.2.310.0030.01516.71
7.2.300.0000.01716.70
7.2.290.0060.00916.60
7.2.260.0000.01714.62
7.2.250.0090.01115.12
7.2.240.0050.01115.09
7.2.230.0080.00515.30
7.2.220.0060.00715.10
7.2.210.0040.00715.25
7.2.200.0040.00715.06
7.2.190.0050.01014.84
7.2.180.0040.00915.11
7.2.170.0090.00515.13
7.2.160.0060.00314.98
7.2.150.0080.00316.99
7.2.140.0000.01116.61
7.2.130.0070.00416.85
7.2.120.0140.00416.80
7.2.110.0100.00716.84
7.2.100.0100.00317.05
7.2.90.0090.00317.15
7.2.80.0070.00717.00
7.2.70.0030.00817.04
7.2.60.0000.01216.82
7.2.50.0070.01017.07
7.2.40.0090.00617.07
7.2.30.0060.00916.58
7.2.20.0130.00016.95
7.2.10.0100.00016.61
7.2.00.0030.01118.13
7.1.330.0060.00815.81
7.1.320.0030.01015.85
7.1.310.0100.00515.85
7.1.300.0080.00615.81
7.1.290.0040.01015.75
7.1.280.0060.00915.82
7.1.270.0060.00515.83
7.1.260.0080.00515.65
7.1.250.0060.00615.86
7.1.240.0030.00615.84
7.1.230.0060.00615.57
7.1.220.0060.01015.89
7.1.210.0060.00315.57
7.1.200.0000.01315.55
7.1.190.0070.00715.78
7.1.180.0070.00715.62
7.1.170.0060.00315.87
7.1.160.0000.01115.54
7.1.150.0120.00615.53
7.1.140.0080.00615.75
7.1.130.0130.00315.84
7.1.120.0000.00915.67
7.1.110.0060.00315.75
7.1.100.0250.00617.12
7.1.90.0040.01215.96
7.1.80.0070.00315.80
7.1.70.0040.00916.35
7.1.60.0060.01217.75
7.1.50.0020.01616.17
7.1.40.0040.00715.88
7.1.30.0000.01215.92
7.1.20.0000.00915.53
7.1.10.0040.00415.79
7.1.00.0080.04319.12
7.0.330.0100.00315.50
7.0.320.0060.00315.42
7.0.310.0060.00315.33
7.0.300.0030.01015.45
7.0.290.0110.00615.40
7.0.280.0110.00315.34
7.0.270.0000.01415.11
7.0.260.0090.00315.39
7.0.250.0100.00315.27
7.0.240.0060.00915.41
7.0.230.0060.00615.59
7.0.220.0030.00915.28
7.0.210.0120.00615.20
7.0.200.0370.00315.07
7.0.190.0080.00015.32
7.0.180.0000.01715.26
7.0.170.0000.00815.50
7.0.160.0110.00415.43
7.0.150.0000.01215.44
7.0.140.0050.03918.74
7.0.130.0060.00915.50
7.0.120.0070.01015.16
7.0.110.0030.01415.54
7.0.100.0110.00715.57
7.0.90.0070.00715.44
7.0.80.0090.00615.34
7.0.70.0070.00715.50
7.0.60.0100.04317.88
7.0.50.0100.04116.75
7.0.40.0080.04316.70
7.0.30.0220.03716.74
7.0.20.0080.03016.83
7.0.10.0060.03116.86
7.0.00.0080.04316.94
5.6.400.0090.00614.38
5.6.390.0030.01014.50
5.6.380.0030.00614.86
5.6.370.0030.01014.23
5.6.360.0060.01314.57
5.6.350.0140.00414.71
5.6.340.0030.00914.62
5.6.330.0030.01214.39
5.6.320.0080.00414.71
5.6.310.0060.01214.41
5.6.300.0120.00014.09
5.6.290.0030.00514.35
5.6.280.0040.04017.85
5.6.270.0040.01414.36
5.6.260.0060.01214.50
5.6.250.0120.00614.43
5.6.240.0040.01114.51
5.6.230.0030.01314.41
5.6.220.0100.00614.58
5.6.210.0020.03817.61
5.6.200.0060.03916.34
5.6.190.0070.02617.52
5.6.180.0230.04017.61
5.6.170.0130.02617.29
5.6.160.0140.02917.52
5.6.150.0050.04916.46
5.6.140.0050.04516.38
5.6.130.0090.02016.50
5.6.120.0100.04317.65
5.6.110.0060.04617.75
5.6.100.0100.04417.75
5.6.90.0070.04317.65
5.6.80.0130.03717.46
5.6.70.0070.00714.28
5.6.60.0070.00714.49
5.6.50.0030.00914.33
5.6.40.0110.00414.31
5.6.30.0040.01114.64
5.6.20.0040.01114.52
5.6.10.0030.01014.61
5.6.00.0040.01114.06
5.5.380.0080.00614.67
5.5.370.0030.01414.34
5.5.360.0030.01014.56
5.5.350.0180.04317.55
5.5.340.0030.04316.25
5.5.330.0050.02617.28
5.5.320.0100.02717.30
5.5.310.0180.03317.52
5.5.300.0060.04116.13
5.5.290.0100.02016.27
5.5.280.0060.02817.52
5.5.270.0090.04317.85
5.5.260.0100.04317.85
5.5.250.0050.04217.43
5.5.240.0070.04017.50
5.5.230.0060.00314.22
5.5.220.0030.00914.63
5.5.210.0070.00714.05
5.5.200.0030.01314.27
5.5.190.0120.00314.46
5.5.180.0030.01014.30
5.5.170.0070.01114.46
5.5.160.0040.01114.33
5.5.150.0030.01314.47
5.5.140.0060.00914.31
5.5.130.0000.00914.54
5.5.120.0060.00914.59
5.5.110.0070.00314.19
5.5.100.0070.00714.00
5.5.90.0060.00614.53
5.5.80.0070.00714.15
5.5.70.0070.00714.25
5.5.60.0030.01314.20
5.5.50.0040.00814.65
5.5.40.0060.00614.64
5.5.30.0100.00314.46
5.5.20.0030.00714.43
5.5.10.0160.00014.07
5.5.00.0000.01214.59
5.4.450.0350.04815.51
5.4.440.0460.02715.37
5.4.430.0470.03515.43
5.4.420.0500.03715.36
5.4.410.0070.03215.20
5.4.400.0240.03914.91
5.4.390.0150.03115.02
5.4.380.0090.03115.00
5.4.370.0200.02814.81
5.4.360.0280.02814.95
5.4.350.0060.01911.66
5.4.340.0040.02811.66
5.4.330.0030.01011.35
5.4.320.0040.02611.96
5.4.310.0060.02212.07
5.4.300.0060.02211.99
5.4.290.0090.02011.91
5.4.280.0030.02511.70
5.4.270.0020.02511.70
5.4.260.0090.02012.02
5.4.250.0040.02311.84
5.4.240.0040.02411.90
5.4.230.0040.02711.90
5.4.220.0070.02311.90
5.4.210.0040.02011.88
5.4.200.0040.02611.85
5.4.190.0020.02511.96
5.4.180.0050.02011.87
5.4.170.0050.02311.91
5.4.160.0020.02511.81
5.4.150.0020.02411.79
5.4.140.0050.02311.81
5.4.130.0050.02311.71
5.4.120.0050.02211.68
5.4.110.0070.01911.62
5.4.100.0050.02111.65
5.4.90.0040.02211.58
5.4.80.0050.02211.84
5.4.70.0020.02511.75
5.4.60.0060.02111.72
5.4.50.0050.02011.76
5.4.40.0040.02111.68
5.4.30.0030.02511.58
5.4.20.0040.02511.72
5.4.10.0050.02111.63
5.4.00.0050.02111.46
5.3.290.0060.02411.85
5.3.280.0070.02111.80
5.3.270.0050.02411.75
5.3.260.0070.01911.79
5.3.250.0040.02111.65
5.3.240.0050.02611.73
5.3.230.0060.02411.66
5.3.220.0080.02311.65
5.3.210.0070.02111.67
5.3.200.0040.02211.55
5.3.190.0030.02511.55
5.3.180.0050.02211.65
5.3.170.0040.02511.76
5.3.160.0060.02211.78
5.3.150.0090.01911.77
5.3.140.0020.02611.79
5.3.130.0050.02311.71
5.3.120.0050.02311.63
5.3.110.0090.02011.73
5.3.100.0080.02011.48
5.3.90.0050.02111.42
5.3.80.0090.02011.32
5.3.70.0050.02111.40
5.3.60.0050.02311.31
5.3.50.0050.02411.39
5.3.40.0070.02211.46
5.3.30.0070.02011.36
5.3.20.0050.02211.27
5.3.10.0040.02311.16
5.3.00.0050.02311.14
5.2.170.0080.0349.32
5.2.160.0050.0309.32
5.2.150.0030.0329.32
5.2.140.0040.0319.32
5.2.130.0070.0279.27
5.2.120.0050.0329.27
5.2.110.0050.0309.28
5.2.100.0050.0299.28
5.2.90.0060.0369.28
5.2.80.0030.0349.27
5.2.70.0050.0299.27
5.2.60.0040.0389.23
5.2.50.0030.0319.20
5.2.40.0100.0329.17
5.2.30.0060.0329.14
5.2.20.0030.0329.14
5.2.10.0050.0389.04
5.2.00.0080.0388.91
5.1.60.0030.0278.21
5.1.50.0040.0258.20
5.1.40.0070.0308.18
5.1.30.0090.0248.53
5.1.20.0060.0268.56
5.1.10.0060.0268.28
5.1.00.0060.0348.28
5.0.50.0070.0206.77
5.0.40.0030.0276.63
5.0.30.0010.0346.44
5.0.20.0040.0276.43
5.0.10.0020.0216.41
5.0.00.0040.0316.41
4.4.90.0020.0164.79
4.4.80.0030.0174.77
4.4.70.0060.0154.76
4.4.60.0020.0194.76
4.4.50.0000.0204.78
4.4.40.0040.0344.77
4.4.30.0030.0224.77
4.4.20.0020.0204.85
4.4.10.0020.0164.85
4.4.00.0070.0274.80
4.3.110.0030.0164.70
4.3.100.0030.0154.69
4.3.90.0040.0134.70
4.3.80.0010.0264.70
4.3.70.0020.0154.69
4.3.60.0030.0184.70
4.3.50.0040.0164.69
4.3.40.0030.0244.65
4.3.30.0030.0153.46
4.3.20.0010.0173.44
4.3.10.0020.0203.39
4.3.00.0170.0236.87

preferences:
48 ms | 401 KiB | 5 Q