body{font-family:monospace;padding:20px;background:#111;color:#0f0;} .ok{color:#0f0} .err{color:#f44} .warn{color:#fa0}"; echo "

🔍 Cek Koneksi & Database SPBU

"; if ($koneksi) { echo "

✅ Koneksi ke MySQL berhasil

"; } else { echo "

❌ Koneksi GAGAL: " . mysqli_connect_error() . "

"; exit; } $db_cek = mysqli_query($koneksi, "SELECT DATABASE() AS db"); $db_row = mysqli_fetch_assoc($db_cek); echo "

✅ Database aktif: {$db_row['db']}

"; echo "

✅ Nama tabel: $nama_tabel

"; $tabel_cek = mysqli_query($koneksi, "SHOW TABLES LIKE '$nama_tabel'"); if (mysqli_num_rows($tabel_cek) > 0) { echo "

✅ Tabel $nama_tabel ditemukan

"; } else { echo "

❌ Tabel $nama_tabel TIDAK ADA!

"; echo "

⚠️ Jalankan schema_mysql.sql di phpMyAdmin

"; exit; } $count_cek = mysqli_query($koneksi, "SELECT COUNT(*) AS total FROM `$nama_tabel`"); $count_row = mysqli_fetch_assoc($count_cek); echo "

✅ Jumlah data: {$count_row['total']} baris

"; $test = mysqli_query($koneksi, "INSERT INTO `$nama_tabel` (nama_spbu, no_wa, status_24_jam, lat, lng) VALUES ('TEST_DELETE_ME', '000', 'no', 0, 0)"); if ($test) { $ins_id = mysqli_insert_id($koneksi); mysqli_query($koneksi, "DELETE FROM `$nama_tabel` WHERE id = $ins_id"); echo "

✅ Test INSERT & DELETE berhasil — database siap digunakan!

"; } else { echo "

❌ Test INSERT gagal: " . mysqli_error($koneksi) . "

"; } echo "

File ini bisa dihapus setelah tidak diperlukan.