Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
cara delete data yang sebelumnya sudah dibuat id otomatis
ini coding proses add nya
<form action="process/adding-supplier.php" name="forminputtanggal" method="POST" enctype="multipart/form-data">
<div class="col-lg-8">
<?php
include "config/config.php";
$no= mysqli_query($koneksi,"SELECT id_supplier FROM tbl_supplier ORDER BY id_supplier DESC");
$kode_supplier = mysqli_fetch_array($no);
$kode = $kode_supplier['id_supplier'];
$urut = substr($kode, 6, 3);
$tambah = (int) $urut + 1;
$bln = date("m");
$thn = date("y");
if(strlen($tambah) == 1){
$format = "SP".$bln.$thn."00".$tambah;
}else if (strlen($tambah) == 2) {
$format = "SP".$bln.$thn."0".$tambah;
}else {
$format = "SP".$bln.$thn.$tambah;
}
?>
<div class="form-group">
<label>Kode Supplier</label>
<input class="col-lg-3" class="form-control" name="id_supplier" value="<?php echo $format;?>" readonly>
</div>
<div class="form-group">
<label>Nama Supplier</label>
<input class="col-lg-2" class="form-control" name="jenis_supplier" placeholder="PT,CV" required>
<input class="col-lg-7" class="form-control" name="nama_supplier" placeholder="Nama Lengkap Perusahaan" required>
</div>
<div class="form-group">
<label>Alamat </label>
<textarea class="form-control" name="alamat_supplier" rows="4" style="width: 650px;"></textarea>
</div>
<div class="form-group">
<label>Telp</label>
<input class="col-lg-9" class="form-control" name="telp_supplier" style="margin-left:85px">
</div>
<div class="form-group">
<label>Fax</label>
<input class="col-lg-9" class="form-control" name="fax_supplier" style="margin-left:90px">
</div>
<div class="form-group">
<label>Contact Person</label>
<input class="col-lg-9" class="form-control" name="contact_person_supplier" style="margin-left:3px">
</div>
<div class="form-group">
<label>Jabatan</label>
<input class="col-lg-9" class="form-control" name="jabatan_supplier" style="margin-left:57px">
</div>
<div class="form-group">
<label>Email</label>
<input class="col-lg-9" class="form-control" name="email_supplier" style="margin-left:77px">
</div>
<div class="form-group">
<label>Rekening Bank</label>
<input class="col-lg-9" class="form-control" name="rekening_bank_supplier" style="margin-left:8px">
</div>
<div class="form-actions form-group">
<button type="submit" name="submit" value="submit" class="btn btn-primary btn-sm" onclick="return confirm('Anda Yakin Akan Menyimpan')">
<i class="fa fa-dot-circle-o"></i> SAVE
</button>
<button type="reset" class="btn btn-danger btn-sm">
<i class="fa fa-ban"></i> Reset
</button>
<a href="list-supplier.php">
<button type="button" class="btn btn-warning btn-sm">BACK</button>
</a>
</div>
</div>
</form>
nah untuk delete nya cara take id nya bagaimana ya?
7 Jawaban:
coding deletenya taruh sini gan gan lupa pake tag kode, sebelah kanan kolom jawaban []
<pre> <?php
include "../config/config.php";
$id_supplier=$_GET['id_supplier'];
$sql="DELETE FROM tbl_supplier WHERE id_supplier=$id_supplier";
$query = $koneksi->query($sql);
?>
<script language="javascript">
alert('Data Di Dihapus!');
document.location='../list-supplier.php';
</script>
<?php
?>
</pre>
ini code delete nya gan
button delete ada di list, atau didalam detail gan?
<pre> <tr style="font-size: 10px;"> <a style="text-align: center"><td><?php echo $no;?></td></a> <td style="text-align: center"><?php echo $rownews['id_supplier'];?></td> <td style="text-align: center"><?php echo $rownews['jenis_supplier'];?> <?php echo $rownews['nama_supplier'];?></td> <td style="text-align: center"><?php echo $rownews['telp_supplier'];?></td> <td style="text-align: center"><?php echo $rownews['alamat_supplier'];?></td> <td style="text-align:center;"> <a href="edit-supplier.php?id_supplier=<?php echo $rownews['id_supplier']; ?>" class="fa fa-edit fa-lg" title="Edit"></a> <a href="process/delete-supplier.php?id_supplier=<?php echo $rownews['id_supplier']; ?>" class="fa fa-trash fa-lg" title="Delete" onclick="return confirm('Anda Yakin Akan Menghapus?')"></a> </td> </tr>
</pre>
di list gan
Jawaban Terpilih
seharusnya sudah bisa deletenya gan, kan id_supplier yg disimpan sesuai dengan format yang dibuat
iya gan ada pengaruh ga dengan dibuat id otomatis nya
<pre> <?php include "../config/config.php"; $id_supplier=$_GET['id_supplier']; $sql="DELETE FROM tbl_supplier WHERE id_supplier='$id_supplier'"; $query = $koneksi->query($sql); ?> <script language="javascript"> alert('Data Di Dihapus!'); document.location='../list-supplier.php'; </script> <?php ?> </pre>
udh bsa gan cuma kurang tanda kutip aja $sql="DELETE FROM tbl_supplier WHERE id_supplier='$id_supplier'";