58 lines
1.8 KiB
PHP
58 lines
1.8 KiB
PHP
<?php
|
|
$host_sekarang = $_SERVER['HTTP_HOST'];
|
|
|
|
// Cek apakah URL yang sedang diakses mengandung kata 'localhost' atau '127.0.0.1'
|
|
if (strpos($host_sekarang, 'localhost') !== false || strpos($host_sekarang, '127.0.0.1') !== false) {
|
|
$host = "localhost";
|
|
$user = "root";
|
|
$pass = "";
|
|
$db = "webgis_db_pertemuan1";
|
|
} else {
|
|
// Gunakan Kredensial Normal User dari Coolify
|
|
$host = "b84c4osgw4kcw0wc8o8cg8cg";
|
|
$user = "mysql"; // Menggunakan normal user
|
|
$pass = "YN54ned6j7P6K7c76sLqh9ERUbm8xvhPFj31Mnt0yKPXxqrIhWICWlbJbJjUCfn7"; // Normal User Password
|
|
$db = "webgis_db_pertemuan1";
|
|
}
|
|
|
|
|
|
// Connect first without DB to ensure we can create it if missing
|
|
$conn = new mysqli($host, $user, $pass);
|
|
|
|
if ($conn->connect_error) {
|
|
die("Koneksi gagal: " . $conn->connect_error);
|
|
}
|
|
|
|
// Create database if not exists
|
|
$conn->query("CREATE DATABASE IF NOT EXISTS `$db` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;");
|
|
|
|
// Select database
|
|
$conn->select_db($db);
|
|
|
|
// Auto create tables if not exist
|
|
// Table: jalan (for polyline data)
|
|
$sql_jalan = "CREATE TABLE IF NOT EXISTS `jalan` (
|
|
`id` INT AUTO_INCREMENT PRIMARY KEY,
|
|
`nama_jalan` VARCHAR(255) NOT NULL,
|
|
`status` VARCHAR(100) NOT NULL,
|
|
`panjang` DECIMAL(10,2) NOT NULL,
|
|
`koordinat` TEXT NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";
|
|
|
|
// Table: parsil (for polygon data)
|
|
$sql_parsil = "CREATE TABLE IF NOT EXISTS `parsil` (
|
|
`id` INT AUTO_INCREMENT PRIMARY KEY,
|
|
`nama_pemilik` VARCHAR(255) NOT NULL,
|
|
`status` VARCHAR(100) NOT NULL,
|
|
`luas` DECIMAL(10,2) NOT NULL,
|
|
`koordinat` TEXT NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";
|
|
|
|
if (!$conn->query($sql_jalan)) {
|
|
die("Gagal membuat tabel jalan: " . $conn->error);
|
|
}
|
|
|
|
if (!$conn->query($sql_parsil)) {
|
|
die("Gagal membuat tabel parsil: " . $conn->error);
|
|
}
|