require ("security.php");?>
Delete anggota
require("connect.inc.php");
if (!$_POST[tambah]) {
?>
}
else
{
$query = "DELETE FROM custamer WHERE kode_custamer='".$_POST[kode_custamer]."'";
//echo $query;
$hasil = mysqli_query($koneksi,$query)
or die('Kesalahan pada proses query!');
$query1 = "select id from pinjaman WHERE id_pel='".$_POST[kode_custamer]."'";
$hasil1 = mysqli_query($koneksi,$query1)
or die('Kesalahan pada proses query!');
while(list($id) = mysqli_fetch_row($hasil1)){
$query2 = "DELETE FROM angsuran WHERE id_pinjam='".$id."'";
//echo $query2;
$hasil2 = mysqli_query($koneksi,$query2)
or die('Kesalahan pada proses query!');
}
$query3 = "DELETE FROM pinjaman WHERE id_pel='".$_POST[kode_custamer]."'";
//echo $query3;
$hasil3 = mysqli_query($koneksi,$query3)
or die('Kesalahan pada proses query!');
$query4 = "DELETE FROM simpanan WHERE id_pel='".$_POST[kode_custamer]."'";
//echo $query4;
$hasil4 = mysqli_query($koneksi,$query4)
or die('Kesalahan pada proses query!');
$query5 = "DELETE FROM tbl_bku WHERE uraian_transaksi='".$_POST[kode_custamer]."'";
//echo $query4;
$hasil5 = mysqli_query($koneksi,$query5)
or die('Kesalahan pada proses query!');
echo 'Proses Delete Berhasil
' ;
?>
}
?>