$chatId, 'text' => $message ]; $options = [ 'http' => [ 'method' => 'POST', 'header' => "Content-Type:application/x-www-form-urlencoded\r\n", 'content' => http_build_query($data) ] ]; $context = stream_context_create($options); file_get_contents($apiURL, false, $context); } // Retrieving UID from GET parameter $uid = $_GET['id']; $add_balance = $_POST['add_balance']; // Connecting to the database $pdo = Database::connect(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // Retrieve user data based on UID $sql = "SELECT * FROM siswa_wali WHERE id = ?"; $q = $pdo->prepare($sql); $q->execute(array($uid)); $user = $q->fetch(PDO::FETCH_ASSOC); // Check if user exists if ($user) { // Update balance by subtracting 100000 $newBalance = $user['balance'] + $add_balance; // Update balance in the database $updateSql = "UPDATE siswa_wali SET balance = ? WHERE id = ?"; $updateStmt = $pdo->prepare($updateSql); $updateStmt->execute(array($newBalance, $uid)); if ($updateStmt) { $Write = ""; file_put_contents('sendNewBalance.php', $Write); } // Send notification message via Telegram bot $Write = ""; file_put_contents('sendNewBalance.php', $Write); // Send notification message via Telegram bot $message = "Halo " . $user['name'] . "\nAnda melakukan setor tunai sebanyak: " . $add_balance . ",\nSaldo saat ini adalah Rp : " . $newBalance; sendMessage($user['chatId'], $message); echo "

Please Scan Tag to Display ID or User Data

User Data

ID	:	{$user['id']}
Nama	:	{$user['name']}
Jenis Kelamin	:	{$user['gender']}
Email	:	{$user['email']}
No.Telp	:	{$user['mobile']}
Saldo	:	$newBalance

"; } else { // User not found, handle accordingly echo "User not found"; } // Close the database connection Database::disconnect(); ?>