mysqlii_update

<?php
session_start();
if(empty($_SESSION['login_user']))
{
header('Location: index.php');
}
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "perhutani";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

if(isset($_POST['submit'])){
	$id = $_GET['id'];


	$nama = $_POST['nama'];
	$alamat = $_POST['alamat'];
	$tgl = $_POST['tgl'];


	$gambar = $_FILES['userfile']['name'];
	$tmp_name = $_FILES['userfile']['tmp_name'];


	if(!empty($nama)&& !empty($alamat) && !empty($tgl)&& !empty($gambar) )
	{
	$location = 'images/';

	if(move_uploaded_file($tmp_name, $location.$gambar))
	{
	$sql = "UPDATE karyawan SET
nama='".$_POST['nama']."',
title='".$_POST['title']."',
alamat='".$_POST['alamat']."',
tgl_lahir='".$_POST['tgl']."',
gambar='".$gambar."',
blokir='".$_POST['blokir']."'
 where id='".$_POST['id']."'";

	}

	}else{
		echo 'ada file yang belum di isi';
	}
if (mysqli_query($conn, $sql)) {
    echo "<script type='text/javascript'>alert('Berhasil Ubah Data');window.location.assign('karyawan.php');</script>";
} else {
    echo "Error updating record: " . mysqli_error($conn);
}

mysqli_close($conn);
}


?>


<!doctype html>


<html lang="en" class="no-js">
<head>
	<title>Creative</title>

	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">

	<link href='http://fonts.googleapis.com/css?family=Lato:300,400,700,900' rel='stylesheet' type='text/css'>
	<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.2.0/css/font-awesome.min.css" rel="stylesheet">

	<link rel="stylesheet" type="text/css" href="css/bootstrap.css" media="screen">
	<link rel="stylesheet" type="text/css" href="css/magnific-popup.css" media="screen">
	<link rel="stylesheet" type="text/css" href="css/font-awesome.css" media="screen">
	<link rel="stylesheet" type="text/css" href="css/animate.css" media="screen">
	<link rel="stylesheet" type="text/css" href="css/style.css" media="screen">

</head>
<body>

	<!-- Container -->
	<div id="container">

	<!-- Header
		    ================================================== -->
		<header class="clearfix">
			<div class="logo">
				<a href="index.html"><img src="images/logo.png" alt=""></a>
			</div>

			<a class="elemadded responsive-link" href="#">Menu</a>

			<nav class="menu">
				<ul>
					<li><a href="utama.php"><span>Home</span></a></li>
					<li><a href="karyawan.php"><span>Karyawan</span></a></li>

					<li><a href="tambah_produk.php"><span>produk</span></a></li>
					<li ><a href="tambah_pengumuman.php"><span>pengumuman</span></a></li>
					<li><a href="contact.php"><span>Contact Message</span></a></li>
					<li><a href="logout.php"><span>logout</span></a></li>

				</ul>
			</nav>
			<div class="copyright">
				<span></span>
				<p>&copy; 2014 Nunforest.</p>
			</div>
		</header>
		<!-- End Header -->

		<!-- content
			================================================== -->
		<div id="content">
			<!-- page-banner-section
				================================================== -->


			<!--content-box
			================================================== -->
			<div class="content-box" align="center">
			<h1>ubah Data Karyawan</h1>
				<form action="ubah_karyawan.php" method="post" enctype="multipart/form-data">

				<?php

				$id = $_GET['id'];
				$hasil = mysqli_query($conn,"SELECT * FROM karyawan where id='$id'");
				while($arr = mysqli_fetch_array($hasil)){


				?>

	<table width="600" border="0" cellpadding="1" cellspacing="1" align="">
  <tr>
    <th align="left" valign="middle" scope="col">&nbsp;</th>
    <th align="left" valign="middle" scope="col">&nbsp;</th>
  </tr>
   <tr>


    <td<input type="hidden" name="id" id="id" value="<?php echo $arr['id'] ?>"/></td>
  </tr>


  <tr>

    <td align="left" valign="middle">nama</td>
    <td align="left" valign="middle"><label for="textfield"></label>
    <input type="text" name="nama" id="nama" value="<?php echo $arr['nama'] ?>"/></td>
  </tr>
  <tr>
    <td align="left" valign="middle">title</td>
    <td align="left" valign="middle"><label for="textfield2"></label>
    <input type="text" name="title" id="title" value="<?php echo $arr['title'] ?>" /></td>
  </tr>
  <tr>
    <td align="left" valign="middle">&nbsp;</td>
    <td align="left" valign="middle">&nbsp;</td>
  </tr>
  <tr>
    <td align="left" valign="middle">alamat</td>
    <td align="left" valign="middle"><label for="textfield3"></label>
      <label for="textarea"></label>
    <textarea name="alamat" id="alamat" cols="45" rows="5" ><?php echo $arr['alamat'] ?></textarea></td>
  </tr>
  <tr>
    <td align="left" valign="middle">&nbsp;</td>
    <td align="left" valign="middle">&nbsp;</td>
  </tr>
  <tr>
    <td align="left" valign="middle">tanggal lahir</td>
    <td align="left" valign="middle"><label for="textfield3"></label>
    <input type="date" name="tgl" id="tgl" value="<?php echo $arr['tgl_lahir'] ?>" /></td>
  </tr>
  <tr>
    <td align="left" valign="middle">foto</td>
    <td align="left" valign="middle"><label for="fileField"></label>


    <img src="images/<?php echo $arr[5] ?>" width="100px" height="100px"><input type="file" name="userfile" id="userfile" /></td>
  </tr>
  <tr>
    <td align="left" valign="middle">&nbsp;</td>
    <td align="left" valign="middle">&nbsp;</td>
  </tr>
  <tr>
    <td align="left" valign="middle">&nbsp;</td>
    <td align="left" valign="middle">&nbsp;</td>
  </tr>

 <tr>
    <td align="left" valign="middle">blokir</td>
    <td align="left" valign="middle"><label for="textfield3"></label>
    <input type="text" name="blokir" id="blokir" value="<?php echo $arr['blokir'] ?>" /></td>
  </tr>


  <tr>
  	<td colspan="2" align="center"><input type="submit" name="submit" value="ubah data"/></td>
  </tr>
</table>


				<?php } ?>


						</form>

</div>


				<!-- blog-section
					================================================== -->
				<div class="blog-section">


				</div>


			</div>

		</div>
		<!-- End content -->

	</div>
	<!-- End Container -->

	<script type="text/javascript" src="js/jquery-1.11.1.min.js"></script>
	<script type="text/javascript" src="js/jquery.migrate.js"></script>
	<script type="text/javascript" src="js/jquery.magnific-popup.min.js"></script>
	<script type="text/javascript" src="js/bootstrap.js"></script>
	<script type="text/javascript" src="js/jquery.appear.js"></script>
	<script type="text/javascript" src="js/jquery.imagesloaded.min.js"></script>
	<script type="text/javascript" src="js/retina-1.1.0.min.js"></script>
	<script type="text/javascript" src="js/plugins-scroll.js"></script>
	<script type="text/javascript" src="js/waypoint.min.js"></script>
	<script type="text/javascript" src="js/jquery.queryloader2.js"></script>
	<script type="text/javascript" src="js/script.js"></script>

</body>
</html>