View difference between Paste ID: <a href="/eCcb6rE8">eCcb6rE8</a> and <a href="/A3ujxXkD">A3ujxXkD</a>

<?php
1		<?php
2		session_start();
3		if(empty($_SESSION['login_user']))
4		{
5		header('Location: index.php');
6		}
7		$servername = "localhost";
8		$username = "root";
9		$password = "";
10		$dbname = "******";
11
12		// Create connection
13		$conn = mysqli_connect($servername, $username, $password, $dbname);
14		// Check connection
15		if (!$conn) {
16		die("Connection failed: " . mysqli_connect_error());
17		}
18
19		if(isset($_POST['submit'])){
20		$id = $_GET['id'];
21
22
23		$nama = $_POST['nama'];
24		$alamat = $_POST['alamat'];
25		$tgl = $_POST['tgl'];
26
27
28
29		$gambar = $_FILES['userfile']['name'];
30		$tmp_name = $_FILES['userfile']['tmp_name'];
31
32
33		if(!empty($nama)&& !empty($alamat) && !empty($tgl)&& !empty($gambar) )
34		{
35		$location = 'images/';
36
37		if(move_uploaded_file($tmp_name, $location.$gambar))
38		{
39		$sql = "UPDATE karyawan SET
40		nama='".$_POST['nama']."',
41		title='".$_POST['title']."',
42		alamat='".$_POST['alamat']."',
43		tgl_lahir='".$_POST['tgl']."',
44		gambar='".$gambar."',
45		blokir='".$_POST['blokir']."'
46		where id='".$_POST['id']."'";
47
48		}
49
50		}else{
51		echo 'ada file yang belum di isi';
52		}
53		if (mysqli_query($conn, $sql)) {
54	-	echo "<script type='text/javascript'>alert('Berhasil Ubah Data');window.location.assign('karyawan.php');</script>";
54	+	echo "query :<pre>{$sql}</pre>"; //comment kl udah selesai
55		// echo "<script type='text/javascript'>alert('Berhasil Ubah Data');window.location.assign('karyawan.php');</script>";
56		} else {
57		echo "Error updating record: " . mysqli_error($conn);
58		}
59
60		mysqli_close($conn);
61		}
62
63		?>
64
65
66
67
68
69		<!doctype html>
70
71
72		<html lang="en" class="no-js">
73		<head>
74		<title>Creative</title>
75
76		<meta charset="utf-8">
77		<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
78
79		<link href='http://fonts.googleapis.com/css?family=Lato:300,400,700,900' rel='stylesheet' type='text/css'>
80		<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.2.0/css/font-awesome.min.css" rel="stylesheet">
81
82		<link rel="stylesheet" type="text/css" href="css/bootstrap.css" media="screen">
83		<link rel="stylesheet" type="text/css" href="css/magnific-popup.css" media="screen">
84		<link rel="stylesheet" type="text/css" href="css/font-awesome.css" media="screen">
85		<link rel="stylesheet" type="text/css" href="css/animate.css" media="screen">
86		<link rel="stylesheet" type="text/css" href="css/style.css" media="screen">
87
88		</head>
89		<body>
90
91		<!-- Container -->
92		<div id="container">
93
94		<!-- Header
95		================================================== -->
96		<header class="clearfix">
97		<div class="logo">
98		<a href="index.html"><img src="images/logo.png" alt=""></a>
99		</div>
100
101		<a class="elemadded responsive-link" href="#">Menu</a>
102
103		<nav class="menu">
104		<ul>
105		<li><a href="utama.php"><span>Home</span></a></li>
106		<li><a href="karyawan.php"><span>Karyawan</span></a></li>
107
108		<li><a href="tambah_produk.php"><span>produk</span></a></li>
109		<li ><a href="tambah_pengumuman.php"><span>pengumuman</span></a></li>
110		<li><a href="contact.php"><span>Contact Message</span></a></li>
111		<li><a href="logout.php"><span>logout</span></a></li>
112
113		</ul>
114		</nav>
115		<div class="copyright">
116		<span></span>
117		<p>© 2014 Nunforest.</p>
118		</div>
119		</header>
120		<!-- End Header -->
121
122		<!-- content
123		================================================== -->
124		<div id="content">
125		<!-- page-banner-section
126		================================================== -->
127
128
129		<!--content-box
130		================================================== -->
131		<div class="content-box" align="center">
132		<h1>ubah Data Karyawan</h1>
133		<form action="ubah_karyawan.php" method="post" enctype="multipart/form-data">
134
135		<?php
136
137		$id = $_GET['id'];
138		$hasil = mysqli_query($conn,"SELECT * FROM karyawan where id='$id'");
139		while($arr = mysqli_fetch_array($hasil)){
140
141
142
143
144		?>
145
146		<table width="600" border="0" cellpadding="1" cellspacing="1" align="">
147		<tr>
148		<th align="left" valign="middle" scope="col"> </th>
149		<th align="left" valign="middle" scope="col"> </th>
150		</tr>
151		<tr>
152
153
154		<td>
155		<input type="hidden" name="id" id="id" value="<?php echo $arr['id'] ?>"/>
156		</td>
157		</tr>
158
159
160
161
162		<tr>
163
164		<td align="left" valign="middle">nama</td>
165		<td align="left" valign="middle"><label for="textfield"></label>
166		<input type="text" name="nama" id="nama" value="<?php echo $arr['nama'] ?>"/></td>
167		</tr>
168		<tr>
169		<td align="left" valign="middle">title</td>
170	-	<td<input type="hidden" name="id" id="id" value="<?php echo $arr['id'] ?>"/></td>
170	+
171		<input type="text" name="title" id="title" value="<?php echo $arr['title'] ?>" /></td>
172		</tr>
173		<tr>
174		<td align="left" valign="middle"> </td>
175		<td align="left" valign="middle"> </td>
176		</tr>
177		<tr>
178		<td align="left" valign="middle">alamat</td>
179		<td align="left" valign="middle"><label for="textfield3"></label>
180		<label for="textarea"></label>
181		<textarea name="alamat" id="alamat" cols="45" rows="5" ><?php echo $arr['alamat'] ?></textarea></td>
182		</tr>
183		<tr>
184		<td align="left" valign="middle"> </td>
185		<td align="left" valign="middle"> </td>
186		</tr>
187		<tr>
188		<td align="left" valign="middle">tanggal lahir</td>
189		<td align="left" valign="middle"><label for="textfield3"></label>
190		<input type="date" name="tgl" id="tgl" value="<?php echo $arr['tgl_lahir'] ?>" /></td>
191		</tr>
192		<tr>
193		<td align="left" valign="middle">foto</td>
194		<td align="left" valign="middle"><label for="fileField"></label>
195
196
197		<img src="images/<?php echo $arr[5] ?>" width="100px" height="100px"><input type="file" name="userfile" id="userfile" /></td>
198		</tr>
199		<tr>
200		<td align="left" valign="middle"> </td>
201		<td align="left" valign="middle"> </td>
202		</tr>
203		<tr>
204		<td align="left" valign="middle"> </td>
205		<td align="left" valign="middle"> </td>
206		</tr>
207
208		<tr>
209		<td align="left" valign="middle">blokir</td>
210		<td align="left" valign="middle"><label for="textfield3"></label>
211		<input type="text" name="blokir" id="blokir" value="<?php echo $arr['blokir'] ?>" /></td>
212		</tr>
213
214
215		<tr>
216		<td colspan="2" align="center"><input type="submit" name="submit" value="ubah data"/></td>
217		</tr>
218		</table>
219
220
221
222		<?php } ?>
223
224
225
226
227
228
229
230
231		</form>
232
233		</div>
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248		<!-- blog-section
249		================================================== -->
250		<div class="blog-section">
251
252
253
254
255
256
257		</div>
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276		</div>
277
278		</div>
279		<!-- End content -->
280
281		</div>
282		<!-- End Container -->
283
284		<script type="text/javascript" src="js/jquery-1.11.1.min.js"></script>
285		<script type="text/javascript" src="js/jquery.migrate.js"></script>
286		<script type="text/javascript" src="js/jquery.magnific-popup.min.js"></script>
287		<script type="text/javascript" src="js/bootstrap.js"></script>
288		<script type="text/javascript" src="js/jquery.appear.js"></script>
289		<script type="text/javascript" src="js/jquery.imagesloaded.min.js"></script>
290		<script type="text/javascript" src="js/retina-1.1.0.min.js"></script>
291		<script type="text/javascript" src="js/plugins-scroll.js"></script>
292		<script type="text/javascript" src="js/waypoint.min.js"></script>
293		<script type="text/javascript" src="js/jquery.queryloader2.js"></script>
294		<script type="text/javascript" src="js/script.js"></script>
295
296		</body>
297		</html>