testgit/ubah_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
72
73
74
75
76
77
78
79
80
81
82
83
84
85
<html>
	<head>
		<title>Sistem Gudang Sederhana - Extension</title>
		<style type="text/css">
			table tr td,th{
				border : 1px solid;
			}
		</style>
	</head>

	<body>
		<h1>Ubah Master Data</h1>
		<hr>
			<?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 = $data["db_kodebarang"];
				$namabarang = $data["db_namabarang"];
				$jumlahbarang = $data["db_quantity"];
				$suratpermintaan = $data["db_suratpermintaan"];
				$penanggungjawab = $data["db_penanggungjawab"];

					if($_SERVER["REQUEST_METHOD"] =="POST"){
						$mbr_kodebarang = $_POST["inputkodebarang"];
						$mbr_namabarang = $_POST["inputnamabarang"];
						$mbr_suratpermintaan = $_POST["inputsuratpermintaan"];
						$mbr_penanggungjawab = $_POST["inputpenanggungjawab"];

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

						$sqlupdate = 'UPDATE dbgudangext SET db_kodebarang = "'.$mbr_kodebarang.'",db_namabarang = "'.$mbr_namabarang.'",db_suratpermintaan = "'.$mbr_suratpermintaan.'", db_penanggungjawab = "'.$mbr_penanggungjawab.'" WHERE db_id = '.$_GET['id'];

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

			<script type="text/javascript">
				alert('Data barang berhasil di Edit');
			</script>

			<?php
					}
					else {
			?>

			<script type="text/javascript">
				alert('Failure in data editing');
			</script>

			<?php
					}
					$conn->close();
					header("Refresh:0;url=../index.php");
					exit();
				  }
			?>

		<form method="POST" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"].'?id='.$_GET['id'])?>">
			<label>Kode Item</label><br>
			<input type="inputkodebarang" name="inputkodebarang" value="<?=$kodebarang?>">
			<br>
			<label>Item</label><br>
			<input type="inputnamabarang" name="inputnamabarang" value ="<?=$namabarang?>">
			<br>
			<label>Jumlah Barang</label><br><?=$jumlahbarang?><br>
			<label>Surat Permintaan Barang</label><br>
			<input type="inputsuratpermintaan" name="inputsuratpermintaan" value="<?=$suratpermintaan?>">
			<br>
			<label>Staff - Penanggung Jawab</label><br>
			<input type="inputpenanggungjawab" name="inputpenanggungjawab" value = "<?=$penanggungjawab?>">
			<br>
			<input type="submit" value="Save">
		</form>

	</body>
</html>