50 lines
1.1 KiB
PHP
50 lines
1.1 KiB
PHP
<?php
|
|
include 'koneksi.php';
|
|
|
|
$type = $_POST['type'];
|
|
|
|
// =====================
|
|
// UPDATE SPBU
|
|
// =====================
|
|
if($type == 'spbu'){
|
|
|
|
$id = $_POST['id'];
|
|
$nama = $_POST['nama_spbu'];
|
|
$wa = $_POST['no_wa'];
|
|
$status = $_POST['status'];
|
|
|
|
$stmt = $conn->prepare("UPDATE lokasi SET nama_spbu=?, no_wa=?, status=? WHERE id=?");
|
|
$stmt->bind_param("sssi", $nama, $wa, $status, $id);
|
|
$stmt->execute();
|
|
}
|
|
|
|
// =====================
|
|
// UPDATE JALAN
|
|
// =====================
|
|
elseif($type == 'jalan'){
|
|
|
|
$id = $_POST['id'];
|
|
$nama = $_POST['nama_jalan'];
|
|
$status = $_POST['status'];
|
|
|
|
$stmt = $conn->prepare("UPDATE jalan SET nama_jalan=?, status=? WHERE id=?");
|
|
$stmt->bind_param("ssi", $nama, $status, $id);
|
|
$stmt->execute();
|
|
}
|
|
|
|
// =====================
|
|
// UPDATE KAVLING
|
|
// =====================
|
|
elseif($type == 'kavling'){
|
|
|
|
$id = $_POST['id'];
|
|
$pemilik = $_POST['pemilik'];
|
|
$status = $_POST['status'];
|
|
|
|
$stmt = $conn->prepare("UPDATE kavling SET pemilik=?, status=? WHERE id=?");
|
|
$stmt->bind_param("ssi", $pemilik, $status, $id);
|
|
$stmt->execute();
|
|
}
|
|
|
|
echo "OK";
|
|
?>
|