Advertisement
GWibisono

hasil perbaikan

Jun 27th, 2012
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.27 KB | None | 0 0
  1. <?
  2. if($_POST)
  3. {
  4.  $n = $_POST['jum']; // membaca jumlah data
  5. // koneksi ke mysql
  6.  $C= mysql_connect("localhost", "root", "root") or die(mysql_error());
  7.   mysql_select_db("telkom");
  8.   $tug=mysql_query("SELECT MAX(CAST(substring(id_msk, 4)AS UNSIGNED)) FROM masuk ");
  9.     $arrData2 = mysql_fetch_row($tug);
  10.     $gabtug = 'TUG'.($arrData2[0] ? ++$arrData2[0] : 1);
  11.  $select= "<select name=barang[] >";
  12.     /*
  13.     kamu tulis listnya disini
  14.     */
  15.     $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());  
  16.     $jsArray = "var prdName = new Array();\n";  
  17.    
  18.     $select.= '<option>-------</option>';  
  19.     while ($row = mysql_fetch_array($result)) {  
  20.         $select.= '<option value="' . $row['KD_BRG'] . '">' . $row['NM_BRG'] . '('.
  21. $row['SATUAN'].')</option>';  
  22.          
  23.     }  
  24.  
  25.     $select.="</select> *Pilih dari list disamping";
  26.  
  27.   ?>
  28.   </p>
  29.   <hr />
  30.   <h2>INPUT DATA BARANG SEBANYAK <?=$n;?> </h2>
  31.   <form method="post" action="insert.php">
  32. <hr><?=$select;?><hr>
  33.   <table border=1 >
  34.     <tr>
  35.     <td>No Masuk </td>
  36.  
  37.   <td><input type="text" name="id_msk" id="id_msk" value="<? echo $gabtug; ?>"></td>
  38.   </tr>
  39.   <tr>
  40.   <td>Tanggal </td>
  41.  
  42.   <td>    
  43.     <input type="text" name="tgl" id="tgl"></td>
  44.   </tr>
  45.   <tr>
  46.   <td>Nomor KWH</td>
  47.   <td>  
  48.     <input type="text" name="no_kwh" id="no_kwh"></td>
  49.   </tr>
  50.  
  51.   <tr>
  52.   <td>Merek </td>
  53.  
  54.   <td>    
  55.     <input type="text" name="merk" id="merk"></td>
  56.   </tr>
  57.  
  58.   <?php
  59.    
  60.  
  61.   for ($i=1; $i<=$n; $i++)
  62.   {
  63.    
  64.       echo "
  65.  <tr>
  66.    <tr>
  67.    <td>Nama Barang</td>
  68.   <td> $select  </td>";
  69.  
  70.    /*
  71. <input type='text' name='nm_brg".$i."'>
  72.    */
  73.     echo "</tr>
  74.    <tr>
  75.    <td>satuan</td>
  76.  <td><input type='text' name='satuan[]'></td>
  77.    </tr>
  78.    <tr>
  79.    <td>Jumlah</td>
  80.  <td><input type='text' name='jml[]'></td>
  81.    </tr>
  82.  </tr>";
  83.  
  84.   }
  85.  
  86.  
  87. ?>
  88.  
  89. </table>
  90.   </p>
  91. <input type="hidden" name="jum" value="<?php echo $n; ?>">
  92.  
  93. <input type="submit" name="submit" value="Submit">
  94.  
  95.   <br></form>
  96. <?php
  97. }
  98. ?>
  99. <h3>Input Data Mahasiswa</h3><form method="post" action="form.php">
  100.   Jumlah Data
  101.     <input type="text" name="jum"> <input type="submit" name="submit" value="Submit">
  102.  
  103. </form>
  104.  
  105.  
  106. <p>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement