I am trying to broadcast a message to every Telegram bot subscriber without duplicates. My PHP code repeatedly sends messages until the database is cleared. Code example:
function sendBroadcastMessage($userId, $textContent) {
$apiEndpoint = API_URL . "/send?chat_id=" . $userId . "&message=" . urlencode($textContent);
file_get_contents($apiEndpoint);
}
function broadcastAll($textContent) {
$resultSet = $db->query("SELECT chat_id FROM subscribers");
foreach ($resultSet->fetchAll() as $user) {
sendBroadcastMessage($user['chat_id'], $textContent);
}
exit();
}