Online PHP editor | perf for vvCQ5

@ 2014-04-15T21:06:28Z

<?php
linkk = 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;
?>

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.27	0.023	0.057	18.89
5.4.26	0.007	0.077	18.96
5.4.25	0.017	0.070	18.99
5.4.24	0.010	0.080	18.92
5.4.23	0.013	0.057	18.98
5.4.22	0.017	0.053	19.07
5.4.21	0.010	0.067	18.84
5.4.20	0.013	0.070	19.02
5.4.19	0.007	0.070	18.97
5.4.18	0.023	0.060	18.84
5.4.17	0.017	0.053	19.15
5.4.16	0.007	0.083	19.16
5.4.15	0.023	0.070	18.86
5.4.14	0.017	0.050	16.45
5.4.13	0.010	0.067	16.70
5.4.12	0.017	0.053	16.71
5.4.11	0.013	0.060	16.38
5.4.10	0.010	0.057	16.69
5.4.9	0.017	0.060	16.61
5.4.8	0.017	0.050	16.50
5.4.7	0.010	0.060	16.34
5.4.6	0.013	0.047	16.47
5.4.5	0.007	0.067	16.58
5.4.4	0.007	0.073	16.58
5.4.3	0.027	0.040	16.64
5.4.2	0.020	0.043	16.28
5.4.1	0.013	0.050	16.62
5.4.0	0.013	0.060	15.95
5.3.28	0.017	0.053	14.71
5.3.27	0.010	0.060	14.72
5.3.26	0.023	0.047	14.54
5.3.25	0.013	0.073	14.40
5.3.24	0.017	0.063	14.54
5.3.23	0.013	0.070	14.78
5.3.22	0.007	0.073	14.63
5.3.21	0.010	0.053	14.55
5.3.20	0.010	0.060	14.77
5.3.19	0.013	0.057	14.57
5.3.18	0.010	0.073	14.74
5.3.17	0.007	0.063	14.63
5.3.16	0.023	0.040	14.70
5.3.15	0.023	0.063	14.55
5.3.14	0.010	0.063	14.64
5.3.13	0.013	0.057	14.54
5.3.12	0.013	0.073	14.70
5.3.11	0.007	0.077	14.43
5.3.10	0.013	0.053	14.15
5.3.9	0.007	0.067	14.21
5.3.8	0.020	0.053	14.17
5.3.7	0.007	0.067	14.06
5.3.6	0.013	0.053	7.48
5.3.5	0.007	0.073	14.11
5.3.4	0.010	0.067	13.99
5.3.3	0.007	0.060	13.90
5.3.2	0.013	0.043	13.62
5.3.1	0.003	0.057	13.46
5.3.0	0.007	0.057	13.79

preferences:dark modelive preview