<?php if (session_status() == PHP_SESSION_NONE) { session_start(); } include_once '../db/koneksi.php'; // Pastikan koneksi benar // Pastikan variabel $db terdefinisi $db = $koneksi ?? $conn ?? $db_connect ?? $link ?? null; // Daftar Pasaran (HARUS SAMA dengan yang ada di togel.php) $master_pasaran = [ ['key' => 'Sydney Pools', 'param' => 'SYDNEY'], ['key' => 'Singapore', 'param' => 'SINGAPORE'], ['key' => 'Hongkong Pools', 'param' => 'HONGKONG POOLS'], ['key' => 'Hongkong lotto', 'param' => 'HONGKONG LOTTO'], ['key' => 'Sydney Lotto', 'param' => 'SYDNEY LOTTO'], ['key' => 'TOTO MACAU 13', 'param' => 'TOTO MACAU 13'], ['key' => 'TOTO MACAU 16', 'param' => 'TOTO MACAU 16'], ['key' => 'TOTO MACAU 19', 'param' => 'TOTO MACAU 19'], ['key' => 'TOTO MACAU 22', 'param' => 'TOTO MACAU 22'], ['key' => 'Toto Macau 23', 'param' => 'TOTO MACAU 23'], ['key' => 'Toto Macau 00', 'param' => 'TOTO MACAU 00'], ['key' => 'CALIFORNIA D4', 'param' => 'CALIFORNIA D4'], ['key' => 'FLORIDA EVE', 'param' => 'FLORIDA EVE'], ['key' => 'MISSOURI EVE', 'param' => 'MISSOURI EVE'], ['key' => 'KENTUCKY EVE', 'param' => 'KENTUCKY EVE'], ['key' => 'NEW YORK EVE', 'param' => 'NEW YORK EVE'], ['key' => 'CAROLINE EVE', 'param' => 'CAROLINA EVE'], ['key' => 'MAGNUM CAMBODIA', 'param' => 'MAGNUM CAMBODIA'], ['key' => 'BULLSEYE', 'param' => 'BULLSEYE'], ['key' => 'OREGON 7 PM', 'param' => 'OREGON 7 PM'], ['key' => 'OREGON 10 PM', 'param' => 'OREGON 10 PM'], ['key' => 'CHINA POOLS', 'param' => 'CHINA POOLS'], ['key' => 'JAPAN POOLS', 'param' => 'JAPAN POOLS'], ['key' => 'TAIWAN', 'param' => 'TAIWAN'], ['key' => 'NEW YORK MID', 'param' => 'NEW YORK MID'], ['key' => 'MISSOURI MID', 'param' => 'MISSOURI MID'], ['key' => 'KENTUCKY MID', 'param' => 'KENTUCKY MID'], ['key' => 'CAROLINA DAY', 'param' => 'CAROLINA DAY'], ['key' => 'CAROLINE EVE', 'param' => 'CAROLINA EVE'], ['key' => 'PCSO', 'param' => 'PCSO'], ['key' => 'MOROCCO 4', 'param' => 'MOROCCO 4'], ['key' => 'OREGON 1 PM', 'param' => 'OREGON 1 PM'], ['key' => 'GEORGIA C4 MID', 'param' => 'GEORGIA C4 MID'], ['key' => 'MARYLAND MID', 'param' => 'MARYLAND MID'], ['key' => 'NEW JERSEY MID', 'param' => 'NEW JERSEY MID'], ['key' => 'GERMANY PLUS', 'param' => 'GERMANY PLUS'], ]; // Proses Simpan if (isset($_POST['simpan'])) { $pasaran = $_POST['pasaran']; // Ini akan menyimpan nilai 'param' (misal: SYDNEY) $hari = mysqli_real_escape_string($db, $_POST['hari']); $tanggal = mysqli_real_escape_string($db, $_POST['tanggal']); $hasil = mysqli_real_escape_string($db, $_POST['hasil']); // Cek apakah data sudah ada (Update) atau belum (Insert) $cek = mysqli_query($db, "SELECT id FROM pengeluaran_togel WHERE pasaran = '$pasaran' AND tanggal = '$tanggal'"); if (mysqli_num_rows($cek) > 0) { $query = "UPDATE pengeluaran_togel SET hasil = '$hasil', hari = '$hari' WHERE pasaran = '$pasaran' AND tanggal = '$tanggal'"; } else { $query = "INSERT INTO pengeluaran_togel (pasaran, hari, tanggal, hasil) VALUES ('$pasaran', '$hari', '$tanggal', '$hasil')"; } if (mysqli_query($db, $query)) { echo "<script>alert('Berhasil Update Result'); window.location.href='?page=input_manual_result';</script>"; } } // Proses Hapus Data if (isset($_GET['hapus'])) { $id_hapus = mysqli_real_escape_string($db, $_GET['hapus']); mysqli_query($db, "DELETE FROM pengeluaran_togel WHERE id = '$id_hapus'"); echo "<script>alert('Data berhasil dihapus'); window.location.href='?page=input_manual_result';</script>"; } ?> <div class="card mb-4"> <h5 class="card-header">Form Input Result Manual</h5> <div class="card-body"> <form action="" method="POST"> <div class="row"> <div class="col-md-6 mb-3"> <label class="form-label">Pilih Pasaran</label> <select name="pasaran" class="form-select" required> <option value="">-- Pilih Pasaran --</option> <?php foreach ($master_pasaran as $p) { ?> <option value="<?php echo $p['param']; ?>"><?php echo $p['key']; ?></option> <?php } ?> </select> </div> <div class="col-md-6 mb-3"> <label class="form-label">Hari</label> <input type="text" name="hari" class="form-control" placeholder="Contoh: Senin" required> </div> </div> <div class="row"> <div class="col-md-6 mb-3"> <label class="form-label">Tanggal</label> <input type="date" name="tanggal" class="form-control" required> </div> <div class="col-md-6 mb-3"> <label class="form-label">Hasil (Angka)</label> <input type="text" name="hasil" class="form-control" placeholder="Contoh: 1234" required> </div> </div> <button type="submit" name="simpan" class="btn btn-primary">Simpan Result</button> </form> </div> </div> <!-- Tabel Daftar Pengeluaran (Sama seperti sebelumnya) --> <div class="card"> <h5 class="card-header">Daftar Pengeluaran Togel</h5> <div class="table-responsive text-nowrap"> <table class="table table-hover"> <thead> <tr> <th>No</th> <th>Pasaran</th> <th>Hari</th> <th>Tanggal</th> <th>Hasil</th> <th>Aksi</th> </tr> </thead> <tbody> <?php $query = mysqli_query($db, "SELECT * FROM pengeluaran_togel ORDER BY id DESC LIMIT 50"); $no = 1; while ($row = mysqli_fetch_assoc($query)) { ?> <tr> <td><?php echo $no++; ?></td> <td><?php echo $row['pasaran']; ?></td> <td><?php echo $row['hari']; ?></td> <td><?php echo $row['tanggal']; ?></td> <td><span class="badge bg-label-primary"><?php echo $row['hasil']; ?></span></td> <td> <a href="?page=input_manual_result&hapus=<?php echo $row['id']; ?>" class="btn btn-sm btn-danger" onclick="return confirm('Apakah Anda yakin ingin menghapus data ini?')"> Hapus </a> </td> </tr> <?php } ?> </tbody> </table> </div> </div> SIMPAN PERUBAHAN