API tools faq
paste
Advertisement
cdsatrian

pencarian dengan if

cdsatrian
Apr 16th, 2013
84
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.44 KB | None | 0 0
raw download clone embed print report
  1. <!DOCTYPE html>
  2. <html>
  3.   <head>
  4.     <title>Searching</title>
  5.     <style type="text/css">
  6.       body {font-family:calibri,arial,sans-serif:12pt;}
  7.       .container {width:500px;background-color:#ffc;-moz-box-shadow:2px 2px 8px rgba(0,0,0,0.5);-webkit-box-shadow:2px 2px 8px rgba(0,0,0,0.5);padding:3px;-webkit-border-radius: 4px;-moz-border-radius: 4px;border-radius: 4px;}
  8.       .error {font-weight:bold;color:#900;background-color:#e99;width:100%;padding:4px 10px;text-align:center;}
  9.       .keyword {font-weight:bold;color:#009;background-color:#ffc;}
  10.       input,select {font-family:calibri,arial,sans-serif; font-size:12px;padding:3px;-webkit-border-radius: 4px;-moz-border-radius: 4px;border-radius: 4px;border: solid 1 px #999;color:#333;background-color:#ff9;}
  11.     </style>
  12.   </head>
  13.   <body>
  14.     <header>
  15.       <img src="qasystem.gif" alt="Question Answering FTI UNISBANK" />
  16.       <form method="post" name="pencarian" id="pencarian">
  17.         CARI
  18.         <select name="pilihan" id="pilihan">
  19.           <option value="siapa">siapa</option>
  20.           <option value="apa">apa</option>
  21.         </select>
  22.         <input type="text" name="search" id="search" size="150" maxlength="250" />
  23.         <input type="submit" name="submit" id="submit" value="CARI" />
  24.       </form>
  25.    </header>
  26.    <div class="container">
  27. <?php
  28. $dbhost='localhost';
  29. $dbuser='root';
  30. $dbpass='';
  31. $dbname='QAS'
  32. $db=new mysqli($dnhost,$dbuser,$dbpass,$dbname);
  33. $msg='';
  34. if(isset($_POST['submit']))
  35. {
  36.   $search=isset($_POST['search'])?$_POST['search']:'';
  37.   $pilihan=isset($_POST['pilihan'])?$_POST['pilihan']:'';
  38.   if(!empty($search))
  39.   {
  40.     if($pilihan=='siapa')
  41.     {
  42.       $sql="SELECT nama,pertanyaan "
  43.           ."FROM jabatan "
  44.           ."WHERE nama LIKE '%$search%' ";
  45.       if($result=$db->query($sql))
  46.       {
  47.         if($result->num_rows>0)
  48.         {
  49.           $msg.="<div class='hasil'>"
  50.                ."Data yang anda cari adalah "
  51.                ."<span class='keyword'>".$search."</span>"
  52.                .", dan terdapat [<b>".$result->num_rows."</b>] data yang sesuai."
  53.                ."<hr>\n";
  54.           while($row=$result->fetch_object())
  55.           {
  56.             $msg.=$row->nama.', Jabatannya adalah ===>> '.$row->pertanyaan."<hr/>\n";
  57.           }
  58.           $msg.="</div>\n";
  59.         }
  60.         else
  61.         {
  62.           $msg.="<div class='error'>Maaf, hasil pencarian tidak ditemukan</div>\n";
  63.         }
  64.       }
  65.     }
  66.     elseif($pilihan=='apa')
  67.     {
  68.       $sql="SELECT pertanyaan,visi_misi "
  69.           ."FROM visi_misi "
  70.           ."WHERE pertanyaan LIKE '%$search%' ";
  71.       if($result=$db->query($sql))
  72.       {
  73.         if($result->num_rows>0)
  74.         {
  75.           $row=$result->fetch_object();
  76.             $msg.="<div class='hasil'>"
  77.                  ."Data yang anda cari adalah "
  78.                  ."<span class='keyword'>".$search."</span>"
  79.                  .", dan terdapat [<b>".$result->num_rows."</b>] data yang sesuai."
  80.                ."<hr />\n";
  81.           while($row=$result->fetch_object())
  82.           {
  83.             $msg.=$row->pertanyaan.', Visi Misinya adalah ===>> '.$row->visi_misi."<hr/>\n";
  84.           }
  85.           $msg.="</div>\n";
  86.         }
  87.         else
  88.         {
  89.           $msg.="<div class='error'>Maaf, hasil pencarian tidak ditemukan</div>\n";
  90.         }
  91.       }
  92.     }
  93.   }
  94.   else
  95.   {
  96.     $msg.="<div class='error'>Masukkan dulu kata kuncinya</div>\n";
  97.   }
  98.   echo $msg;
  99. }
  100. ?>
  101.       </div>
  102.   </body>
  103. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!