- array_push: documentation ( source)
- json_encode: documentation ( source)
- header: documentation ( source)
<?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;
}
}
?>