Online PHP editor | rfc for OWZna

@ 2014-04-15T21:07:48Z

<?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 git.master, git.master_jit, rfc.property-hooks: 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.

This tab shows result from various feature-branches currently under review by the php developers. Contact me to have additional branches featured.

Active branches

Archived branches

Once feature-branches are merged or declined, they are no longer available. Their functionality (when merged) can be viewed from the main output page

2020-03-21 RFC: Is_Literal - declined
2020-12-04 Enumerations - included in PHP 8.1
2018-06-15 Typed Properties v2 - implemented in PHP 7.4
2016-08-12 Object typehint - included in PHP 7.2
2016-08-14 Arrow functions - withdrawn
2016-05-29 array_change_keys() - withdrawn
2016-04-19 Lexical scope support for anonymous classes - suspended
2016-04-17 Functional Interfaces - declined
2016-03-16 Typed Properties - superseded in favor of Typed Properties 2.0
2015-08-27 Callable Prototypes - declined
2015-05-01 Short Closures - declined / withdrawn in favor of Arrow Functions
2015-02-18 Scalar type hints v5 - included in PHP 7
2015-02-14 Union Types - declined
2013-09-22 Anonymous classes - included in PHP 7

preferences:dark modelive preview