<?php include_once './dbInstance.php'; include_once './dbConfig.php'; $mDbInstance = new dbInstance(); $mDbInstance->dbConnect(); $mDbInstance->dbUpdate(19, 'mariajo'); $mDbInstance->dbDelete(15); $mDbInstance->dbDisconnect();
// Get all 'registration IDs' from database $userRegIds = $mDbInstance->dbGetAllUsers(); $mGcmInstance = new gcmInstance(); for ($i = 0; $i < mysqli_num_rows($userRegIds); $i++) { $userArray = mysqli_fetch_row($userRegIds); // Send message to devices and getting back a new 'registration ID' in case it has been updated by the GCM server $gcmSuccess = $mGcmInstance->sendNotification($userArray, $message); if ($gcmSuccess) { // If the return value is not '', the entry has to be updated ('dbInsert' with a third argument) if ($mGcmInstance->newId != '') { //echo 'From dbInstance, result: ' . $mGcmInstance->newId . PHP_EOL; $resultQuery = $mDbInstance->dbInsert($mGcmInstance->newId, "", $userArray[0]); echo 'Update query result: ' . $resultQuery . PHP_EOL; // If '0' is retrieved, no update has been performed, and therefore the entry is repeated if ($resultQuery == 0) { $resultQuery = $mDbInstance->dbDelete($userArray[0]); echo 'Entry deleted' . PHP_EOL; } } } else { if ($mGcmInstance->error != '') { echo 'From dbInstance, error: ' . $mGcmInstance->error . PHP_EOL; $resultQuery = $mDbInstance->dbDelete($userArray[0]); echo 'Entry deleted: ' . $resultQuery . PHP_EOL; } } // Reset 'gcmInstance' values for next iteration $mGcmInstance->newId = ''; $mGcmInstance->error = ''; } mysqli_free_result($userRegIds);