kost

Form.php:
<?php
include_once('conf/koneksi.php');
function GetCheckboxes($table, $key, $Label, $Nilai='') {
                     $s = "select * from $table order by nama_fasilitas";
                      $r = mysql_query($s);
                      $_arrNilai = explode(',', $Nilai);
                      $str = '';
                      while ($w = mysql_fetch_array($r)) {
                      $_ck = (array_search($w[$key], $_arrNilai) === false)? '' : 'checked';
                      $str .= "<input type=checkbox name='".$key."[]' value='$w[$key]' $_ck>$w[$Label] ";
                        }
                         return $str;
                           }
?>
<form name="searchkos" id="searchkos" action="searchmore.php" method="post">

<div class="row mb10">
                      <div class="span6 form-inline">
                        <label><strong>Tipe Kost: &nbsp;</strong></label>
                       <select name="kategori_kost" id="kategori_kost">
             <?php

           echo " <option value=0 selected>- Pilih Kategori -</option>";
            $tampil=mysql_query("SELECT * FROM kategori_kost where id_kategori ORDER BY nama_kategori");
            while($r=mysql_fetch_array($tampil)){
             echo "<option value=$r[id_kategori]>$r[nama_kategori]</option>";
            }
            ?>
               </select>
                      </div>
                  </div>

                    <!-- Harga Kos -->
                    <div class="row mb10">
                      <div class="span6 form-inline">
                        <label><strong>Harga Kost Bulanan: &nbsp;</strong></label><br/>
                        <select class="span2" name="hargamin">
                          <option value>Harga Minimum</option>
                          <option value="100000">Rp 100.000</option>
                          <option value="200000">Rp 200.000</option>
                          <option value="300000">Rp 300.000</option>
                          <option value="400000">Rp 400.000</option>
                        </select>
                        <label> - </label>
                        <select class="span2" name="hargamax">
                          <option value>Harga Maximum</option>
                          <option value="300000">Rp 300.000</option>
                          <option value="400000">Rp 400.000</option>
                          <option value="500000">Rp 500.000</option>
                          <option value="1000000">Rp 1.000.000</option>
                          <option value="2000000">Rp 2.000.000</option>
                          <option value="2100000"> > Rp 2.000.000</option>
                        </select>
                      </div>
                    </div>
                     <!-- Harga Kos -->
                    <div class="row mb10">
                      <div class="span6 form-inline">
                        <label><strong>Harga Kost Tahunan: &nbsp;</strong></label><br/>
                        <select class="span2" name="hargamin">
                          <option value>Harga Minimum</option>
                          <option value="100000">Rp 100.000</option>
                          <option value="200000">Rp 200.000</option>
                          <option value="300000">Rp 300.000</option>
                          <option value="400000">Rp 400.000</option>
                        </select>
                        <label> - </label>
                        <select class="span2" name="hargamax">
                          <option value>Harga Maximum</option>
                          <option value="300000">Rp 300.000</option>
                          <option value="400000">Rp 400.000</option>
                          <option value="500000">Rp 500.000</option>
                          <option value="1000000">Rp 1.000.000</option>
                          <option value="2000000">Rp 2.000.000</option>
                          <option value="2100000"> > Rp 2.000.000</option>
                        </select>
                      </div>
                    </div>

                    <div id="kosmore" class="collapse">
                      <!-- Fasilitas Kos -->
                      <div class="row mb10 fasilitaskost">
                        <div class="span7 form-inline">
                          <tr>
                        <td><legend>Fasilitas Kost: &nbsp;</legend></td>
                        <td>
                       <?php

                      $fasilitas = mysql_query("SELECT * FROM fasilitas ORDER BY nama_fasilitas");
                      while ($t=mysql_fetch_array($fasilitas)){
                       echo "<input type=checkbox value='$t[nama_fasilitas]' name=nama_fasilitas[]>$t[nama_fasilitas] ";
                          }
                          ?>

                     </td>

                     </tr>
                        </div>
                      </div>
                    </div>

                    <a class="btn btn-inverse" data-toggle="collapse" data-target="#kosmore">Detail</a>
                    <button type="submit" class="btn btn-danger" name="smkost">Search</button>

                </form> <!-- End Form -->


searchmore.php :
<?php
include_once('conf/koneksi.php');

  /* ================== DATA kost =================== */

  if(isset($_POST['kost'])){

    /* Data Penghuni */
    if(isset($_POST['kategori_kost'])) {
      $namakategori = $_POST['nama_kategori'];
      $qnamakategori = "nama_kategori = '".$namakategori."' AND ";
    }

    /* Data Harga Bulanan */
    if(isset($_POST['harga_bulananmin']) && $_POST['harga_bulananmax'] != '') {
      $hargamin = $_POST['harga_bulananmin'];
      $hargamax = $_POST['harga_bulananmax'];
      $qharga = "harga_bulanan BETWEEN ".$hargamin." AND ".$hargamax." AND ";
    }

     /* Data Harga Bulanan */
    if(isset($_POST['harga_tahunanmin']) && $_POST['harga_tahunanmin'] != '') {
      $hargamin = $_POST['harga_tahunanmin'];
      $hargamax = $_POST['harga_tahunanmax'];
      $qharga = "harga_tahunan BETWEEN ".$hargamin." AND ".$hargamax." AND ";

    }

    /* Data Fasilitas */
    if(isset($_POST['fasilitas'])){
      $arrfasilitas = $_POST['fasilitas'];
      $condition= array();
      foreach ($arrfasilitas as $arr){
        $condition[] = "nama_fasilitas LIKE '%".$arr."%'";
      }
      $qfasilitas = implode(" AND ",$condition)." AND ";
    }

    $query = mysql_query("SELECT * FROM kost,kategori_kost,fasilitas WHERE ".$qhargabulanan.$qhargatahunan.$qkategorikost.$qfasilitas." id_kost > 0 ");

  }
        else {
                      echo '<h4>Maaf, data tidak ditemukan </h4>';
                    }
                    ?>