3v4l.org

run code in 200+ php & hhvm versions
Bugs & Features
<?php $location = "NewYork"; $return_arr = array(); $json = file_get_contents('https://maps.googleapis.com/maps/api/geocode/json?address='. $location .'&key=AIzaSyCdKLDXk7VD2GUyLLWOhv-WjQGtvzx2LCg'); $obj = json_decode($json, true); $lat = $obj['results'][0]['geometry']['location']['lat']; $lng = $obj['results'][0]['geometry']['location']['lng']; $sql = "SELECT *, ( 3959 * acos ( cos ( radians($lat) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians($lng) ) + sin ( radians($lat) ) * sin( radians( latitude ) ) ) ) AS distance FROM Events HAVING distance < 30 ORDER BY distance"; $fetch = mysqli_query($conn, $sql); while ($row = mysqli_fetch_array($fetch, MYSQLI_ASSOC)) { $row_array['title'] = $row['title']; $row_array['description'] = $row['description']; $row_array['start'] = $row['start']; $row_array['end'] = $row['end']; $row_array['website'] = $row['website']; $row_array['logo_url'] = $row['logo_url']; $row_array['online_event'] = $row['online_event']; $row_array['url'] = $row['url']; $row_array['venue'] = $row['venue']; array_push($return_arr,$row_array); } echo json_encode($return_arr); mysqli_close($conn);
Output for 7.0.20, 7.1.5 - 7.2.0
Warning: file_get_contents(): php_network_getaddresses: getaddrinfo failed: System error in /in/MoiDj on line 6 Warning: file_get_contents(https://maps.googleapis.com/maps/api/geocode/json?address=NewYork&key=AIzaSyCdKLDXk7VD2GUyLLWOhv-WjQGtvzx2LCg): failed to open stream: php_network_getaddresses: getaddrinfo failed: System error in /in/MoiDj on line 6 Fatal error: Uncaught Error: Call to undefined function mysqli_query() in /in/MoiDj:25 Stack trace: #0 {main} thrown in /in/MoiDj on line 25
Process exited with code 255.
Output for 7.0.0 - 7.0.9, 7.1.0
Warning: file_get_contents(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /in/MoiDj on line 6 Warning: file_get_contents(https://maps.googleapis.com/maps/api/geocode/json?address=NewYork&key=AIzaSyCdKLDXk7VD2GUyLLWOhv-WjQGtvzx2LCg): failed to open stream: php_network_getaddresses: getaddrinfo failed: Name or service not known in /in/MoiDj on line 6 Fatal error: Uncaught Error: Call to undefined function mysqli_query() in /in/MoiDj:25 Stack trace: #0 {main} thrown in /in/MoiDj on line 25
Process exited with code 255.
Output for 5.4.15 - 5.6.28
Warning: file_get_contents(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /in/MoiDj on line 6 Warning: file_get_contents(https://maps.googleapis.com/maps/api/geocode/json?address=NewYork&key=AIzaSyCdKLDXk7VD2GUyLLWOhv-WjQGtvzx2LCg): failed to open stream: php_network_getaddresses: getaddrinfo failed: Name or service not known in /in/MoiDj on line 6 Fatal error: Call to undefined function mysqli_query() in /in/MoiDj on line 25
Process exited with code 255.
Output for 5.4.0 - 5.4.14
Warning: file_get_contents(): Unable to find the wrapper "https" - did you forget to enable it when you configured PHP? in /in/MoiDj on line 6 Warning: file_get_contents(https://maps.googleapis.com/maps/api/geocode/json?address=NewYork&key=AIzaSyCdKLDXk7VD2GUyLLWOhv-WjQGtvzx2LCg): failed to open stream: No such file or directory in /in/MoiDj on line 6 Fatal error: Call to undefined function mysqli_query() in /in/MoiDj on line 25
Process exited with code 255.