Online PHP editor | perf for 6cn0R

@ 2014-03-03T16:15:33Z

<?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();
?>

Here you find the average performance (time & memory) of each version. A grayed out version indicates it didn't complete successfully (based on exit-code).

Version	System time (s)	User time (s)	Memory (MiB)
5.4.25	0.007	0.050	18.83
5.4.24	0.013	0.057	18.73
5.4.23	0.017	0.043	18.80
5.4.22	0.007	0.053	18.94
5.4.21	0.017	0.043	18.84
5.4.20	0.010	0.047	18.71
5.4.19	0.010	0.050	18.88
5.4.18	0.003	0.053	18.98
5.4.17	0.007	0.053	18.75
5.4.16	0.003	0.080	18.97
5.4.15	0.003	0.057	18.69
5.4.14	0.010	0.047	16.31
5.4.13	0.017	0.047	16.49
5.4.12	0.000	0.053	16.58
5.4.11	0.003	0.060	16.52
5.4.10	0.007	0.057	16.37
5.4.9	0.010	0.047	16.34
5.4.8	0.010	0.043	16.51
5.4.7	0.007	0.047	16.42
5.4.6	0.007	0.047	16.31
5.4.5	0.003	0.050	16.29
5.4.4	0.013	0.047	16.48
5.4.3	0.010	0.053	16.44
5.4.2	0.010	0.047	16.48
5.4.1	0.010	0.047	16.48
5.4.0	0.003	0.053	16.00
5.3.28	0.007	0.050	14.51
5.3.27	0.007	0.053	14.60
5.3.26	0.010	0.050	14.68
5.3.25	0.007	0.060	14.60
5.3.24	0.007	0.053	14.83
5.3.23	0.013	0.043	14.44
5.3.22	0.003	0.057	14.57
5.3.21	0.010	0.053	14.58
5.3.20	0.010	0.050	14.41
5.3.19	0.013	0.047	14.65
5.3.18	0.020	0.040	14.66
5.3.17	0.013	0.043	14.75
5.3.16	0.013	0.043	14.72
5.3.15	0.007	0.057	14.66
5.3.14	0.013	0.040	14.74
5.3.13	0.013	0.050	14.55
5.3.12	0.013	0.060	14.64
5.3.11	0.003	0.053	14.64
5.3.10	0.003	0.070	13.88
5.3.9	0.007	0.060	14.19
5.3.8	0.010	0.050	14.11
5.3.7	0.013	0.043	13.93
5.3.6	0.003	0.060	14.09
5.3.5	0.007	0.047	13.96
5.3.4	0.007	0.053	13.86
5.3.3	0.007	0.067	14.14
5.3.2	0.007	0.047	13.78
5.3.1	0.007	0.053	13.73
5.3.0	0.010	0.050	13.67

preferences:dark modelive preview