$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); } $id = null; if (!empty($_GET['id'])) { $id = $_REQUEST['id']; } date_default_timezone_set('Asia/Jakarta'); $date = date('Y-m-d H:i:s'); // Fetch student data $pdo = Database::connect(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = "SELECT * FROM siswa_wali WHERE id = ?"; $q = $pdo->prepare($sql); $q->execute(array($id)); $data = $q->fetch(PDO::FETCH_ASSOC); Database::disconnect(); $name = $data['name']; $class = $data['class']; // Assuming $name, $class, $chatId are defined somewhere $chatId = $data['chatId']; // echo json_encode($chatId); // die(); $message = "Halo $name, berhasil melakukan Absensi, Kelas $class. Pada $date."; sendMessage($chatId, $message); // Write to file (this part wasn't explained clearly, assuming it's for logging purposes) $Write = ""; file_put_contents('sendNewBalance.php', $Write); if($data){ // Get current date and time // Insert data into 'absen' table $pdo = Database::connect(); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = "INSERT INTO absen (name, id, gender, email, mobile, date, class) VALUES (?, ?, ?, ?, ?, ?, ?)"; $q = $pdo->prepare($sql); $q->execute(array($data['name'], $data['id'], $data['gender'], $data['email'], $data['mobile'], $date, $data['class'])); Database::disconnect(); } $msg = null; if (null == $data['name']) { // Student not found, set default values $msg = "The ID of your Card / KeyChain is not registered !!!"; $data['id'] = $id; $data['name'] = "--------"; $data['gender'] = "--------"; $data['email'] = "--------"; $data['mobile'] = "--------"; $data['class'] = "--------"; $data['chatId'] = "--------"; } ?>