3v4l.org

run code in 200+ php & hhvm versions
Bugs & Features
<?php $link = mysql_connect('localhost', 'root', 'root'); if (!$link) { die('Could not connect: ' . mysql_error()); } else { echo 'Connected successfully' . "<br>"; } $db_selected = mysql_select_db('Test_DB', $link); if (!$db_selected) { die ('Can\'t use Test_DB : ' . mysql_error()); } else { echo 'Test_DB selected' . "<br>"; } // This SQL statement selects ALL from the table 'Contacts' $sql = "SELECT * FROM Contacts"; $result = mysql_query($sql); if (!$result) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $sql; die($message); } else { echo 'Result: ' . $result; $resultArray = array(); $tempArray = array(); // Loop through each row in the result set while ($row = mysql_fetch_array($result)) { // do stuff - here it works $tempArray = $row; array_push($resultArray, $tempArray); } // Finally, encode the array to JSON and output the results echo json_encode($resultArray); } // Check if there are results // if ($result = mysql_query($link, $sql)) if ($result = mysql_query($sql, $link)) { // If so, then create a results array and a temporary one // to hold the data $resultArray = array(); $tempArray = array(); // Loop through each row in the result set while($row = $result->fetch_object()) { // Add each row into our results array $tempArray = $row; array_push($resultArray, $tempArray); } // Finally, encode the array to JSON and output the results echo json_encode($resultArray); } // Close connections mysql_close($link); ?>
based on 4qMSp
Output for 7.0.0 - 7.2.0
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /in/EL3Rs:3 Stack trace: #0 {main} thrown in /in/EL3Rs on line 3
Process exited with code 255.
Output for 5.4.0 - 5.6.28
Fatal error: Call to undefined function mysql_connect() in /in/EL3Rs on line 3
Process exited with code 255.