70 lines
3.4 KiB
PHP
70 lines
3.4 KiB
PHP
<?php
|
|
$idrule = $_GET['id'];
|
|
$query = $koneksi->query("SELECT * FROM rule WHERE idrule='$idrule'");
|
|
$data = $query->fetch_assoc();
|
|
|
|
$kodegejala_array = explode(',', $data['kodegejala']); // Mengubah spasi ke koma
|
|
?>
|
|
|
|
<div class="row">
|
|
<div class="col-md-12 mb-4">
|
|
<div class="card shadow mb-4">
|
|
<div class="card-header py-3 d-flex flex-row align-items-center justify-content-between">
|
|
<h6 class="m-0 font-weight-bold">Edit Rule</h6>
|
|
</div>
|
|
<div class="card-body">
|
|
<form method="post" enctype="multipart/form-data">
|
|
<div class="form-group">
|
|
<label>Kode Rule</label>
|
|
<input type="text" class="form-control" name="koderule" value="<?= htmlspecialchars($data['koderule']) ?>" required>
|
|
</div>
|
|
<div class="form-group">
|
|
<label>Penyakit</label>
|
|
<select name="kode_penyakit" class="form-control">
|
|
<option value="">--Pilih--</option>
|
|
<?php $ambilpenyakit = $koneksi->query("SELECT * FROM penyakit");
|
|
while ($rowp = $ambilpenyakit->fetch_assoc()) { ?>
|
|
<option value="<?= htmlspecialchars($rowp['kode_penyakit']) ?>" <?= $rowp['kode_penyakit'] == $data['kode_penyakit'] ? 'selected' : '' ?>>
|
|
<?= htmlspecialchars($rowp['kode_penyakit']) ?> - <?= htmlspecialchars($rowp['namapenyakit']) ?>
|
|
</option>
|
|
<?php } ?>
|
|
</select>
|
|
</div>
|
|
<div class="form-group">
|
|
<label>Gejala</label>
|
|
<select name="kodegejala[]" class="form-control select2" multiple="multiple" id="gejalaSelect">
|
|
<option value="">--Pilih--</option>
|
|
<?php $ambilgejala = $koneksi->query("SELECT * FROM gejala");
|
|
while ($rowg = $ambilgejala->fetch_assoc()) { ?>
|
|
<option value="<?= htmlspecialchars($rowg['kodegejala']) ?>" <?= in_array($rowg['kodegejala'], $kodegejala_array) ? 'selected' : '' ?>>
|
|
<?= htmlspecialchars($rowg['kodegejala']) ?> - <?= htmlspecialchars($rowg['gejala']) ?>
|
|
</option>
|
|
<?php } ?>
|
|
</select>
|
|
</div>
|
|
|
|
<button type="submit" class="btn btn-primary" name="update"><i class="glyphicon glyphicon-saved"></i> Update</button>
|
|
</form>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<?php
|
|
if (isset($_POST['update'])) {
|
|
$idrule = $_GET['id'];
|
|
$koderule = mysqli_real_escape_string($koneksi, $_POST['koderule']);
|
|
$kode_penyakit = mysqli_real_escape_string($koneksi, $_POST['kode_penyakit']);
|
|
$kodegejala = $_POST['kodegejala'];
|
|
|
|
// Menggabungkan gejala menjadi satu string yang dipisahkan dengan koma
|
|
$kodegejala_string = implode(',', $kodegejala);
|
|
|
|
// Update data ke database
|
|
$query = "UPDATE rule SET koderule='$koderule', kode_penyakit='$kode_penyakit', kodegejala='$kodegejala_string' WHERE idrule='$idrule'";
|
|
$koneksi->query($query);
|
|
|
|
echo "<script>alert('Data Berhasil Diupdate');</script>";
|
|
echo "<script>location ='index.php?halaman=ruledaftar';</script>";
|
|
}
|
|
?>
|