API tools faq
paste
Advertisement
Guest User

done

a guest
Mar 13th, 2016
109
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 7.41 KB | None | 0 0
raw download clone embed print report diff
  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 "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>&copy; 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">&nbsp;</th>
  149.     <th align="left" valign="middle" scope="col">&nbsp;</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 align="left" valign="middle"><label for="textfield2"></label>
  171.     <input type="text" name="title" id="title" value="<?php echo $arr['title'] ?>" /></td>
  172.   </tr>
  173.   <tr>
  174.     <td align="left" valign="middle">&nbsp;</td>
  175.     <td align="left" valign="middle">&nbsp;</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">&nbsp;</td>
  185.     <td align="left" valign="middle">&nbsp;</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">&nbsp;</td>
  201.     <td align="left" valign="middle">&nbsp;</td>
  202.   </tr>
  203.   <tr>
  204.     <td align="left" valign="middle">&nbsp;</td>
  205.     <td align="left" valign="middle">&nbsp;</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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!