nDh4

rev_combo

Jun 28th, 2012
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.73 KB | None | 0 0
  1. <html>
  2. <head>
  3. <title></title>
  4. <script src="../datetimepicker_css.js"></script>
  5. </head>
  6. <body>
  7.  
  8. <hr />
  9. <h3>.: Input Data Barang :.</h3>
  10. <form method="post" action="combo.php">
  11. Jumlah Item Barang :
  12. <input type="text" name="jum">
  13.  
  14. <input type="submit" name="submit" value="Submit">
  15. </form>
  16.  
  17. <?
  18. if($_POST)
  19. echo $tim = $_POST['C_TIM'];
  20. {
  21. $n = $_POST['jum']; // membaca jumlah data
  22. // koneksi ke mysql
  23. $C= mysql_connect("localhost", "root", "root") or die(mysql_error());
  24. mysql_select_db("pln");
  25.  
  26. $tug=mysql_query("SELECT MAX(CAST(substring(ID_MSK, 4)AS UNSIGNED)) FROM t_msk ");
  27. $arrData2 = mysql_fetch_row($tug);
  28. $gabtug = 'TUG'.($arrData2[0] ? ++$arrData2[0] : 1);
  29. $select= "<select name='brg[]'>";
  30. /*
  31. kamu tulis listnya disini
  32. */
  33. $result = mysql_query("SELECT a.KD_BRG, a.NM_BRG, b.SATUAN FROM t_brg a, t_satuan b WHERE a.ID_SAT=b.ID_SAT")or die(mysql_error());
  34. //$jsArray = "var prdName = new Array();\n";
  35.  
  36. //$select.= '<option>-------</option>';
  37. while ($row = mysql_fetch_array($result)) {
  38. $select.= '<option value="' . $row['KD_BRG'] . '">' . $row['NM_BRG'] . '('.$row['SATUAN'].')</option>';
  39. //
  40. }
  41. //echo $row['KD_BRG'];
  42. $select.="</select> *Pilih dari list disamping";
  43.  
  44. ?>
  45. </p>
  46.  
  47. <?
  48.  
  49. include '../../koneksi.php';
  50. /*
  51. $datanim = $_POST[brg];
  52. echo $datanim;
  53. */
  54. $qry = "SELECT a.C_TIM, a.NM_KETUA, a.NM_KASIR, a.NM_ENTRY, a.NM_APP,
  55. b.NM_BIRO, c.LOKASI FROM t_tim a, t_biro b, t_lokasi c
  56. WHERE a.C_BIRO=b.C_BIRO AND c.C_LOKASI=b.C_LOKASI
  57. ORDER BY a.C_TIM ASC";
  58.  
  59. $hsl = mysql_query($qry);
  60. $ary = mysql_fetch_array($hsl);
  61. ?>
  62.  
  63. <form method="post" action="ins.php">
  64. <h3>.: Data Tim Sarling :. </h3>
  65. <table width="339" border="0">
  66. <tr>
  67. <td width="138">Nama Tim</td>
  68. <td width="10">:</td>
  69. <td width="162"><input type="text" name="C_TIM" id="C_TIM" value="<? echo $ary['C_TIM']; ?>" /></td>
  70. <td width="11">&nbsp;</td>
  71. </tr>
  72. <tr>
  73. <td>Nama APP</td>
  74. <td>:</td>
  75. <td><input type="text" name="NM_APP" id="NM_APP" value="<? echo $ary['NM_APP']; ?>"/></td>
  76. <td>&nbsp;</td>
  77. </tr>
  78. <tr>
  79. <td>Nama Biro</td>
  80. <td>&nbsp;</td>
  81. <td><input type="text" name="NM_BIRO" id="NM_BIRO" value="<? echo $ary['NM_BIRO']; ?>"/></td>
  82. <td>&nbsp;</td>
  83. </tr>
  84. <tr>
  85. <td>Lokasi</td>
  86. <td>:</td>
  87. <td><input type="text" name="LOKASI" id="LOKASI" value="<? echo $ary['LOKASI']; ?>"/></td>
  88. <td>&nbsp;</td>
  89. </tr>
  90. </table>
  91. <hr />
  92. <h2>.: INPUT DATA BARANG SEBANYAK <?=$n;?> :.</h2>
  93.  
  94.  
  95. <table border=0 >
  96. <tr>
  97. <td>No Masuk </td>
  98.  
  99. <td><input type="text" name="ID_MSK" id="ID_MSK" value="<? echo $gabtug; ?>"></td>
  100. </tr>
  101. <tr>
  102. <td>Tanggal </td>
  103.  
  104. <td>
  105. <input type="text" name="TGL_MSK" id="TGL_MSK" />
  106. <img src="../images2/cal.gif" alt="" height="18" style="cursor:pointer" onClick="javascript:NewCssCal('TGL_MSK','yyyyMMdd')"/></td>
  107. </tr>
  108. <tr>
  109. <td>Nomor KWH</td>
  110. <td>
  111. <input type="text" name="NO_KWH" id="NO_KWH"></td>
  112. </tr>
  113.  
  114. <tr>
  115. <td>Merek </td>
  116.  
  117. <td>
  118. <input type="text" name="MERK" id="MERK"></td>
  119. </tr>
  120.  
  121. <?php
  122.  
  123. for ($i=1; $i<=$n; $i++)
  124. {
  125.  
  126. echo "
  127. <tr>
  128. <tr>
  129. <td>Nama Barang</td>
  130. <td> $select </td>";
  131.  
  132. /*
  133. <input type='text' name='nm_brg".$i."'>
  134. */
  135. echo "</tr>
  136. <tr>
  137. <td>Jumlah</td>
  138. <td><input type='text' name='JML_MSK[]'></td>
  139. </tr>
  140. </tr>";
  141.  
  142. //echo $row['KD_BRG'];
  143. }
  144.  
  145.  
  146.  
  147. ?>
  148.  
  149. </table>
  150. </p>
  151.  
  152. <input type="hidden" name="C_TIM" value="<? echo $ary['C_TIM']; ?>" />
  153. <input type="submit" name="submit" value="Submit">
  154.  
  155. <br></form>
  156. <?php
  157. }
  158. ?>
  159.  
  160.  
  161.  
  162.  
  163.  
  164. <p>
  165. </p>
  166. </body>
  167. </html>
Advertisement
Add Comment
Please, Sign In to add comment