function postDrawing()
{
/* require the message the parameter */
if (isset($_GET['image']) && isset($_GET['location_id'])) {
$image = $_GET['image'];
$location_id = isset($_GET['location_id']) ? $_GET['location_id'] : 1;
//default is 1
$dbc = connectToDB();
/* insert the message into the message table query*/
$query = "INSERT INTO drawing (image, location_id) VALUES (\"{$image}\", {$location_id})";
$result = performQuery($dbc, $query);
//inserted in the database
echo "postMessage works yay";
return header('status: 200');
} else {
echo "malfunction";
errorJson('Upload malfunction');
}
}
function stream($IdPhoto = 0)
{
if ($IdPhoto == 0) {
// load the last 50 photos from the "photos" table, also join the "login" so that you can fetch the
// usernames of the photos' authors
$result = query("SELECT IdPhoto, title, l.IdUser, username FROM photos p JOIN login l ON (l.IdUser = p.IdUser) ORDER BY IdPhoto DESC LIMIT 50");
} else {
//do the same as above, but just for the photo with the given id
$result = query("SELECT IdPhoto, title, l.IdUser, username FROM photos p JOIN login l ON (l.IdUser = p.IdUser) WHERE p.IdPhoto='%d' LIMIT 1", $IdPhoto);
}
if (!$result['error']) {
// if no error occured, print out the JSON data of the
// fetched photo data
print json_encode($result);
} else {
//there was an error, print out to the iPhone app
errorJson(-1, 'Photo stream is broken');
}
}
