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 table 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.73
8.3.50.0050.01522.11
8.3.40.0140.00018.76
8.3.30.0070.00719.24
8.3.20.0050.00320.16
8.3.10.0090.00021.85
8.3.00.0060.00318.05
8.2.180.0090.01216.63
8.2.170.0140.00722.96
8.2.160.0070.00720.37
8.2.150.0070.00024.18
8.2.140.0030.00524.66
8.2.130.0040.00426.16
8.2.120.0040.00420.82
8.2.110.0040.00721.18
8.2.100.0100.00317.84
8.2.90.0090.00019.26
8.2.80.0030.00617.97
8.2.70.0030.00617.63
8.2.60.0000.00817.93
8.2.50.0040.00418.07
8.2.40.0050.00318.27
8.2.30.0040.00418.43
8.2.20.0000.00817.73
8.2.10.0080.00018.10
8.2.00.0080.00017.73
8.1.280.0070.00725.92
8.1.270.0040.00423.91
8.1.260.0040.00426.35
8.1.250.0050.00328.09
8.1.240.0110.00721.06
8.1.230.0070.00717.70
8.1.220.0040.00417.74
8.1.210.0040.00418.77
8.1.200.0030.00717.35
8.1.190.0000.00817.35
8.1.180.0090.00018.10
8.1.170.0000.00818.70
8.1.160.0030.00522.09
8.1.150.0040.00418.95
8.1.140.0020.00517.52
8.1.130.0000.00717.88
8.1.120.0040.00417.59
8.1.110.0040.00417.52
8.1.100.0000.00717.43
8.1.90.0040.00417.55
8.1.80.0000.00817.53
8.1.70.0040.00417.40
8.1.60.0040.00417.54
8.1.50.0050.00317.46
8.1.40.0000.00817.50
8.1.30.0000.00817.55
8.1.20.0030.00617.66
8.1.10.0060.00317.55
8.1.00.0000.00717.61
8.0.300.0030.00618.77
8.0.290.0040.00416.88
8.0.280.0030.00518.43
8.0.270.0000.00717.24
8.0.260.0000.00717.25
8.0.250.0030.00317.06
8.0.240.0030.00617.04
8.0.230.0030.00317.05
8.0.220.0000.00716.99
8.0.210.0040.00417.03
8.0.200.0030.00317.09
8.0.190.0000.00917.06
8.0.180.0070.00016.99
8.0.170.0040.00416.97
8.0.160.0000.00716.93
8.0.150.0000.00716.90
8.0.140.0040.00416.84
8.0.130.0050.00313.45
8.0.120.0090.00016.81
8.0.110.0040.00416.93
8.0.100.0040.00416.95
8.0.90.0000.00717.01
8.0.80.0110.01117.00
8.0.70.0040.00416.96
8.0.60.0050.00216.83
8.0.50.0030.00616.99
8.0.30.0120.00717.18
8.0.20.0130.00717.40
8.0.10.0030.00516.87
8.0.00.0150.00616.73
7.4.330.0000.00515.14
7.4.320.0030.00316.43
7.4.300.0040.00416.49
7.4.290.0040.00416.68
7.4.280.0080.00016.73
7.4.270.0030.00516.56
7.4.260.0000.00716.61
7.4.250.0000.00716.52
7.4.240.0000.00816.57
7.4.230.0080.00016.41
7.4.220.0090.01216.75
7.4.210.0070.01416.65
7.4.200.0040.00416.74
7.4.160.0030.01416.62
7.4.150.0120.00617.40
7.4.140.0150.00217.86
7.4.130.0120.00516.54
7.4.120.0080.01216.61
7.4.110.0100.00716.60
7.4.100.0040.01316.57
7.4.90.0090.00916.58
7.4.80.0100.01019.39
7.4.70.0080.00716.47
7.4.60.0100.00916.53
7.4.50.0000.00916.68
7.4.40.0030.01316.46
7.4.30.0120.00616.58
7.4.00.0100.00614.74
7.3.330.0000.00613.29
7.3.320.0050.00013.29
7.3.310.0040.00416.32
7.3.300.0000.00716.39
7.3.290.0090.00616.37
7.3.280.0080.00916.43
7.3.270.0100.00717.40
7.3.260.0070.01016.52
7.3.250.0050.01216.35
7.3.240.0090.00916.47
7.3.230.0130.01016.68
7.3.210.0080.00816.34
7.3.200.0110.00619.39
7.3.190.0200.00316.73
7.3.180.0030.01316.74
7.3.170.0090.01216.73
7.3.160.0080.00816.45
7.3.120.0130.00014.93
7.3.10.0080.00516.49
7.3.00.0020.01216.67
7.2.330.0110.00816.64
7.2.320.0070.01016.96
7.2.310.0070.01016.97
7.2.300.0070.01116.61
7.2.290.0070.01016.83
7.2.130.0090.00816.93
7.2.120.0040.00716.71
7.2.110.0030.00916.86
7.2.100.0030.01216.97
7.2.90.0040.00917.04
7.2.80.0090.00216.99
7.2.70.0100.00517.05
7.2.60.0020.01217.08
7.2.50.0070.00816.91
7.2.40.0050.00616.83
7.2.30.0030.00916.93
7.2.20.0030.01216.92
7.2.10.0050.00717.06
7.2.00.0070.00617.79
7.1.250.0070.00715.77
7.1.100.1160.01016.03
7.1.70.0000.01017.10
7.1.60.0120.00919.70
7.1.50.0040.01216.80
7.1.00.0000.08022.29
7.0.200.0620.00714.70
7.0.140.0070.07022.09
7.0.60.0200.07321.81
7.0.50.0130.05017.94
7.0.40.0100.06020.09
7.0.30.0400.07720.08
7.0.20.0270.07720.04
7.0.10.0000.08320.19
7.0.00.0000.06720.08
5.6.280.0070.07021.23
5.6.210.0070.06320.83
5.6.200.0100.07318.25
5.6.190.0070.05320.41
5.6.180.0570.06320.57
5.6.170.0170.04020.61
5.6.160.0030.05020.43
5.6.150.0070.05318.34
5.6.140.0000.08718.33
5.6.130.0070.08018.23
5.6.120.0170.06721.20
5.6.110.0030.04021.22
5.6.100.0100.07321.12
5.6.90.0070.04721.07
5.6.80.0000.04320.48
5.5.350.0100.03720.49
5.5.340.0030.06318.06
5.5.330.0030.06720.27
5.5.320.0270.04320.31
5.5.310.0300.05020.27
5.5.300.0100.08318.13
5.5.290.0200.07318.04
5.5.280.0000.05720.98
5.5.270.0100.06320.76
5.5.260.0100.09020.73
5.5.250.0070.08320.79
5.5.240.0170.07020.24
5.4.450.4070.03319.31
5.4.440.2530.05019.51
5.4.430.3900.03319.29
5.4.420.0100.07319.53
5.4.410.3700.03319.41
5.4.400.3730.03319.27
5.4.390.2100.04019.12
5.4.380.3100.04019.15
5.4.370.3500.03319.21
5.4.360.0030.04019.07
5.4.350.2530.03718.96
5.4.340.3900.03719.14
5.4.320.3630.04019.19
5.4.310.3770.04019.23
5.4.300.4300.03019.10
5.4.290.3870.03319.00
5.4.280.3800.04019.15
5.4.270.4370.03719.02
5.4.260.4430.03718.96
5.4.250.3900.04019.23
5.4.240.4000.03319.26
5.4.230.4270.04719.13
5.4.220.3970.03319.22
5.4.210.3100.04019.18
5.4.200.3430.03719.10
5.4.190.4100.03318.97
5.4.180.3530.04719.07
5.4.170.3700.03719.14
5.4.160.3700.04319.08
5.4.150.4030.03319.18
5.4.140.4370.03316.47
5.4.130.4400.03716.56
5.4.120.4030.03016.45
5.4.110.3800.03716.51
5.4.100.3700.03016.30
5.4.90.3230.03016.42
5.4.80.3830.03316.68
5.4.70.3930.03716.59
5.4.60.3900.04016.53
5.4.50.3700.03716.37
5.4.40.3900.03016.47
5.4.30.3800.04016.59
5.4.20.3800.04016.38
5.4.10.4070.03716.63
5.4.00.3970.03015.84
5.3.290.3870.03714.68
5.3.280.4030.04014.73
5.3.270.3930.03714.72
5.3.260.3970.04314.77
5.3.250.3830.03714.71
5.3.240.4300.04014.73
5.3.230.3670.03314.70
5.3.220.3900.03714.72
5.3.210.4200.05014.72
5.3.200.3670.03714.82
5.3.190.3930.04014.72
5.3.180.3930.03014.68
5.3.170.4830.03314.69
5.3.160.3770.03714.82
5.3.150.3700.03714.73
5.3.140.3630.03714.67
5.3.130.3970.03714.54
5.3.120.4030.03714.65
5.3.110.4030.03014.81
5.3.100.3930.03314.14
5.3.90.3770.04314.15
5.3.80.3670.03714.11
5.3.70.3770.03714.20
5.3.60.3600.04713.98
5.3.50.3830.04014.09
5.3.40.4230.03714.04
5.3.30.3930.03314.04
5.3.20.4070.03013.84
5.3.10.4870.02713.76
5.3.00.3870.04013.75
5.2.170.3270.02711.25
5.2.160.3170.02711.14
5.2.150.3330.02711.30
5.2.140.3300.03311.13
5.2.130.3100.03311.15
5.2.120.3400.03311.15
5.2.110.3370.03011.21
5.2.100.3630.03011.27
5.2.90.3300.03011.25
5.2.80.3430.03011.34
5.2.70.4070.02311.25
5.2.60.3130.02711.09
5.2.50.3200.03011.09
5.2.40.2770.02711.01
5.2.30.2730.03011.11
5.2.20.2500.03011.02
5.2.10.2500.03310.88
5.2.00.2430.03010.82
5.1.60.2530.02310.02
5.1.50.2630.02310.16
5.1.40.2400.02710.00
5.1.30.2570.02710.45
5.1.20.2830.03310.55
5.1.10.2830.03310.18
5.1.00.2830.03310.17
5.0.50.0970.0138.65
5.0.40.1270.0238.49
5.0.30.1230.0338.26
5.0.20.1600.0238.38
5.0.10.1200.0238.29
5.0.00.1200.0308.35
4.4.90.1600.0136.68
4.4.80.1470.0176.68
4.4.70.1630.0136.68
4.4.60.1300.0106.68
4.4.50.1300.0176.68
4.4.40.1470.0306.68
4.4.30.1200.0176.68
4.4.20.1230.0176.68
4.4.10.1430.0176.68
4.4.00.1370.0306.70
4.3.110.1330.0136.71
4.3.100.1200.0176.71
4.3.90.1270.0106.71
4.3.80.1230.0236.73
4.3.70.1230.0136.73
4.3.60.1270.0136.73
4.3.50.1230.0136.73
4.3.40.1200.0236.73
4.3.30.0730.0176.73
4.3.20.0670.0106.73
4.3.10.0800.0206.73
4.3.00.0070.0136.73

preferences:
44.57 ms | 401 KiB | 5 Q