API tools faq
paste
Advertisement
Guest User

a

a guest
Jul 7th, 2016
89
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.55 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3. include "koneksi.php";
  4. $tgl = date("Y/m/d h:i:s");
  5. if(!isset($_SESSION['login'])) $_SESSION['login']=array();
  6. if (!$_SESSION['login']){
  7. header('Location: home.html');
  8. }else{
  9. $mode=(isset($_GET['mode']))?$_GET['mode']:0;
  10. if($mode==0) {
  11. if((isset($_POST['username'])) && (isset($_POST['nama'])) && (isset($_POST['email'])) && (isset($_POST['pass']))){
  12. if(($_POST['username'])!='' && ($_POST['nama'])!='' && ($_POST['email'])!='' && ($_POST['pass'])!=''){
  13. if(isset($_POST['jk'])){
  14. $username=$_POST['username'];
  15. $nama=$_POST['nama'];
  16. $email=$_POST['email'];
  17. $pass=$_POST['pass'];
  18. $jk=$_POST['jk'];
  19. switch($jk){
  20. case 'laki':
  21. $jk=0;
  22. break;
  23. case 'pr':
  24. $jk=1;
  25. break;
  26. }
  27. $tambah = ("INSERT INTO karyawan (username, nama_kary, password, email, tanggal, jenis_kelamin) VALUES ('$username', '$nama','$pass', '$email','$tgl' ,'$jk')");
  28. $insert_query = mysql_query($tambah);
  29. if ($insert_query){
  30. echo "Input Sukses";
  31. }else {
  32. echo"Input Gagal";
  33. }
  34. }
  35. }
  36. }
  37. } else if ($mode==1){
  38. if((isset($_POST['nama'])) && (isset($_POST['email'])) && (isset($_POST['pass']))){
  39. if(($_POST['nama'])!='' && ($_POST['email'])!='' && ($_POST['pass'])!=''){
  40. if(isset($_POST['jk'])){
  41. $username=$_POST['username'];
  42. $nama=$_POST['nama'];
  43. $email=$_POST['email'];
  44. $pass=$_POST['pass'];
  45. $jk=$_POST['jk'];
  46. switch($jk){
  47. case 'laki':
  48. $jk=0;
  49. break;
  50. case 'pr':
  51. $jk=1;
  52. break;
  53. }
  54. $update = "UPDATE karyawan SET
  55. nama_kary = '$nama',
  56. password = '$pass',
  57. email = '$email',
  58. jenis_kelamin= '$jk'
  59. WHERE username='$username';
  60. ";
  61. $update_query = mysql_query($update) or die (mysql_error());
  62. if($update_query){
  63. echo "Berhasil di Update";
  64. echo "<meta http-equiv='refresh'>";
  65. $mode=0;
  66. }
  67. else {
  68. echo "Gagal di Update";
  69. }
  70. }
  71. }
  72. }
  73. }else{
  74. $username = $_GET['username'];
  75. $delete = "DELETE FROM karyawan WHERE username='$username'";
  76. $delete_query = mysql_query($delete);
  77. if ($delete_query) {
  78. echo "Berhasil di Hapus";
  79. echo "<meta http-equiv='refresh'>";
  80. }
  81. else {
  82. echo "Gagal di Hapus";
  83. }
  84. }
  85. ?>
  86. <html>
  87. <head>
  88. <title>Admin Page</title>
  89. <style>
  90. table{
  91. font:normal normal 13px Trebuchet,"Trebuchet MS",Arial,Sans-Serif;
  92. color:black;
  93. }
  94. </style>
  95. </head>
  96. <body>
  97.  
  98. <?php
  99. foreach ($_SESSION['login']as $key => $val){
  100. ?>
  101. <table>
  102. <tr>
  103. <td> <a href="kategori.php"> Kategori</a> </td>
  104. <td> <a href="admin.php"> Karyawan </a> </td>
  105. <td style="width:18%;" align="right"><font size="5px" color="#C44358"><?php echo "Hi, ".$val[1]." "; ?></font>
  106. <a href="logout.php"><font size="2px" color="black">Logout</font></a></td>
  107. </tr>
  108. </table>
  109. <?php }?>
  110.  
  111. <?php if($mode==0) { ?>
  112. <form method="post" action="<?php=$_SERVER['PHP_SELF']?>?mode=0"><br/><br/>
  113. <table>
  114. <tr>
  115. <th colspan="3" align="center"><h3> --- Tambah Data --- </h3></th>
  116. </tr>
  117. <tr>
  118. <td> Username </td>
  119. <td> : </td>
  120. <td> <input type="text" name="username" value=""></td>
  121. </tr>
  122. <tr>
  123. <td> Nama Karyawan </td>
  124. <td> : </td>
  125. <td> <input type="text" name="nama" value=""></td>
  126. </tr>
  127. <tr>
  128. <td> Email </td>
  129. <td> : </td>
  130. <td> <input type="text" name="email" value=""></td>
  131. </tr>
  132. <tr>
  133. <td> Password </td>
  134. <td> : </td>
  135. <td> <input type="password" name="pass" value=""></td>
  136. </tr>
  137. <tr>
  138. <td> Jenis Kelamin </td>
  139. <td> : </td>
  140. <td><select name="jk">
  141. <option value="laki">Laki-Laki</option>
  142. <option value="pr">Perempuan</option>
  143. </td>
  144. </tr>
  145. </table>
  146. <br/><input type="submit" value="submit"/><br/>
  147. </form>
  148.  
  149. <?php } else {
  150. $idx=$_GET['username'];
  151. $sqlCommand1 = "SELECT * FROM karyawan WHERE username='".$idx."'";
  152. $query1 = mysql_query($sqlCommand1);
  153. if ($row1 = mysql_fetch_array(($query1))){
  154. $nama_kary= $row1['nama_kary'];
  155. $password = $row1 ['password'];
  156. $email = $row1 ['email'];
  157. $jk = $row1 ['jenis_kelamin'];
  158. ?>
  159. <form method="post" action="<?php=$_SERVER['PHP_SELF']?>?mode=1&username=<?php=$username?>"><br/><br/>
  160. <table>
  161. <tr>
  162. <th colspan="3" align="center"><h3> --- Ubah Data --- </h3></th>
  163. </tr>
  164. <tr>
  165. <td> Username </td>
  166. <td> : </td>
  167. <td> <input type="text" name="username" value="<?php=$idx?>"readonly> </td>
  168. </tr>
  169. <tr>
  170. <td> Nama Karyawan </td>
  171. <td> : </td>
  172. <td> <input type="text" name="nama" value="<?php echo $nama_kary;?>"></td>
  173. </tr>
  174. <tr>
  175. <td> Email </td>
  176. <td> : </td>
  177. <td> <input type="text" name="email" value="<?php echo $email;?>"></td>
  178. </tr>
  179. <tr>
  180. <td> Password </td>
  181. <td> : </td>
  182. <td> <input type="password" name="pass" value="<?php echo $pass;?>"></td>
  183. </tr>
  184. <tr>
  185. <td> Jenis Kelamin </td>
  186. <td> : </td>
  187. <td><select id="formInput83" class="form-control" name="jk">
  188. <?php if ($jk==0){?>
  189. <option value="laki" selected>Laki-Laki</option>
  190. <?php}else{?>
  191. <option value="pr" selected>Perempuan</option>
  192. <?php}?>
  193. </td>
  194. </tr>
  195. </table>
  196. <br/><input type="submit" value="submit"/><br/>
  197. </form>
  198. <?php}}?>
  199. <br/>
  200. <a href="<?php=$_SERVER['PHP_SELF']?>">Tambah</a>
  201. <br/>
  202. <br/>
  203. <table border="1">
  204. <tr>
  205. <th>Username</th>
  206. <th>Nama Karyawan</th>
  207. <th>Email</th>
  208. <th>Jenis Kelamin</th>
  209. <th>Tanggal Masuk</th>
  210. <th>Action</th>
  211. <tr>
  212. <?php
  213. $sqlCommand = 'SELECT * FROM karyawan ORDER BY nama_kary ASC';
  214. $query = mysql_query($sqlCommand);
  215. while ($row = mysql_fetch_array(($query))){
  216. $username = $row ['username'];
  217. $nama_kary= $row['nama_kary'];
  218. $password = $row ['password'];
  219. $email = $row ['email'];
  220. $jk = $row ['jenis_kelamin'];
  221. $tanggal = $row ['tanggal'];
  222. ?>
  223. <tr>
  224. <td><?php echo $username."<br/>";?></td>
  225. <td><?php echo $nama_kary."<br/>";?></td>
  226. <td><?php echo $email."<br/>";?></td>
  227. <td><?php
  228. if ($jk==0){
  229. echo "Laki-laki <br/>";
  230. }else{
  231. echo "Perempuan <br/>";
  232. }
  233. ?></td>
  234. <td><?php echo $tanggal."<br/>";?></td>
  235. <td>
  236. <a href="<?php=$_SERVER['PHP_SELF']?>?mode=1&username=<?php=$username?>">Edit</a>
  237. <a href="<?php=$_SERVER['PHP_SELF']?>?mode=2&username=<?php=$username?>">Delete</a>
  238. </td>
  239. </tr>
  240. <?php }?>
  241. </table>
  242.  
  243.  
  244. </body>
  245. </html>
  246. <?php
  247. }?>
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!