public static function sendGCMMessage($title, $msg, $eventoId, $disciplina) { include "../webservice/connection/Connect.php"; $db = new Connect(); $connection = $db->connect(); //$acao = $_POST['acao']; // if ($acao == "enviar") { $jsonArray = array(); $sql = $connection->prepare("SELECT app_dispositivo.registration_id FROM henriqueweb.app_dispositivo"); $sql->execute(); if ($sql->rowCount() > 0) { while ($tmp = $sql->fetch()) { $jsonArray[] = $tmp["registration_id"]; } } //$mensagem = $_POST["mensagem"]; //$eventoId = $_POST["eventoId"]; $url = "https://gcm-http.googleapis.com/gcm/send"; $apiKey = "AIzaSyD4-EStQ8w7G8FP2plyIkIOJ10LljchUpw"; $ch = curl_init($url); $jsonData = array("registration_ids" => $jsonArray, "data" => array("type" => "evento", "title" => $title, "disciplina" => $disciplina, "eventoId" => $eventoId, "mensagem" => $msg)); $jsonDataEncoded = json_encode($jsonData); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $jsonDataEncoded); curl_setopt($ch, CURLOPT_HTTPHEADER, array("Content-Type: application/json", "Authorization: key=" . $apiKey)); $result = curl_exec($ch); //} }
<?php header('Content-Type: application/json; Charset=UTF-8'); include "../connection/Connect.php"; $db = new Connect(); $connection = $db->connect(); $sql = "UPDATE app_rating_disciplina SET app_rating = ? WHERE (app_aluno_key = ?) AND (app_disciplina_key = ?)"; $query = $connection->prepare($sql); $disciplinaRating = $_POST['disciplinaRating']; $alunoKey = $_POST['alunoKey']; $disciplinaKey = $_POST['disciplinaKey']; $query->execute(array($disciplinaRating, $alunoKey, $disciplinaKey)); $returnJson = array("updated" => $query->rowCount()); echo json_encode($returnJson);