Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>Search Enggine </title>
- </head>
- <body>
- <?php
- include_once "inc.koneksi.php";
- $TxtKunci =$_POST['TxtKunci'];
- if (empty ($TxtKunci) ) {
- echo "KATA KUNCI masih kosong";
- }
- else {
- $tmpkunci = $TxtKunci;
- $datakunci = strtoupper($TxtKunci);
- $datakunci = strip_tags($TxtKunci);
- $datakunci = trim ($TxtKunci);
- $trimmed = trim($datakunci);
- $trimmed_array = explode(" ",$trimmed);
- if ($trimmed == "") {
- echo "<p>Search Error</p><p>Silakan masukan kata kunci ...</p>" ;
- }
- foreach ($trimmed_array as $trimm){
- $sql_cari="SELECT * FROM dep
- WHERE UPPER(nobil) = \"$trimm\" and status='ACTIVE'
- ORDER BY id_alamat ASC " ;
- $qry_cari = mysql_query($sql_cari, $konek)
- or die ("Gagal query cari");
- }
- if (mysql_num_rows($qry_cari)==0) {
- include "search_utama.php";
- echo "<h3> Hasil Pencarian Kosong</h3>";
- exit;
- }
- else {
- include "search_utama.php";
- while($data_cari=mysql_fetch_array($qry_cari)){
- $tgl=substr($data_cari['tgl_data'],8,2);
- $bln=substr($data_cari['tgl_data'],5,2);
- $thn=substr($data_cari['tgl_data'],0,4);
- foreach ($trimmed_array as $trimm){
- $infotampil =str_replace($trimm,"<b>$trimm</b>",$data_cari[informasi]);
- }
- echo "<b><font size='3'>
- [ <a href='search_tampil.php?idtampil=$data_cari[id_alamat]&nobil=$data_cari[nobil]&nama=$data_cari[nama]'>
- CIF BANK = $data_cari[cif]||NAMA = $data_cari[nama] ||NO BILYET = $data_cari[nobil]</a> ]</font></b>";
- echo "<b> [ <<<< klik link disamping melihat detail ] </b><br>";
- //echo "$data_cari[informasi]";
- echo "$infotampil<br><br>";
- }
- }
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement