3v4l.org

run code in 150+ php & hhvm versions
Bugs & Features
<?php $input = '{"reportId":"79","report":{"Report":{"id":"79","report_group_id":"1","custom_report":null,"report_code":"ER106","report_name":"Applicant Open Days (AOD) Activity Report","report_desc":"How many students were invited to, then booked onto, attended or didn\'t attend an Applicant Open Day?","long_desc":"<h3>Key<\/h3>\n<ul>\n<li><strong>AOD1:<\/strong> Student was invited to an App Open day using AOD<\/li>\n<li><strong>AOD2:<\/strong> Student booked to come to an App Open day using AOD<\/li>\n<li><strong>AOD3:<\/strong> Student turned up to an App Open day using AOD<\/li>\n<li><strong>AOD4:<\/strong> Student did not turn up to an App Open day using AOD<\/li>\n\n<\/ul>","root_notes":null,"sql_statement":"SELECT \n\n\nDATE_FORMAT(ENT.date, '%b %Y') AS `month`,\nSUM( CASE ENT.activity_type_code WHEN 'AOD1' THEN 1 ELSE 0 END ) AS 'AOD1',\nSUM( CASE ENT.activity_type_code WHEN 'AOD2' THEN 1 ELSE 0 END ) AS 'AOD2',\nSUM( CASE ENT.activity_type_code WHEN 'AOD3' THEN 1 ELSE 0 END ) AS 'AOD3',\nSUM( CASE ENT.activity_type_code WHEN 'AOD4' THEN 1 ELSE 0 END ) AS 'AOD4'\n\nFROM `ent_enterprise_stats` ENT\n\n\nWHERE \n\n%%filter%%\n\nAND ENT.activity_type_code IN ('AOD1', 'AOD2', 'AOD3', 'AOD4')\n\nGROUP BY DATE_FORMAT(ENT.date, '%b %Y')\n\nORDER BY DATE_FORMAT(ENT.date, '%Y%m')\n","live":"0","published":"1","created":null,"modified":null,"chart_title":"AOD Activity","global":"1","icon":"chart_column","category_field":"month","series":"AOD1,AOD2,AOD3,AOD4","chart_element":"column_chart","chart_height":null,"table_format":"text,number,number,number,number","insights_url":"https:\/\/studentcrm.zendesk.com\/hc\/en-gb\/articles\/200682392","report_type_id":"1","raw_data":[[{"month":"Oct 2013","AOD1":"1546","AOD2":"258","AOD3":"0","AOD4":"0"}],[{"month":"Nov 2013","AOD1":"6231","AOD2":"2062","AOD3":"51","AOD4":"3"}],[{"month":"Dec 2013","AOD1":"10965","AOD2":"3680","AOD3":"990","AOD4":"172"}],[{"month":"Jan 2014","AOD1":"9478","AOD2":"4250","AOD3":"1221","AOD4":"263"}],[{"month":"Feb 2014","AOD1":"378","AOD2":"1905","AOD3":"3580","AOD4":"1394"}],[{"month":"Mar 2014","AOD1":"113","AOD2":"45","AOD3":"29","AOD4":"9"}],[{"month":"Apr 2014","AOD1":"298","AOD2":"87","AOD3":"1595","AOD4":"1513"}],[{"month":"May 2014","AOD1":"392","AOD2":"32","AOD3":"19","AOD4":"11"}],[{"month":"Jun 2014","AOD1":"372","AOD2":"22","AOD3":"0","AOD4":"0"}],[{"month":"Jul 2014","AOD1":"127","AOD2":"6","AOD3":"0","AOD4":"0"}]],"data":{"Oct 2013":{"AOD1":"1546","AOD2":"258","AOD3":"0","AOD4":"0"},"Nov 2013":{"AOD1":"6231","AOD2":"2062","AOD3":"51","AOD4":"3"},"Dec 2013":{"AOD1":"10965","AOD2":"3680","AOD3":"990","AOD4":"172"},"Jan 2014":{"AOD1":"9478","AOD2":"4250","AOD3":"1221","AOD4":"263"},"Feb 2014":{"AOD1":"378","AOD2":"1905","AOD3":"3580","AOD4":"1394"},"Mar 2014":{"AOD1":"113","AOD2":"45","AOD3":"29","AOD4":"9"},"Apr 2014":{"AOD1":"298","AOD2":"87","AOD3":"1595","AOD4":"1513"},"May 2014":{"AOD1":"392","AOD2":"32","AOD3":"19","AOD4":"11"},"Jun 2014":{"AOD1":"372","AOD2":"22","AOD3":"0","AOD4":"0"},"Jul 2014":{"AOD1":"127","AOD2":"6","AOD3":"0","AOD4":"0"}},"table_data":[{"month":"Oct 2013","AOD1":"1546","AOD2":"258","AOD3":"0","AOD4":"0"},{"month":"Nov 2013","AOD1":"6231","AOD2":"2062","AOD3":"51","AOD4":"3"},{"month":"Dec 2013","AOD1":"10965","AOD2":"3680","AOD3":"990","AOD4":"172"},{"month":"Jan 2014","AOD1":"9478","AOD2":"4250","AOD3":"1221","AOD4":"263"},{"month":"Feb 2014","AOD1":"378","AOD2":"1905","AOD3":"3580","AOD4":"1394"},{"month":"Mar 2014","AOD1":"113","AOD2":"45","AOD3":"29","AOD4":"9"},{"month":"Apr 2014","AOD1":"298","AOD2":"87","AOD3":"1595","AOD4":"1513"},{"month":"May 2014","AOD1":"392","AOD2":"32","AOD3":"19","AOD4":"11"},{"month":"Jun 2014","AOD1":"372","AOD2":"22","AOD3":"0","AOD4":"0"},{"month":"Jul 2014","AOD1":"127","AOD2":"6","AOD3":"0","AOD4":"0"}]},"ReportType":{"id":"1","type_name":"Interactions"}},"chartHeight":400,"md5":"6fecbc49e6d6500ef1cd7745ad5ab630","establishmentName":"Coventry University","userName":"Dom Yeadon","today":"03 Jul 2014 at 18:14","reportCode":"ER106","lastRun":"03 Jul 2014 at 00:00","noReportData":false,"headers":["Month","AOD1","AOD2","AOD3","AOD4"],"data":[{"month":"Oct 2013","AOD1":"1546","AOD2":"258","AOD3":"0","AOD4":"0"},{"month":"Nov 2013","AOD1":"6231","AOD2":"2062","AOD3":"51","AOD4":"3"},{"month":"Dec 2013","AOD1":"10965","AOD2":"3680","AOD3":"990","AOD4":"172"},{"month":"Jan 2014","AOD1":"9478","AOD2":"4250","AOD3":"1221","AOD4":"263"},{"month":"Feb 2014","AOD1":"378","AOD2":"1905","AOD3":"3580","AOD4":"1394"},{"month":"Mar 2014","AOD1":"113","AOD2":"45","AOD3":"29","AOD4":"9"},{"month":"Apr 2014","AOD1":"298","AOD2":"87","AOD3":"1595","AOD4":"1513"},{"month":"May 2014","AOD1":"392","AOD2":"32","AOD3":"19","AOD4":"11"},{"month":"Jun 2014","AOD1":"372","AOD2":"22","AOD3":"0","AOD4":"0"},{"month":"Jul 2014","AOD1":"127","AOD2":"6","AOD3":"0","AOD4":"0"}],"format":{"Month":"text","AOD1":"number","AOD2":"number","AOD3":"number","AOD4":"number"},"categories":"\'Oct 2013\',\'Nov 2013\',\'Dec 2013\',\'Jan 2014\',\'Feb 2014\',\'Mar 2014\',\'Apr 2014\',\'May 2014\',\'Jun 2014\',\'Jul 2014\'","series":"{name: \"AOD1\", data: [1546,6231,10965,9478,378,113,298,392,372,127]},{name: \"AOD2\", data: [258,2062,3680,4250,1905,45,87,32,22,6]},{name: \"AOD3\", data: [0,51,990,1221,3580,29,1595,19,0,0]},{name: \"AOD4\", data: [0,3,172,263,1394,9,1513,11,0,0]}","hideFilters":false,"levels":{"41":"Schools","1":"Undergraduate","41,1":"All Levels","0":"Unknown"},"faculties":{"1000":"Business, Environment and Society (BES)","1016":"Coventry University London Campus (CULC)","1001":"Engineering and Computing (EC)","1002":"Health and Life Sciences (HLS)","1039":"Institute of Applied Entrepreneurship (IAE)","1003":"School of Art and Design (CSAD)","1000,1016,1001,1002,1039,1003":"All Faculties","0":"Unknown"},"yearsOfEntry":{"2011":2011,"2012":2012,"2013":2013,"2014":2014,"2015":2015,"2016":2016,"2017":2017,"2018":2018,"2019":2019,"0":"Unknown"},"defaultYearOfEntry":"2014","marketingUnits":{"1003":"Recruitment and Admissions Office","all":"All Marketing Units"},"app_id":"19","items_per_page":50,"app_permissions":{"ModuleOccurrences:1045":"write","ModuleOccurrences:1076":"write","ModuleOccurrences:1014":"write","ModuleOccurrences:1042":"write","ModuleOccurrences:1075":"write","ModuleOccurrences:1015":"write","ModuleOccurrences:1016":"write","ModuleOccurrences:1049":"write","AdHocs:*":"write","Courses:*":"write","EnterpriseReports:*":"super","Faculties:*":"read","Students:*":"write","Users:*":"super","StudentLogs:*":"write"},"dh_only":false,"userNeedToChangePassword":false,"multi_user":{"1079":"Branksome University","1002":"Coventry University","1007":"New Forest University"},"filter":{"establishment_id":"1002","year_of_entry":"2014"}}'; var_dump(str_len($input)); $output = gzcompress($input, 9); var_dump(str_len($output));
Output for 5.4.0 - 5.4.31
Parse error: syntax error, unexpected '') AS `month`,\nSUM( CASE ENT.' (T_CONSTANT_ENCAPSED_STRING) in /in/qJDea on line 3
Process exited with code 255.
Output for 4.4.2 - 4.4.9, 5.1.0 - 5.3.28
Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /in/qJDea on line 3
Process exited with code 255.
Output for 4.3.0 - 4.3.1, 4.3.5 - 4.4.1, 5.0.0 - 5.0.5
Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /in/qJDea on line 3
Process exited with code 255.
Output for 4.3.2 - 4.3.4
Parse error: parse error in /in/qJDea on line 3
Process exited with code 255.