<?php
$host = 'ifuntanhub.dev';
$port = 33060;
$user = 'mysql';
$pass = '6PRtFLPtC2yBZyKyxuuitJWUtII078Kp6O0SEFhnGUTVcJX40K4HvUHtI8utyVFp';
$name = 'db_webgis';

$conn = new mysqli($host, $user, $pass, $name, $port);
if ($conn->connect_error) {
    die("Koneksi gagal: " . $conn->connect_error . "\n");
}
echo "Koneksi berhasil!\n";

$sql = file_get_contents(__DIR__ . '/uas/db_webgis.sql');
if ($conn->multi_query($sql)) {
    do {
        $conn->store_result();
    } while ($conn->next_result());
    echo "Import selesai!\n";
} else {
    echo "Error: " . $conn->error . "\n";
}
$conn->close();