3v4l.org

run code in 150+ php & hhvm versions
Bugs & Features
<?php $link = mysql_connect('localhost','root','root'); mysql_select_db("goal_database",$link); if (isset($_GET["pid"]) && isset($_GET["week"])) { $pid = intval($_GET["pid"]); $week = intval($_GET["week"]); $response = array(); $response["meals"] = array(); // Mysql select query $result = mysql_query("SELECT * FROM Meals WHERE ParticipantID=$pid AND WeekNumber=$week;"); while($row = mysql_fetch_array($result)){ $tmp = array(); $tmp["mid"] = $row["ActivityID"]; $tmp["pid"] = $row["ParticipantID"]; $tmp["week"] = $row["WeekNumber"]; $tmp["day"] = $row["Day"]; $tmp["type"] = $row["Type"]; $tmp["image"] = $row["ImagePath"]; $tmp["comments"] = $row["Comments"]; $tmp["grain"] = $row["GrainAmount"]; $tmp["protein"] = $row["ProteinAmount"]; $tmp["dairy"] = $row["DairyAmount"]; $tmp["vegetable"] = $row["VegetableAmount"]; $tmp["fruit"] = $row["FruitAmount"]; $tmp["attic"] = $row["AtticAmount"]; array_push($response["meals"], $tmp); } // keeping response header to json header('Content-Type: application/json'); // echnoing json result echo json_encode($response); if (mysql_errno()) { $error = "MySQL error ".mysql_errno().": ".mysql_error()."\n<br>When executing:<br>\n$query\n<br>"; echo $error; } } ?>
Output for 7.0.0 - 7.1.0
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /in/OWZna:2 Stack trace: #0 {main} thrown in /in/OWZna on line 2
Process exited with code 255.
Output for hhvm-3.10.0 - 3.12.0
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2) in /in/OWZna on line 2 Warning: mysql_select_db() expects parameter 2 to be resource, boolean given in /in/OWZna on line 3
Output for 5.0.0 - 5.6.24
Fatal error: Call to undefined function mysql_connect() in /in/OWZna on line 2
Process exited with code 255.
Output for 4.3.2 - 4.4.9
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /in/OWZna on line 2 Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /in/OWZna on line 3
Output for 4.3.0 - 4.3.1
Warning: mysql_connect() [http://www.php.net/function.mysql-connect]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /in/OWZna on line 2 Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /in/OWZna on line 3