Online PHP editor | rfc for XGTMs

@ 2014-03-03T16:16:36Z

<?php
function getGoals(){
$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["goals"] = array();
    // Mysql select query to retrieve nutrition goal
    $nutrition_result = mysql_query("SELECT Description FROM Goals WHERE ParticipantID=$pid AND WeekNumber=$week AND Type='NUTRITION';");
    $row = mysql_fetch_array($nutrition_result);
    $nutrition_goal = $row[0];
    $tmp = array();
    $tmp["nutrition"] = $nutrition_goal;
    array_push($response["goals"], $tmp);
    // Mysql query to retrieve exervise goal
    $exercise_result = mysql_query("SELECT Description FROM Goals WHERE ParticipantID=$pid AND WeekNumber=$week AND Type='EXERCISE';");
    $row = mysql_fetch_array($exercise_result);
    $exercise_goal = $row[0];
    $tmp["exercise"] = $exercise_goal;
    array_push($response["goals"], $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;
    }
    }
}
getGoals();
?>

Output for git.master, git.master_jit, rfc.property-hooks: Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /in/XGTMs:3 Stack trace: #0 /in/XGTMs(37): getGoals() #1 {main} thrown in /in/XGTMs on line 3
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