prepare("SELECT * FROM v_pelanggan WHERE id = :id"); $stmt->execute(['id' => $page[1]]); $isi = $stmt->fetch(PDO::FETCH_ASSOC); $remoteonu = encrypt_url('user_remote|'.$isi['id'].'|'.$isi['id_setting_mikrotik']); ?>

ID Pelanggan :

Identitas Pelanggan

NIK

Marketing

Koneksi & Teknis

IP Address

MAC

Serial ONU

Status Koneksi

Lokasi

Alamat

Koordinat

Desa

Topologi

Port ODP

Catatan

Form Update

Serial Number

Tipe WiFi ONU

Tipe ONU

Brand ONU

TX Power

RX Power

modify('-1 month'); $mulaiBayarFix = $date1->format('Y-m-d'); $SQL = "UPDATE pelanggan SET serial_number = :serial_number, onu_type = :onu_type, onu_brand = :onu_brand, onu_wireless = :onu_wireless, tx_power = :tx_power, rx_power = :rx_power WHERE id = :id"; try { $stmt = $pdo->prepare($SQL); $stmt->execute([ ':serial_number' => $serialnumber, ':onu_type' => $_POST['onu_type'], ':onu_brand' => $_POST['onu_brand'], ':onu_wireless' => $_POST['onu_wireless'], ':tx_power' => $_POST['tx_power'], ':rx_power' => $_POST['rx_power'], ':id' => $page[1] ]); sweetAlert("Data pelanggan berhasil diubah ", "success"); } catch (PDOException $e) { // Handle error appropriately sweetAlert("Error: " . $e->getMessage(), "error"); // echo "Error: " . $e->getMessage(); } } ?>