$queryTokenGCM->bindParam(":group", $group);
$queryTokenAPN = $handler->prepare("SELECT `deviceToken` FROM `user` WHERE length(trim(`deviceToken`))=64 and`group`=:group");
$queryTokenAPN->bindParam(":group", $group);
}
if ($queryTokenGCM->execute()) {
$countTokenGCM = $queryTokenGCM->rowCount();
if ($countTokenGCM > 0) {
//$gcmResults = $queryTokenGCM->fetchAll(PDO::FETCH_ASSOC);
$gcmTokens = $queryTokenGCM->fetchAll(PDO::FETCH_COLUMN, 0);
//echo "new line " . $gcmResults . 'deviceToken';
//print_r(array_values($gcmResults));
//$gcmTokens = array_column($gcmResults, 'deviceToken');
//echo "find error1";
//$gcmTokens = array_column($gcmResults, 'deviceToken');
//echo "find error2";
send_gcm_notify($gcmTokens, $message);
}
}
if ($queryTokenAPN->execute()) {
$countTokenAPN = $queryTokenAPN->rowCount();
if ($countTokenAPN > 0) {
//$apnResults = $queryTokenAPN->fetchAll(PDO::FETCH_ASSOC);
//$apnTokens = array_column($apnResults, 'deviceToken');
$apnTokens = $queryTokenAPN->fetchAll(PDO::FETCH_COLUMN, 0);
send_apn_notify($apnTokens, $message);
}
}
}
} catch (Exception $e) {
respf("ERROR", "NULL", $e);
}
// pass varialbe $instantSpeed to SQL parameter ":InstantSpeed"
if ($query->execute()) {
//echo "it has been inserted id=" . $handler->lastInsertId();
$results = "it has been inserted: id=" . $handler->lastInsertId();
respf("SUCCESS", $results, "");
//get device tokens from group
$queryToken = $handler->prepare("SELECT `deviceToken` FROM `user` WHERE `group`=:group");
$queryToken->bindParam(":group", $group);
if ($queryToken->execute()) {
//$countToken = $queryToken->rowCount();
if ($countToken > 0) {
while ($row = $queryToken->fetch(PDO::FETCH_ASSOC)) {
if (strlen($row['deviceToken']) == 140) {
send_gcm_notify($row['deviceToken'], $message);
} elseif (strlen($row['deviceToken']) == 64) {
send_apn_notify($row['deviceToken'], $message);
} else {
echo "no push for " . ${$row}['deviceToken'];
}
}
}
}
//$deviceTokens = ["APA91bEwH6Oc9s4BO1OWHutah-rB9KefrH4m-6gCoTiquxJ15Ji12b0GetHbBwp6F2PIgbHZKfREssgif6HSDqaz-Xp-eQ9sIQ56bp4pM644tgRmHn5AVwWq4D6vNx5hMqBoXRTcqjGH", "APA91bHlR9ZzGXFRzqfe4pZ-JHBLwz78vD8ftJTEf-UsoEO8dKyconSYGKouT6JGmWI9oAuqRDUsKlujwdJPuRBwFEw2ZVSke1Ech5zSWqpA5YL4rCj63TOVodLuZNuQCnRwKwfHDnGV"];
//sendMessage($deviceTokens, $handler->lastInsertId(), "2");
}
//$reg_id = "APA91bGVFQzwDmP0Eb2FVf6lYKKpchcp_3Y-lnn4fq87D_d_64vBqG_XBk4qy2tihyAiBwX9Bg8Owv8xAQgELtvqIjv9TVIu96sKZCXCdAWVM4YBmOJBAJ_9OkZfFz9jGGFWx7ijMQX5";
//$msg = "Google Cloud Messaging working well";
//send_gcm_notify($reg_id, $msg);
} catch (Exception $e) {
//echo $e->getMessage();
respf("ERROR", "NULL", $e);
