Advertisement
Guest User

Untitled

a guest
May 26th, 2017
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.67 KB | None | 0 0
  1. <html>
  2. <head>
  3. <title>Search Enggine </title>
  4. </head>
  5. <body>
  6. <?php
  7. include_once "inc.koneksi.php";
  8.  
  9. $TxtKunci =$_POST['TxtKunci'];
  10.  
  11. if (empty ($TxtKunci) ) {
  12. echo "KATA KUNCI masih kosong";
  13. }
  14. else {
  15. $tmpkunci = $TxtKunci;
  16. $datakunci = strtoupper($TxtKunci);
  17. $datakunci = strip_tags($TxtKunci);
  18. $datakunci = trim ($TxtKunci);
  19.  
  20. $trimmed = trim($datakunci);
  21. $trimmed_array = explode(" ",$trimmed);
  22.  
  23. if ($trimmed == "") {
  24. echo "<p>Search Error</p><p>Silakan masukan kata kunci ...</p>" ;
  25. }
  26.  
  27. foreach ($trimmed_array as $trimm){
  28. $sql_cari="SELECT * FROM dep
  29. WHERE UPPER(nobil) = \"$trimm\" and status='ACTIVE'
  30. ORDER BY id_alamat ASC " ;
  31. $qry_cari = mysql_query($sql_cari, $konek)
  32. or die ("Gagal query cari");
  33. }
  34.  
  35. if (mysql_num_rows($qry_cari)==0) {
  36. include "search_utama.php";
  37.  
  38. echo "<h3> Hasil Pencarian Kosong</h3>";
  39. exit;
  40. }
  41. else {
  42. include "search_utama.php";
  43.  
  44. while($data_cari=mysql_fetch_array($qry_cari)){
  45. $tgl=substr($data_cari['tgl_data'],8,2);
  46. $bln=substr($data_cari['tgl_data'],5,2);
  47. $thn=substr($data_cari['tgl_data'],0,4);
  48.  
  49. foreach ($trimmed_array as $trimm){
  50. $infotampil =str_replace($trimm,"<b>$trimm</b>",$data_cari[informasi]);
  51. }
  52.  
  53. echo "<b><font size='3'>
  54. [ <a href='search_tampil.php?idtampil=$data_cari[id_alamat]&nobil=$data_cari[nobil]&nama=$data_cari[nama]'>
  55. CIF BANK = $data_cari[cif]||NAMA = $data_cari[nama] ||NO BILYET = $data_cari[nobil]</a> ]</font></b>";
  56. echo "<b> [ <<<< klik link disamping melihat detail ] </b><br>";
  57. //echo "$data_cari[informasi]";
  58. echo "$infotampil<br><br>";
  59. }
  60. }
  61. }
  62. ?>
  63. </body>
  64. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement