<?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; ?>
You have javascript disabled. You will not be able to edit any code.