I have a PHP code for sending pushNotifications to registered mobiles. The notification includes fields of database like "Collection Title", "Community" and a "Collection handle (unique ID)". After the message is received on mobile, when the user clicks on that message, I want a webview of that particular collection handle in android app.
I have searched through various posts, however I am unable to get the desired code. Any help in this regard would be highly appreciated.
Excerpts of "sendnotification.php" file
$sql1 = "SELECT community.name as inst, collection.name as coll,
handle.handle as handle FROM community2collection, collection2item, handle, community, collection WHERE community2collection.collection_id = collection2item.collection_id AND community.community_id = community2collection.community_id AND collection.collection_id = collection2item.collection_id AND collection2item.item_id = handle.resource_id
ORDER BY handle.handle_id desc limit 2";
$result1 = pg_exec($cnn, $sql1);
$numrows1 = pg_numrows($result1);
echo "numrows1=" . $numrows1;
for($ri = 0; $ri < $numrows1; $ri++) {
$row = pg_fetch_array($result1, $ri);
echo "row=" . $ri;
$pushMessage = $row[1]. " submitted by " .$row[0];
if(isset($gcmRegIds) && isset($pushMessage)) {
$message = array('message' => $pushMessage);
echo $pushMessage;
$pushStatus = sendPushNotification($gcmRegIds, $message);
echo $pushStatus;
echo "row2field=" .$row[2];
Here I want to create the URL dynamically for specific handle in the notification in android app i.e. based on field $row(2) in the code above. I am using GCM service for sending notifications.