API tools faq
paste
Advertisement
Meylanwongkar

ubah_akun.php

Meylanwongkar
Nov 13th, 2018
635
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.12 KB | None | 0 0
raw download clone embed print report
  1. <html>
  2. <?php
  3. include '../koneksi.php';
  4. $data = mysqli_query($conn,"SELECT laboratorium.nama_lab,pengurus.id_pengurus,pengurus.nama_pengurus,pengurus.username_pengurus,pengurus.password_pengurus,pengurus.jabatan_pengurus,pengurus.status_user
  5. FROM laboratorium INNER JOIN pengurus ON laboratorium.id_lab=pengurus.id_lab WHERE pengurus.id_pengurus='$_GET[id]'");
  6. ?>
  7. <head>
  8. <title>ubah_akun</title>
  9. <link rel ="stylesheet" href="ubah_akun.css" type="text/css">
  10. </head>
  11. <body>
  12.  
  13. <div id="wrapper"/>
  14. <div id="header"><h1>Aplikasi Pengelolaan Laboratorium Komputer</h1></div>
  15.  
  16. <table>
  17. <tr>
  18. <td>
  19. <a href="pengaturan_akun.php"/>
  20. <input type="image" button class = "tombol_back" src="back.jpg" width="50" height"50"><!--tombol kembali-->
  21. </td>
  22.  
  23. <td>
  24. <a href="home_admin.php">
  25. <button class ="button_beranda">Beranda</button></a>
  26. </td>
  27. <td>
  28. <a href="profil_admin.php">
  29. <button class ="button_profil">Profil</button></a>
  30. </td>
  31. <td>
  32. <a href="../logout.php">
  33. <button class ="button_logout">Logout</button></a>
  34. </td>
  35. </tr>
  36.  
  37. </table>
  38.  
  39. <div class ="tambah_akun">
  40. <h2 class="form-header">Form Ubah Data Akun</h2>
  41. <form class="form-container" method="post">
  42. <?php foreach($data as $ubah_akun): ?>
  43. <p>
  44. <input type="text" placeholder="Masukkan nama" value="<?=$ubah_akun["nama_pengurus"]?>">
  45. </p>
  46. <p>
  47. <input type="no_identitas" placeholder="Nomor Identitas" value="<?=$ubah_akun["id_pengurus"]?>">
  48. </p>
  49. <p>
  50. Pilih Jabatan :<select name='jabatan' class="form-container">
  51. <option value="Koordinator Lab" <?php if ($ubah_akun['jabatan_pengurus'] == 'Koordinator Lab'){ echo 'selected'; }?>>Koordinator Lab</option>
  52. <option value="Asisten Lab" <?php if ($ubah_akun['jabatan_pengurus'] == 'Asisten Lab'){ echo 'selected'; }?>>Asisten Lab</option>
  53. </select>
  54. </p>
  55. <p>
  56. Pilih Laboratorium :<select name="nama_lab" class="form-container">
  57. <option value="Multimedia" <?php if($ubah_akun['nama_lab'] == 'Multimedia'){ echo 'selected'; } ?>>Multimedia</option>
  58. <option value="Basis Data" <?php if($ubah_akun['nama_lab'] == 'Basisdata'){ echo 'selected'; } ?>>Basis Data</option>
  59. <option value="Pemrograman" <?php if($ubah_akun['nama_lab'] == 'Pemrograman'){ echo 'selected'; } ?>>Pemrograman</option>
  60. </select>
  61. </p>
  62. <p>
  63. Status Pengurus :<select name="status_user" class="form-container">
  64. <option value="Aktif" <?php if($ubah_akun['status_user'] == 'Aktif'){ echo 'selected'; } ?>>Aktif</option>
  65. <option value="Tidak Aktif" <?php if($ubah_akun['status_user'] == 'Tidak Aktif'){ echo 'selected'; } ?>>Tidak Aktif</option>
  66. </select>
  67. </p>
  68. <p>
  69. <input type="text" placeholder="Masukkan nama" value="<?=$ubah_akun["username_pengurus"]?>">
  70. </p>
  71. <p> <!-- coding for masukkan dan show password-->
  72. Password: <input type="password" class="form-container" id="myInput" value="<?=$ubah_akun["password_pengurus"]?>">
  73. <input type="checkbox" class="form-container" onclick="myFunction()">Show Password
  74. </p>
  75. <?php endforeach; ?>
  76. <p>
  77. <input type="submit" name="simpan" value="Simpan">
  78. </p>
  79. </div>
  80. <script src="show_password.js"></script>
  81.  
  82. </p>
  83.  
  84. </form>
  85. </div>
  86. <?php
  87. if (isset($_POST['simpan']))
  88. {
  89. $nama_pengurus = $_POST['nama_pengurus'];
  90. $id_pengurus = $_POST['id_pengurus'];
  91. $username_pengurus = $_POST['username_pengurus'];
  92. $password_pengurus = $_POST['password_pengurus'];
  93. $jabatan_pengurus = $_POST['jabatan_pengurus'];
  94. $status_user = $_POST['status_user'];
  95. $nama_lab = $_POST['nama_lab'];
  96. if($nama_lab == 'Multimedia'){
  97. mysqli_query($conn, "UPDATE pengurus SET id_pengurus='$id_pengurus', nama_pengurus='$nama_pengurus',
  98. username_pengurus='$username_pengurus', password_pengurus='$password_pengurus', jabatan_pengurus='Asisten Lab', id_lab='1', status_user='$status_user' WHERE id_pengurus='$_GET[id]'");
  99. echo "<script>location='pengaturan_akun.php';</script>";
  100. }else if($nama_lab == 'Pemrograman'){
  101. mysqli_query($conn, "UPDATE pengurus SET id_pengurus='$id_pengurus', nama_pengurus='$nama_pengurus',
  102. username_pengurus='$username_pengurus', password_pengurus='$password_pengurus', jabatan_pengurus='Asisten Lab', id_lab='2', status_user='$status_user' WHERE id_pengurus='$_GET[id]'");
  103. echo "<script>location='pengaturan_akun.php';</script>";
  104. }else if($nama_lab == 'Basis Data'){
  105. mysqli_query($conn, "UPDATE pengurus SET id_pengurus='$id_pengurus', nama_pengurus='$nama_pengurus',
  106. username_pengurus='$username_pengurus', password_pengurus='$password_pengurus', jabatan_pengurus='Asisten Lab', id_lab='3', status_user='$status_user' WHERE id_pengurus='$_GET[id]'");
  107. echo "<script>location='pengaturan_akun.php';</script>";
  108. }
  109.  
  110. if($nama_lab == 'Multimedia'){
  111. mysqli_query($conn, "UPDATE pengurus SET id_pengurus='$id_pengurus', nama_pengurus='$nama_pengurus',
  112. username_pengurus='$username_pengurus', password_pengurus='$password_pengurus', jabatan_pengurus='Koordinator Lab', id_lab='1', status_user='$status_user' WHERE id_pengurus='$_GET[id]'");
  113. echo "<script>location='pengaturan_akun.php';</script>";
  114. }else if($nama_lab == 'Pemrograman'){
  115. mysqli_query($conn, "UPDATE pengurus SET id_pengurus='$id_pengurus', nama_pengurus='$nama_pengurus',
  116. username_pengurus='$username_pengurus', password_pengurus='$password_pengurus', jabatan_pengurus='Koordinator Lab', id_lab='2', status_user='$status_user' WHERE id_pengurus='$_GET[id]'");
  117. echo "<script>location='pengaturan_akun.php';</script>";
  118. }else if($nama_lab == 'Basis Data'){
  119. mysqli_query($conn, "UPDATE pengurus SET id_pengurus='$id_pengurus', nama_pengurus='$nama_pengurus',
  120. username_pengurus='$username_pengurus', password_pengurus='$password_pengurus', jabatan_pengurus='Koordinator Lab', id_lab='3', status_user='$status_user' WHERE id_pengurus='$_GET[id]'");
  121. echo "<script>location='pengaturan_akun.php';</script>";
  122. }
  123. }
  124. ?>
  125. </body>
  126. </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!