testgit/hapus_data.php at master · esadeli/testgit · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
<html>
	<head>
		<title>Sistem Gudang Extension</title>
		<style type="text/css">
			table tr td,th{
				border : 1px solid;
			}
		</style>
	</head>

	<body>
		<h1>Hapus Data</h1>
		<br>
		<?php
			$servername = "localhost";
			$username = "root";
			$password = "";
			$dbname = "cyber";

			$conn = new mysqli($servername,$username,$password,$dbname);

			$sql ='SELECT * FROM dbgudangext WHERE db_id ='.$_GET['id'];
			$result = $conn->query($sql);
			$data = $result->fetch_assoc();

			$kodebarang = implode("", array($data["db_kodebarang"]));
			$namabarang = implode("", array($data["db_namabarang"]));
			$jumlahbarang = $data["db_quantity"];
			$suratpermintaan = $data["db_suratpermintaan"];
			$penanggungjawab = $data["db_penanggungjawab"];

			if($_SERVER["REQUEST_METHOD"]=="POST"){
				$conn = new mysqli($servername, $username, $password, $dbname);

				$sqlupdate = 'DELETE FROM dbgudangext WHERE db_id ='.$_GET['id'];

					if($conn->query($sqlupdate)===TRUE) {

		?>
						<script type="text/javascript">
							alert('Data barang sudah di delete');
						</script>
					<?php
						}
						else{
					?>
						<script type="text/javascript">
							alert('Failed to delete Data');
						</script>
			<?php
						}
						$conn->close();
						header("Refresh:0;url=../index.php");
						exit();
				}
			?>

		<form method="POST" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"].'?id='.$_GET['id']); ?>">
			Delete data barang ?<br><br>
			<label>Kode Item :</label><?=$kodebarang?><br>
			<label>Item :</label><?=$namabarang?><br>
			<label>Quantity :</label><?=$jumlahbarang?><br>
			<label>Good Receipt :</label><?=$suratpermintaan?><br>
			<label>Penanggung Jawab :</label><?=$penanggungjawab?><br>

			<input type="submit" value="Delete">

		</form>

	</body>
</html>