Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- error_reporting(22);
- // Koneksi
- mysql_connect("localhost","root","");
- mysql_select_db("citramedika");
- $result = mysql_query("select * from kategori");
- echo 'KODE KATEGORI : </select><select name="prdId" onchange="document.getElementById(\'prd_name\').value = prdName[this.value]">';
- echo '<option>pilih</option>';
- while ($row = mysql_fetch_array($result)) {
- echo '<option value="' . $row['product_name'] . '">' . $row['product_name'] . '</option>';
- }
- echo '</select>';
- ?>
- <form action="" method="get">
- <label>
- <input type="submit" name="Submit" value="Search" />
- </label>
- <?php
- if (isset($_POST['Submit'])){
- $search= $_POST['prdId'];
- $sql= "select * from barang where $search like '%$kodekategori%' ";
- $result=mysql_query($sql) or die ('error,list obat failed.'.mysql_error());
- if (mysql_num_rows ($result)== 0 ){
- echo '<p></p><p> pencarian tidak ditemukan </p>';
- }
- else
- {
- echo ' <tr>';
- echo ' <p>KODE BARANG : ' .$kodebarang.'</p>';
- echo ' <p>NAMA BARANG : ' .$namabarang.'</p>';
- echo ' <p>KODE KATEGORI : ' .$kodekategori.'</p>';
- echo ' <p>NAMA KATEGORI : ' .$namakategori.'</p>';
- echo ' <p>DESKRIPSI : ' .$deskripsi.'</p>';
- echo ' <p>STOK : ' .$stok.'</p>';
- echo ' <p>HARGA : ' .$harga.'</p>';
- echo ' </td>';
- echo ' </tr>';
- }}
- /*double } */
- ?>
- <label></label>
- </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement