Advertisement
GWibisono

error on }

Jul 24th, 2013
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.32 KB | None | 0 0
  1. <?php
  2. error_reporting(22);
  3. // Koneksi
  4. mysql_connect("localhost","root","");
  5. mysql_select_db("citramedika");
  6. $result = mysql_query("select * from kategori");
  7.  
  8. echo 'KODE KATEGORI : </select><select name="prdId" onchange="document.getElementById(\'prd_name\').value = prdName[this.value]">';
  9. echo '<option>pilih</option>';
  10. while ($row = mysql_fetch_array($result)) {
  11. echo '<option value="' . $row['product_name'] . '">' . $row['product_name'] . '</option>';
  12.  
  13. }
  14.  
  15. echo '</select>';
  16.  
  17. ?>
  18. <form action="" method="get">
  19. <label>
  20. <input type="submit" name="Submit" value="Search" />
  21. </label>
  22. <?php
  23. if (isset($_POST['Submit'])){
  24. $search= $_POST['prdId'];
  25. $sql= "select * from barang where $search like '%$kodekategori%' ";
  26. $result=mysql_query($sql) or die ('error,list obat failed.'.mysql_error());
  27. if (mysql_num_rows ($result)== 0 ){
  28. echo '<p></p><p> pencarian tidak ditemukan </p>';
  29. }
  30. else
  31. {
  32.  
  33. echo ' <tr>';
  34.  
  35. echo ' <p>KODE BARANG : ' .$kodebarang.'</p>';
  36. echo ' <p>NAMA BARANG : ' .$namabarang.'</p>';
  37. echo ' <p>KODE KATEGORI : ' .$kodekategori.'</p>';
  38. echo ' <p>NAMA KATEGORI : ' .$namakategori.'</p>';
  39. echo ' <p>DESKRIPSI : ' .$deskripsi.'</p>';
  40. echo ' <p>STOK : ' .$stok.'</p>';
  41. echo ' <p>HARGA : ' .$harga.'</p>';
  42.  
  43. echo ' </td>';
  44.  
  45. echo ' </tr>';
  46. }}
  47. /*double } */
  48. ?>
  49.  
  50. <label></label>
  51. </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement