API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2017
66
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.52 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3. $user_id=$_SESSION['user_id'];
  4. $user_pass=$_SESSION['user_pass'];
  5. if(!isset($_SESSION['user_id']) or ! isset($_SESSION['user_pass']))
  6. {
  7. header("location:../index.html");
  8. }
  9. ?>
  10. <html>
  11. <head>
  12. <title> DB TEKNISI</title>
  13. <link href="../style.css" rel="stylesheet" type="text/css">
  14. <script language="javascript" src="jquery.js"></script>
  15. <script language="javascript">
  16. /*
  17. fungsi loadData akan meng-handle semua request tipe data
  18. baik pulau, propinsi atau kabupaten/kota.
  19. parameter kedua dari fungsi ini untuk mengirimkan id dari data parent.
  20. contoh: apabila type=propinsi maka parentId digunakan untuk mengambil semua propinsi
  21. dengan id pulau = parentId
  22. */
  23. function loadData(type,parentId){
  24. // berikan kondisi sedang loading data ketika proses pengambilan data
  25. $('#loading').text('Loading '+type.replace('_','/')+' data...');
  26. $.post('loaddata.php', // request ke file load_data.php
  27. {data_type: type, parent_id: parentId},
  28. function(data){
  29. if(data.error == undefined){ // jika respon error tidak terdefinisi maka pengambilan data sukses
  30. $('#'+type).empty(); // kosongkan dahulu combobox yang ingin diisi datanya
  31. $('#'+type).append('<option>-Pilih data-</option>'); // buat pilihan awal pada combobox
  32. for(var x=0;x<data.length;x++){
  33. // berikut adalah cara singkat untuk menambahkan element option pada tag <select>
  34. $('#'+type).append($('<option></option>').val(data[x].id).text(data[x].nama));
  35. }
  36. $('#loading').text(''); // hilangkan text loading
  37. }else{
  38. alert(data.error); // jika ada respon error tampilkan alert
  39. }
  40. },'json' // format respon yang diterima langsung di convert menjadi JSON
  41. );
  42. }
  43. $(function(){
  44. // pertama kali halaman di-load, maka ambil seluruh data pulau
  45. loadData('masalah',0);
  46. // fungsi yang dipanggil ketika isi dari combobox pulau dipilih
  47. loadData('dept',0)
  48. // fungsi yang dipanggil ketika isi dari combobox propinsi dipilih
  49. $('#dept').change(
  50. function(){
  51. // apabila nilai pilihan tidak kosong, load data kabupaten/kota
  52. if($('#dept option:selected').val() != '')
  53. loadData('user',$('#dept option:selected').val());
  54. }
  55. );
  56. });
  57. </script>
  58. </head>
  59. <body>
  60.  
  61. <?php
  62. include "../db.php";
  63.  
  64. if(isset ($_POST['submit']))
  65. {
  66. $id=addslashes($_POST['id']);
  67. $masalah=addslashes($_POST['nama_masalah']);
  68. $solusi_masalah=addslashes($_POST['solusi_masalah']);
  69. $dept=addslashes($_POST['dept']);
  70. $user=addslashes($_POST['user']);
  71. $time=addslashes($_POST['time']);
  72. $tgl=addslashes($_POST['tgl']);
  73. $ket=addslashes($_POST['ket']);
  74.  
  75.  
  76. if(empty($masalah)||empty($solusi_masalah)||empty($dept)||empty($user)||empty($time)||empty($tgl)||empty($ket))
  77. {
  78. ?>
  79. <script language="JavaScript">
  80. alert('Data Belum Lengkap');
  81. </script>
  82. <?php
  83. }
  84. else
  85. {
  86.  
  87. // insert data ke dalam tabel sparepart
  88. $sql =mysql_query("insert into laporan_problem (nama_masalah,solusi_masalah,dept,user,time,tgl,ket) values ('$nama_masalah','$masalah','$dept','$user','$time','$tgl','$ket')");
  89.  
  90. if($sql)
  91. {
  92.  
  93.  
  94.  
  95. ?>
  96. <script language="JavaScript">
  97. alert('DATA TELAH DIINPUT');
  98.  
  99. </script>
  100. <?php
  101. }
  102. else{
  103. echo mysql_error();
  104. }
  105. }
  106. }
  107.  
  108. ?>
  109.  
  110.  
  111.  
  112. <table width="996" height="471" border="0" cellpadding="0" cellspacing="0" bgcolor="#ffffff" valign="top" marginheight="0">
  113. <tr>
  114. <td width="992" height="405" valign="top" class="tabtex">
  115. <div align="center">
  116. <table widt="481" border="0" cellpadding="0" cellspacing="0">
  117. <!--DWLayoutTable-->
  118. <form action=""method="post"name="frmguest">
  119. <tr>
  120. <td height="21" colspan="2" align="center" valign="middle" bgcolor="#A8A8A8">INPUT DATA REPORTING MASALAH</td>
  121. </tr>
  122. <tr>
  123. <td height="15" colspan="2" valign="top"><!--DWLayoutEmptyCell-->&nbsp;</td>
  124. </tr>
  125.  
  126. <tr>
  127. <td width="101" height="18" valign="meiddle">&nbsp;Nama Masalah</td>
  128. <td width="378" valign="meiddle">:
  129.  
  130. <?php
  131. //
  132. //// Menarik data dari tabel jenis, colom nama ke option
  133. //$sql ="select nama_masalah from laporan_problem";
  134. //$query =mysql_query($sql);
  135. //echo "<select name=\"nama_masalah\" >";
  136. //while($data =mysql_fetch_array($query)){
  137. //echo "<option value=\"".$data['nama_masalah']."\" >".$data['nama_masalah']."</option>";
  138. //}
  139. //echo "</select>";
  140. ?>
  141. <select name="masalah" id="masalah"></select>
  142.  
  143. <tr>
  144. <td height="18" valign="middle"><!--DWLayoutEmptyCell-->&nbsp;</td>
  145.  
  146. </tr>
  147.  
  148. <tr>
  149. <td width="101" height="18" valign="meiddle">&nbsp;Dept</td>
  150. <td width="378" valign="meiddle">:
  151.  
  152. <?php
  153.  
  154. //// Menarik data dari tabel jenis, colom nama ke option
  155. //$sql ="select nama_user from user";
  156. //$query =mysql_query($sql);
  157. //echo "<select name=\"user\" >";
  158. //while($data =mysql_fetch_array($query)){
  159. //echo "<option value=\"".$data['nama_user']."\" >".$data['nama_user']."</option>";
  160. //}
  161. //echo "</select>";
  162. ?>
  163. <select name="dept" id="dept"></select>
  164.  
  165. <tr>
  166. <td height="18" valign="middle"><!--DWLayoutEmptyCell-->&nbsp;</td>
  167.  
  168. </tr>
  169.  
  170. <tr>
  171. <td width="101" height="18" valign="meiddle">&nbsp;USer</td>
  172. <td width="378" valign="meiddle">:
  173. <select name="user" id="user"></select>
  174. <?php
  175. //
  176. //// Menarik data dari tabel jenis, colom nama ke option
  177. //$sql ="select nama_dept from dept";
  178. //$query =mysql_query($sql);
  179. //echo "<select name=\"dept\" >";
  180. //while($data =mysql_fetch_array($query)){
  181. //echo "<option value=\"".$data['nama_dept']."\" >".$data['nama_dept']."</option>";
  182. //}
  183. //echo "</select>";
  184. ?>
  185.  
  186.  
  187. <tr>
  188. <td height="18" valign="middle"><!--DWLayoutEmptyCell-->&nbsp;</td>
  189.  
  190. </tr>
  191.  
  192.  
  193. <tr>
  194. <td width="101" height="18" valign="meiddle">&nbsp;Tanggal</td>
  195. <td width="378" valign="meiddle">:
  196.  
  197. <input name="tgl"type ="text"id="tgl"size="20"maxlength="20"></td>
  198.  
  199. <tr>
  200. <td height="18" valign="middle"><!--DWLayoutEmptyCell-->&nbsp;</td>
  201.  
  202. </tr>
  203. <tr>
  204. <td width="101" height="18" valign="meiddle">&nbsp;Waktu</td>
  205. <td width="378" valign="meiddle">:
  206.  
  207. <input name="time"type ="text"id="time"size="30"maxlength="20"></td>
  208.  
  209. <tr>
  210. <td height="18" valign="middle"><!--DWLayoutEmptyCell-->&nbsp;</td>
  211.  
  212. </tr>
  213.  
  214.  
  215. <tr>
  216. <td width="101" height="18" valign="meiddle">&nbsp;Solusi Masalah</td>
  217. <td width="378" valign="meiddle">:
  218.  
  219. <textarea name="solusi_masalah" cols="50" rows="3" id="solusi_masalah"></textarea></td>
  220.  
  221. <tr>
  222. <td height="18" valign="middle"><!--DWLayoutEmptyCell-->&nbsp;</td>
  223.  
  224. </tr>
  225.  
  226. <tr>
  227. <td height="49" valign="top">&nbsp;Keterangan</td>
  228. <td valign="top">&nbsp; <textarea name="ket" cols="50" rows="3" id="ket"></textarea>
  229. </tr>
  230.  
  231. <tr>
  232. <td height="18" valign="middle"><!--DWLayoutEmptyCell-->&nbsp;</td>
  233.  
  234. </tr>
  235. <tr>
  236. <td height="14"></td>
  237.  
  238. <td><input name="submit" type="submit" id="submit" value="ISI DATA"> <input type="reset"name="Reset"value="BATAL">
  239.  
  240. <a href="../view/rpt_problem.php">Lihat Data</a>
  241. </tr>
  242. </table>
  243. <br>
  244. </div>
  245. </div>
  246. </td>
  247. <?php
  248. include "../in_.html";
  249. ?>
  250. </tr>
  251. </table>
  252.  
  253.  
  254. </td>
  255.  
  256.  
  257.  
  258. </tr>
  259. <tr>
  260. <td colspan="3">
  261. <table width="1003" border="0" cellspacing="0" cellpadding="0" bgcolor="#000000">
  262. <tr>
  263. <td>
  264. <table width="1003" cellspacing="1" cellpadding="3" border="0">
  265.  
  266. <tr>
  267. <td colspan="3" width="999" height="15" bgcolor="#ACB8D2" class="menu" align="right" background="../images/rowbg.gif"><!--Untere Tabellenzelle oben volle Breite-->
  268. <div align="center"></div></td>
  269.  
  270. </tr>
  271. </table>
  272. </td>
  273. </tr>
  274. </table>
  275.  
  276. </td>
  277. </tr>
  278. </table></div>
  279.  
  280.  
  281. </body>
  282. </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!