raditarahman5-cloud
26 lines
1.1 KiB
PHP
26 lines
1.1 KiB
PHP
<?php
|
|
session_start();
|
|
if (!isset($_SESSION['login'])) { exit('Unauthorized'); }
|
|
require 'db.php';
|
|
|
|
// Seed Jalan
|
|
$conn->query('TRUNCATE TABLE jalan');
|
|
$jalan1 = '[{"lat":-0.0528,"lng":109.3409},{"lat":-0.0556,"lng":109.3432},{"lat":-0.0601,"lng":109.3463}]';
|
|
$jalan2 = '[{"lat":-0.0343,"lng":109.3431},{"lat":-0.0308,"lng":109.3411}]';
|
|
$sqlJalan = "INSERT INTO jalan (nama_jalan, status_jalan, panjang_m, koordinat) VALUES
|
|
('Jl. Jenderal Ahmad Yani', 'Nasional', 1200, '$jalan1'),
|
|
('Jl. Gajah Mada', 'Provinsi', 800, '$jalan2')";
|
|
$conn->query($sqlJalan);
|
|
|
|
// Seed Parsil / Bangunan
|
|
$conn->query('TRUNCATE TABLE parsil');
|
|
$parsil1 = '[{"lat":-0.0520,"lng":109.3400},{"lat":-0.0520,"lng":109.3415},{"lat":-0.0535,"lng":109.3415},{"lat":-0.0535,"lng":109.3400}]';
|
|
$parsil2 = '[{"lat":-0.0468,"lng":109.3361},{"lat":-0.0468,"lng":109.3385},{"lat":-0.0487,"lng":109.3385},{"lat":-0.0487,"lng":109.3361}]';
|
|
$sqlParsil = "INSERT INTO parsil (nama_pemilik, status_hak, koordinat) VALUES
|
|
('Kompleks Kantor Gubernur Kalbar', 'HP', '$parsil1'),
|
|
('Area Masjid Raya Mujahidin', 'SHM', '$parsil2')";
|
|
$conn->query($sqlParsil);
|
|
|
|
echo "Berhasil insert data jalan dan parsil (bangunan).";
|
|
?>
|