Setup Database Automatis";
$host = getenv("DB_HOST") ?: "localhost";
$user = getenv("DB_USER") ?: "root";
$pass = getenv("DB_PASS") ?: "fira123";
// Koneksi tanpa nama database dulu untuk bikin database-nya
$conn = new mysqli($host, $user, $pass);
if ($conn->connect_error) {
die("Koneksi gagal: " . $conn->connect_error);
}
echo "✅ Terhubung ke server MySQL ($host)
";
// 1. Setup WEBGIS
echo "1. Setup Database WEBGIS
";
$sql_webgis = file_get_contents(__DIR__ . '/WEBGIS/01/api/setup_webgis.sql');
if ($conn->multi_query($sql_webgis)) {
do {
if ($res = $conn->store_result()) {
$res->free();
}
} while ($conn->more_results() && $conn->next_result());
echo "✅ Import WEBGIS berhasil!
";
} else {
echo "❌ Error import WEBGIS: " . $conn->error . "
";
}
// Tunggu multi_query selesai
while ($conn->more_results() && $conn->next_result());
// Patch: Tambah kolom 'alamat' ke tabel spbu jika belum ada
$conn->select_db("webgis");
$check = $conn->query("SHOW COLUMNS FROM spbu LIKE 'alamat'");
if ($check && $check->num_rows === 0) {
$conn->query("ALTER TABLE spbu ADD COLUMN alamat TEXT AFTER status");
echo "✅ Kolom 'alamat' ditambahkan ke tabel spbu!
";
} else {
echo "✅ Kolom 'alamat' sudah ada di tabel spbu.
";
}
// Patch: Fix kolom 'status' jika masih ENUM('Ya','Tidak')
$conn->query("ALTER TABLE spbu MODIFY COLUMN status VARCHAR(50) NOT NULL DEFAULT 'Tidak Buka 24 Jam'");
// 2. Setup KEMISKINAN_IBADAH
echo "2. Setup Database Kemiskinan & Ibadah
";
$conn->query("CREATE DATABASE IF NOT EXISTS kemiskinan_ibadah CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;");
$conn->select_db("kemiskinan_ibadah");
$sql_webtugas = file_get_contents(__DIR__ . '/webtugas/01/api/setup_webtugas.sql');
if ($conn->multi_query($sql_webtugas)) {
do {
if ($res = $conn->store_result()) {
$res->free();
}
} while ($conn->more_results() && $conn->next_result());
echo "✅ Import Kemiskinan & Ibadah berhasil!
";
} else {
echo "❌ Error import Kemiskinan & Ibadah: " . $conn->error . "
";
}
$conn->close();
echo "🎉 Setup Selesai!
";
echo "Kembali ke Home
";
?>