140 lines
6.2 KiB
PHP
140 lines
6.2 KiB
PHP
<?php
|
|
include '../template/template1.php';
|
|
include '../template/header.php';
|
|
include '../template/sidebar.php';
|
|
|
|
// Ambil data usaha dari tabel profil
|
|
$query = mysqli_query($conn, "SELECT * FROM profil LIMIT 1");
|
|
$usaha = mysqli_fetch_assoc($query);
|
|
|
|
// Jika tombol simpan ditekan
|
|
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
|
|
$nama_usaha = $_POST['nama_usaha'];
|
|
$alamat = $_POST['alamat'];
|
|
$no_hp = $_POST['no_hp'];
|
|
$email = $_POST['email'];
|
|
$deskripsi = $_POST['deskripsi'];
|
|
$link_youtube = $_POST['link_youtube'];
|
|
$link_ig = $_POST['link_ig'];
|
|
$link_tiktok = $_POST['link_tiktok'];
|
|
$hari_buka = $_POST['hari_buka'];
|
|
$hari_tutup = $_POST['hari_tutup'];
|
|
$jam_buka = $_POST['jam_buka'];
|
|
$jam_tutup = $_POST['jam_tutup'];
|
|
|
|
// Upload gambar
|
|
$gambar = $usaha['gambar'];
|
|
if (!empty($_FILES['gambar']['name'])) {
|
|
$gambar = "uploads/" . time() . "_" . $_FILES['gambar']['name'];
|
|
move_uploaded_file($_FILES['gambar']['tmp_name'], $gambar);
|
|
}
|
|
|
|
// Upload logo
|
|
$logo = $usaha['logo'];
|
|
if (!empty($_FILES['logo']['name'])) {
|
|
$logo = "uploads/" . time() . "_" . $_FILES['logo']['name'];
|
|
move_uploaded_file($_FILES['logo']['tmp_name'], $logo);
|
|
}
|
|
|
|
// Update database
|
|
$sql = "UPDATE profil SET
|
|
nama_usaha='$nama_usaha', alamat='$alamat', no_hp='$no_hp', email='$email',
|
|
deskripsi='$deskripsi', gambar='$gambar', logo='$logo',
|
|
link_youtube='$link_youtube', link_ig='$link_ig', link_tiktok='$link_tiktok',
|
|
hari_buka='$hari_buka', hari_tutup='$hari_tutup', jam_buka='$jam_buka', jam_tutup='$jam_tutup'
|
|
WHERE id_usaha = {$usaha['id_usaha']}";
|
|
|
|
if (mysqli_query($conn, $sql)) {
|
|
echo "<script>alert('Data usaha berhasil diperbarui!');window.location.href='index.php';</script>";
|
|
} else {
|
|
echo "<script>alert('Gagal memperbarui data usaha!');</script>";
|
|
}
|
|
}
|
|
?>
|
|
|
|
<main id="main" class="main">
|
|
<div class="pagetitle">
|
|
<h1>Pengaturan Usaha</h1>
|
|
<nav>
|
|
<ol class="breadcrumb">
|
|
<li class="breadcrumb-item"><a href="../index.php">Home</a></li>
|
|
<li class="breadcrumb-item active">Pengaturan Usaha</li>
|
|
</ol>
|
|
</nav>
|
|
</div>
|
|
|
|
<div class="card">
|
|
<div class="card-body">
|
|
<h5 class="card-title">Edit Data Usaha</h5>
|
|
<form method="POST" enctype="multipart/form-data">
|
|
<div class="row">
|
|
<div class="col-md-6">
|
|
<label>Nama Usaha</label>
|
|
<input type="text" name="nama_usaha" class="form-control" value="<?= $usaha['nama_usaha']; ?>" required>
|
|
</div>
|
|
<div class="col-md-6">
|
|
<label>Email</label>
|
|
<input type="email" name="email" class="form-control" value="<?= $usaha['email']; ?>" required>
|
|
</div>
|
|
<div class="col-md-6 mt-3">
|
|
<label>No HP</label>
|
|
<input type="text" name="no_hp" class="form-control" value="<?= $usaha['no_hp']; ?>"
|
|
oninput="this.value = this.value.replace(/[^0-9]/g, '')" required>
|
|
</div>
|
|
<div class="col-md-6 mt-3">
|
|
<label>Alamat</label>
|
|
<input type="text" name="alamat" class="form-control" value="<?= $usaha['alamat']; ?>" required>
|
|
</div>
|
|
<div class="col-md-12 mt-3">
|
|
<label>Deskripsi</label>
|
|
<textarea name="deskripsi" class="form-control" required><?= $usaha['deskripsi']; ?></textarea>
|
|
</div>
|
|
<div class="col-md-6 mt-3">
|
|
<label>Hari Buka</label>
|
|
<input type="text" name="hari_buka" class="form-control" value="<?= $usaha['hari_buka']; ?>" required>
|
|
</div>
|
|
<div class="col-md-6 mt-3">
|
|
<label>Hari Tutup</label>
|
|
<input type="text" name="hari_tutup" class="form-control" value="<?= $usaha['hari_tutup']; ?>" required>
|
|
</div>
|
|
<div class="col-md-6 mt-3">
|
|
<label>Jam Buka</label>
|
|
<input type="time" name="jam_buka" class="form-control" value="<?= $usaha['jam_buka']; ?>" required>
|
|
</div>
|
|
<div class="col-md-6 mt-3">
|
|
<label>Jam Tutup</label>
|
|
<input type="time" name="jam_tutup" class="form-control" value="<?= $usaha['jam_tutup']; ?>" required>
|
|
</div>
|
|
<div class="col-md-6 mt-3">
|
|
<label>Link Instagram</label>
|
|
<input type="text" name="link_ig" class="form-control" value="<?= $usaha['link_ig']; ?>">
|
|
</div>
|
|
<div class="col-md-6 mt-3">
|
|
<label>Link TikTok</label>
|
|
<input type="text" name="link_tiktok" class="form-control" value="<?= $usaha['link_tiktok']; ?>">
|
|
</div>
|
|
<!-- <div class="col-md-6 mt-3">
|
|
<label>Gambar Usaha</label>
|
|
<input type="file" name="gambar" class="form-control">
|
|
<?php if ($usaha['gambar']) : ?>
|
|
<img src="<?= $usaha['gambar']; ?>" width="100" class="mt-2">
|
|
<?php endif; ?>
|
|
</div> -->
|
|
<div class="col-md-6 mt-3">
|
|
<label>Logo Usaha</label>
|
|
<input type="file" name="logo" class="form-control">
|
|
<?php if ($usaha['logo']) : ?>
|
|
<img src="<?= $usaha['logo']; ?>" width="100" class="mt-2">
|
|
<?php endif; ?>
|
|
</div>
|
|
</div>
|
|
|
|
<button type="submit" class="btn btn-primary mt-3">Simpan Perubahan</button>
|
|
</form>
|
|
</div>
|
|
</div>
|
|
</main>
|
|
|
|
<?php include '../template/footer.php'; ?>
|
|
<?php include '../template/template2.php'; ?>
|