API tools faq
paste
Advertisement
Guest User

admin

a guest
Aug 15th, 2016
105
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.92 KB | None | 0 0
raw download clone embed print report
  1. <?
  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. <link href="tulis_ide.css" type="text/css" rel="stylesheet"/>
  90. <style>
  91. table{
  92. padding-top: 5px;
  93. }
  94. h3{
  95. color:#C44358;
  96. }
  97. a{
  98. color:#FFFFFF;
  99. }
  100. </style>
  101. </head>
  102. <body>
  103.  
  104. <?
  105. foreach ($_SESSION['login']as $key => $val){
  106. ?>
  107. <table>
  108. <tr>
  109. <td style="width:17%;" align="center" rowspan="2"><img src= "image/logo1.png"> </td>
  110. <td style="width:34%;" align="center" colspan="3"><a href="admin.php"><img src= "image/karyawan.png"> </a>
  111. <a href="kategori.php"><img src= "image/kategori.png"> </a></td>
  112. <td style="width:10%;" align="right"><font size="5px" color="#C44358"><? echo "Hi, ".$val[1]." "; ?></font>
  113. <a href="logout.php"><font size="2px" color="#FFFFFF">Logout</font></a></td>
  114. </tr>
  115. </table>
  116. <?}?>
  117.  
  118. <? if($mode==0) { ?>
  119. <form method="post" action="<?=$_SERVER['PHP_SELF']?>?mode=0"><br/><br/>
  120. <table>
  121. <tr>
  122. <th colspan="3" align="center" ><h3> --- Tambah Data --- </h3></th>
  123. </tr>
  124. <tr>
  125. <td> Username </td>
  126. <td> : </td>
  127. <td> <input type="text" name="username" value=""></td>
  128. </tr>
  129. <tr>
  130. <td> Nama Karyawan </td>
  131. <td> : </td>
  132. <td> <input type="text" name="nama" value=""></td>
  133. </tr>
  134. <tr>
  135. <td> Email </td>
  136. <td> : </td>
  137. <td> <input type="text" name="email" value=""></td>
  138. </tr>
  139. <tr>
  140. <td> Password </td>
  141. <td> : </td>
  142. <td> <input type="password" name="pass" value=""></td>
  143. </tr>
  144. <tr>
  145. <td> Jenis Kelamin </td>
  146. <td> : </td>
  147. <td><select name="jk">
  148. <option value="laki">Laki-Laki</option>
  149. <option value="pr">Perempuan</option>
  150. </td>
  151. </tr>
  152. </table>
  153. <br/><input type="submit" value="submit"/><br/>
  154. </form>
  155.  
  156. <? } else {
  157. $idx=$_GET['username'];
  158. $sqlCommand1 = "SELECT * FROM karyawan WHERE username='".$idx."'";
  159. $query1 = mysql_query($sqlCommand1);
  160. if ($row1 = mysql_fetch_array(($query1))){
  161. $nama_kary= $row1['nama_kary'];
  162. $password = $row1 ['password'];
  163. $email = $row1 ['email'];
  164. $jk = $row1 ['jenis_kelamin'];
  165. ?>
  166. <form method="post" action="<?=$_SERVER['PHP_SELF']?>?mode=1&username=<?=$username?>"><br/><br/>
  167. <table>
  168. <tr>
  169. <th colspan="3" align="center"><h3> --- Ubah Data --- </h3></th>
  170. </tr>
  171. <tr>
  172. <td> Username </td>
  173. <td> : </td>
  174. <td> <input type="text" name="username" value="<?=$idx?>"readonly> </td>
  175. </tr>
  176. <tr>
  177. <td> Nama Karyawan </td>
  178. <td> : </td>
  179. <td> <input type="text" name="nama" value="<? echo $nama_kary;?>"></td>
  180. </tr>
  181. <tr>
  182. <td> Email </td>
  183. <td> : </td>
  184. <td> <input type="text" name="email" value="<? echo $email;?>"></td>
  185. </tr>
  186. <tr>
  187. <td> Password </td>
  188. <td> : </td>
  189. <td> <input type="password" name="pass" value="<? echo $pass;?>"></td>
  190. </tr>
  191. <tr>
  192. <td> Jenis Kelamin </td>
  193. <td> : </td>
  194. <td><select id="formInput83" class="form-control" name="jk">
  195. <? if ($jk==0){?>
  196. <option value="laki" selected>Laki-Laki</option>
  197. <?}else{?>
  198. <option value="pr" selected>Perempuan</option>
  199. <?}?>
  200. </td>
  201. </tr>
  202. </table>
  203. <br/><input type="submit" value="submit"/><br/>
  204. </form>
  205. <?}}?>
  206. <br/>
  207. <a href="<?=$_SERVER['PHP_SELF']?>">Tambah</a>
  208. <br/>
  209. <br/>
  210. <table border="1">
  211. <tr>
  212. <th><h3>Username</h3></th>
  213. <th><h3>Nama Karyawan</h3></th>
  214. <th><h3>Email</h3></th>
  215. <th><h3>Jenis Kelamin</h3></th>
  216. <th><h3>Tanggal Masuk</h3></th>
  217. <th><h3>Action</h3></th>
  218. <tr>
  219. <?
  220. $sqlCommand = 'SELECT * FROM karyawan ORDER BY nama_kary ASC';
  221. $query = mysql_query($sqlCommand);
  222. while ($row = mysql_fetch_array(($query))){
  223. $username = $row ['username'];
  224. $nama_kary= $row['nama_kary'];
  225. $password = $row ['password'];
  226. $email = $row ['email'];
  227. $jk = $row ['jenis_kelamin'];
  228. $tanggal = $row ['tanggal'];
  229. ?>
  230. <tr>
  231. <td style="width:5%;" align="center"><?echo $username."<br/>";?></td>
  232. <td style="width:5%;" align="center"><?echo $nama_kary."<br/>";?></td>
  233. <td style="width:5%;" align="center"><?echo $email."<br/>";?></td>
  234. <td style="width:5%;" align="center"><?
  235. if ($jk==0){
  236. echo "Laki-laki <br/>";
  237. }else{
  238. echo "Perempuan <br/>";
  239. }
  240. ?></td>
  241. <td style="width:5%;" align="center"><?echo $tanggal."<br/>";?></td>
  242. <td style="width:5%;" align="center">
  243. <a href="<?=$_SERVER['PHP_SELF']?>?mode=1&username=<?=$username?>">Edit</a>
  244. <a href="<?=$_SERVER['PHP_SELF']?>?mode=2&username=<?=$username?>">Delete</a>
  245. </td>
  246. </tr>
  247. <?}?>
  248. </table>
  249.  
  250.  
  251. </body>
  252. </html>
  253. <?
  254. }?>
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!