API tools faq
paste
Advertisement
gujil

mahasiswa.php

gujil
Sep 16th, 2017
482
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 22.94 KB | None | 0 0
raw download clone embed print report
  1. <div class="container-fluid">
  2. <div class="block-header">
  3. <?php
  4. // Proses tambah data
  5. if(isset($_REQUEST['tambah'])){
  6.  
  7. $nim = $_REQUEST['nim'];
  8.  
  9. $password = password_hash($_REQUEST['password'], PASSWORD_DEFAULT);
  10.  
  11. //$password = $_POST['passwordpass'];
  12. $ambil = $koneksi->query("SELECT nim FROM mahasiswa WHERE nim='$nim'");
  13. if($ambil->num_rows > 0){
  14. echo '<script>alert("Nim Sudah Terdaftar!")</script>';
  15. }
  16. else{
  17.  
  18. $koneksi->query("INSERT INTO user (username, password, level) VALUES ('$nim', '$password', 'mahasiswa')");
  19.  
  20. $koneksi->query("INSERT INTO mahasiswa (id_user, nim, lama, sts)
  21. VALUES ((SELECT id_user FROM user WHERE username='$nim'), '$nim', '$_REQUEST[tgl]', 'Aktif')");
  22.  
  23. $koneksi->query("INSERT INTO tempat (id_user, id_perusahaan)
  24. VALUES ((SELECT id_user FROM user WHERE username='$nim'), '$_REQUEST[perusahaan]')");
  25.  
  26. if($koneksi->errno > 0){
  27. echo $koneksi->error;
  28. }
  29.  
  30. echo '<div class="alert alert-success">Data Berhasil Disimpan</div>';
  31. }
  32.  
  33. }
  34.  
  35. // Proses edit
  36. if(isset($_REQUEST['edit'])){
  37.  
  38. $id_user = $_REQUEST['id_user'];
  39. $koneksi->query("UPDATE mahasiswa SET nim='$_REQUEST[nim]', realname='$_REQUEST[nama]', jurusan='$_REQUEST[jurusan]', jen_kel='$_REQUEST[jen_kel]', kelas='$_REQUEST[kelas]', lama='$_REQUEST[tanggal]', email='$_REQUEST[email]', no_hp ='$_REQUEST[telpon]' WHERE id_user='$id_user'");
  40.  
  41. // $koneksi->query("UPDATE tempat SET id_perusahaan='$_POST[perusahaan]' WHERE id_user='$id_user'");
  42.  
  43. if($koneksi->errno > 0){
  44. echo $koneksi->error;
  45. }
  46.  
  47. echo '<div class="alert alert-info">Data Berhasil Dirubah</div>';
  48. }
  49. ?>
  50. </div>
  51. <!-- Basic Examples -->
  52. <div class="row clearfix">
  53. <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
  54. <div class="card">
  55. <div class="header">
  56. <h2>
  57. BASIC EXAMPLE
  58. </h2>
  59. <ul class="header-dropdown m-r--5">
  60. <li class="dropdown">
  61. <a href="javascript:void(0);" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
  62. <i class="material-icons">more_vert</i>
  63. </a>
  64. <ul class="dropdown-menu pull-right">
  65. <li><a href="" data-toggle="modal" data-target="#defaultModal"><i class="material-icons">add</i>Tambah Data</a></li>
  66. </ul>
  67. </li>
  68. </ul>
  69. </div>
  70. <div class="body">
  71. <div class="table-responsive">
  72. <table class="table table-bordered table-striped table-hover js-basic-example dataTable">
  73. <thead>
  74. <tr>
  75. <th>No</th>
  76. <th>Nim</th>
  77. <th>Nama</th>
  78. <th>Jenis Kelamin</th>
  79. <th>Jurusan</th>
  80. <th>Kelas</th>
  81. <th>No HP</th>
  82. <th>Opsi</th>
  83. </tr>
  84. </thead>
  85.  
  86. <tbody>
  87. <?php
  88. $nomor = 1;
  89. $ambil = $koneksi->query("SELECT * FROM user
  90. JOIN mahasiswa ON mahasiswa.id_user=user.id_user
  91. JOIN tempat ON tempat.id_user=user.id_user
  92. JOIN perusahaan ON tempat.id_perusahaan=perusahaan.id_perusahaan ");
  93. while($pecah = $ambil->fetch_assoc()){
  94. ?>
  95. <tr>
  96. <td><?php echo $nomor++; ?></td>
  97. <td><?php echo $pecah['nim'] ?></td>
  98. <td><?php echo $pecah['realname'] ?></td>
  99. <td><?php echo $pecah['jen_kel'] ?></td>
  100. <td><?php echo $pecah['jurusan'] ?></td>
  101. <td><?php echo $pecah['kelas'] ?></td>
  102. <td><?php echo $pecah['no_hp'] ?></td>
  103.  
  104. <td>
  105. <a href="#" class="btn bg-teal btn-circle waves-effect waves-circle waves-float" data-toggle="modal" data-target='#edit_mahasiswa<?php echo $pecah['id_user'] ?>'>
  106. <i class="material-icons">edit</i>
  107. </a>
  108. <button type="button" class="btn bg-deep-orange btn-circle waves-effect waves-circle waves-float">
  109. <i class="material-icons">delete</i>
  110. </button>
  111. </td>
  112. <!-- Edit Mahasiswa -->
  113. <div class="modal fade" id="edit_mahasiswa<?php echo $pecah['id_user'] ?>" tabindex="-1" role="dialog">
  114. <div class="modal-dialog" role="document">
  115. <div class="modal-content">
  116. <div class="modal-header">
  117. <h4 class="modal-title" id="defaultModalLabel">Edit Mahasiswa</h4>
  118. </div>
  119. <div class="modal-body">
  120. <hr>
  121. <form method="post">
  122. <input type="hidden" name="id_user" value="<?php echo $pecah['id_user'] ?>">
  123. <div class="row">
  124. <div class="col-md-6">
  125. <div class="form-group">
  126. <p>
  127. <b>Nim</b>
  128. </p>
  129. <div class="form-line">
  130. <input type="text" class="form-control" name="nim" placeholder="Ex: 201412001" value="<?php echo $pecah['nim'] ?>" required>
  131. </div>
  132. </div>
  133. </div>
  134. <div class="col-md-6">
  135. <div class="form-group">
  136. <p>
  137. <b>Nama</b>
  138. </p>
  139. <div class="form-line">
  140. <input type="text" class="form-control" name="nama" placeholder="Ex: Fahri" value="<?php echo $pecah['realname'] ?>" required>
  141. </div>
  142. </div>
  143. </div>
  144. </div>
  145. <div class="row">
  146. <div class="col-md-6">
  147. <p>
  148. <b>Jurusan</b>
  149. </p>
  150. <div class="form-line">
  151. <select class="form-control show-tick" name="jurusan" required>
  152. <option value="">-- pilih Jurusan --</option>
  153. <option value="Teknik Informatika" <?php echo $pecah['jurusan']=='Teknik Informatika'?'selected':''; ?>>Teknik Informatika</option>
  154. <option value="Teknik Elektro" <?php echo $pecah['jurusan']=='Teknik Elektro'?'selected':''; ?>>Teknik Elektro</option>
  155. </select>
  156. </div>
  157. </div>
  158. <div class="col-md-6">
  159. <p>
  160. <b>Kelas</b>
  161. </p>
  162. <div class="form-line">
  163. <select class="form-control show-tick" name="kelas" required>
  164. <option value="">-- pilih kelas --</option>
  165. <option value="Pagi" <?php echo $pecah['kelas']=='Pagi'?'selected':''; ?>>Pagi</option>
  166. <option value="Sore" <?php echo $pecah['kelas']=='Sore'?'selected':''; ?>>Sore</option>
  167. </select>
  168. </div>
  169. </div>
  170. </div><br>
  171. <div class="row">
  172. <div class="col-md-6">
  173. <p>
  174. <b>Jenis Kelamin</b>
  175. </p>
  176. <div class="form-line">
  177. <select class="form-control show-tick" name="jen_kel" required>
  178. <option value="">-- pilih Jenis Kelamin --</option>
  179. <option value="Laki-laki" <?php echo $pecah['jen_kel']=='Laki-laki'?'selected':''; ?>>Laki-laki</option>
  180. <option value="Perempuan" <?php echo $pecah['jen_kel']=='Perempuan'?'selected':''; ?>>Perempuan</option>
  181. </select>
  182. </div>
  183. </div>
  184. <div class="col-md-6">
  185. <p class="font-bold col-pink">
  186. <b>Status</b>
  187. </p>
  188. <div class="form-line">
  189. <select class="form-control show-tick" name="status" required>
  190. <option value="">-- pilih Statuss --</option>
  191. <option value="Aktif" <?php echo $pecah['sts']=='Aktif'?'selected':''; ?>>Aktif</option>
  192. <option value="Non-Aktif" <?php echo $pecah['sts']=='Non-Aktif'?'selected':''; ?>>Non-Aktif</option>
  193. </select>
  194. </div>
  195. </div>
  196. </div><br>
  197. <div class="row">
  198. <div class="col-md-6">
  199. <div class="form-group">
  200. <p>
  201. <b>Email</b>
  202. </p>
  203. <div class="form-line">
  204. <input type="text" class="form-control email" name="email" value="<?php echo $pecah['email'] ?>" placeholder="Ex: example@example.com" required>
  205. </div>
  206. </div>
  207. </div>
  208. <div class="col-md-6">
  209. <div class="form-group">
  210. <p>
  211. <b>Telpon</b>
  212. </p>
  213. <div class="form-line">
  214. <input type="text" class="form-control mobile-phone-number" name="telpon" value="<?php echo $pecah['no_hp'] ?>" placeholder="Ex: +00 (000) 000-00-00" required>
  215. </div>
  216. </div>
  217. </div>
  218. </div>
  219. <div class="row">
  220. <div class="col-md-6">
  221. <p>
  222. <b>Tempat KP</b>
  223. </p>
  224. <select class="form-control show-tick" data-live-search="true" name="perusahaan" required>
  225. <option>-- Pilih Tempat KP --</option>
  226. <?php
  227. $sql = $koneksi->query("SELECT * FROM perusahaan");
  228. while($result = $sql->fetch_assoc()){
  229. $id_perusahaan =$result ['id_perusahaan'];
  230. $perusahaan = $result['nama_perusahaan'];
  231. $pilih = $pecah['id_perusahaan'] == $result['id_perusahaan'] ? "selected" : "";
  232. echo "<option value='$id_perusahaan' $pilih>$perusahaan</option>";
  233. }
  234.  
  235. ?>
  236. </select>
  237. </div>
  238. <div class="col-md-6">
  239. <div class="form-group">
  240. <p>
  241. <b>Tannggal Berakhir KP</b>
  242. </p>
  243. <div class="form-line">
  244. <input type="text" class="datepicker form-control date" name="tanggal" value="<?php echo $pecah['lama'] ?>" placeholder="Ex: 30/07/2016" required>
  245. </div>
  246. </div>
  247. </div>
  248. </div>
  249. </div>
  250. <div class="modal-footer">
  251. <button type="simpan" class="btn btn-info waves-effect" name="edit">SAVE CHANGES</button>
  252. <button type="button" class="btn btn-link waves-effect" data-dismiss="modal">CLOSE</button>
  253. </div>
  254. </form>
  255. </div>
  256. </div>
  257. </div>
  258.  
  259.  
  260. </tr>
  261. <?php }
  262. ?>
  263. </tbody>
  264. </table>
  265. </div>
  266. </div>
  267. </div>
  268. </div>
  269. </div>
  270. </div>
  271.  
  272. <!-- Modal tambah data -->
  273. <div class="modal fade" id="defaultModal" tabindex="-1" role="dialog">
  274. <div class="modal-dialog" role="document">
  275. <div class="modal-content">
  276. <div class="modal-header">
  277. <h4 class="modal-title" id="defaultModalLabel">Tambah Mahasiswa</h4>
  278. </div>
  279. <div class="modal-body">
  280. <hr>
  281. <form method="post">
  282. <div class="row">
  283. <div class="col-md-4">
  284. <div class="input-group">
  285. <span class="input-group-addon">
  286. <i class="material-icons">person</i>
  287. </span>
  288. <div class="form-line">
  289. <input type="text" class="form-control date" name="nim" placeholder="Nim">
  290. </div>
  291. </div>
  292. </div>
  293. <div class="col-md-4">
  294. <div class="demo-checkbox">
  295. <input type="checkbox" id="basic_checkbox_1" name="billingtoo" onclick="FillBilling(this.form)"/>
  296. <label for="basic_checkbox_1">Check jika username & password sama</label>
  297. </div>
  298.  
  299. </div>
  300. <div class="col-md-4">
  301. <div class="input-group">
  302. <span class="input-group-addon">
  303. <i class="material-icons">https</i>
  304. </span>
  305. <div class="form-line">
  306. <input type="password" class="form-control date" name="password" placeholder="Password">
  307. </div>
  308. </div>
  309. </div>
  310. </div>
  311. <div class="row clearfix">
  312. <div class="col-md-8">
  313. <select class="form-control show-tick" data-live-search="true" name="perusahaan">
  314. <option>-- Pilih Tempat KP --</option>
  315. <?php
  316. $sql = $koneksi->query("SELECT * FROM perusahaan");
  317. while($result = $sql->fetch_assoc()){
  318. $id_perusahaan =$result ['id_perusahaan'];
  319. $perusahaan = $result['nama_perusahaan'];
  320. echo "<option value='$id_perusahaan'>$perusahaan</option>";
  321. }
  322.  
  323. ?>
  324. </select>
  325. </div>
  326. <div class="col-md-4">
  327. <div class="input-group">
  328. <span class="input-group-addon">
  329. <i class="material-icons">date_range</i>
  330. </span>
  331. <div class="form-line">
  332. <input type="text" class="datepicker form-control" name="tgl" placeholder="Berakhir KP tanggal...">
  333. </div>
  334. </div>
  335. </div>
  336. </div>
  337.  
  338. </div>
  339. <div class="modal-footer">
  340. <button type="simpan" class="btn btn-link waves-effect" name="tambah">SAVE CHANGES</button>
  341. <button type="button" class="btn btn-link waves-effect" data-dismiss="modal">CLOSE</button>
  342. </div>
  343. </form>
  344. </div>
  345. </div>
  346. </div>
  347.  
  348. <!-- Modal tambah data -->
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!