Advertisement
BimoSora

pencarian

Nov 3rd, 2019
1,059
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. <?php
  2.  
  3. $kon=new PDO("mysql:host=localhost;dbname=coba","root","");
  4.  
  5. if(isset($_POST['cari'])){
  6.  
  7.         $pencarian="%".$_POST['kata']."%";
  8.  
  9.         try{
  10.  
  11.             $cari=$kon->prepare("select nama_buku from buku where nama_buku like :nama");
  12.  
  13.             $cari->BindParam(":nama",$pencarian);
  14.  
  15.             $cari->execute();
  16.  
  17.             if($cari->rowCount()<1){
  18.  
  19.                 echo "<i> Tidak ada hasil untuk pencarian kata <b>\"".$_POST['kata']."\"</i></b>";
  20.  
  21.             }else{
  22.  
  23.                 echo "<i> Hasil pencarian dengan kata <b>\"".$_POST['kata']."\"</b></i><br>";
  24.  
  25.                 while($t=$cari->fetch()){
  26.  
  27.                 echo $t['nama_buku']."<br>";
  28.  
  29.                 }
  30.  
  31.             }  
  32.  
  33.         }catch(PDOException $e){
  34.  
  35.             echo $e->getMessage();
  36.  
  37.         }
  38.  
  39. }
  40. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement