<?php require '../../lib/conn.inc.php'; $conn = new Conn(); $table = 'v_KeluargaKB'; $conn->openMssqlConnection(); $noKKI = isset($_REQUEST['NoKKI']) ? $_REQUEST['NoKKI'] : ''; $namaKK = isset($_REQUEST['NamaKK']) ? $_REQUEST['NamaKK'] : ''; $bulan = isset($_REQUEST['Bulan']) ? $_REQUEST['Bulan'] : ''; $tahun = isset($_REQUEST['Tahun']) ? $_REQUEST['Tahun'] : ''; $kecamatan = isset($_REQUEST['Kecamatan']) ? $_REQUEST['Kecamatan'] : ''; $kelurahan = isset($_REQUEST['Kelurahan']) ? $_REQUEST['Kelurahan'] : ''; $rw = isset($_REQUEST['Rw']) ? $_REQUEST['Rw'] : ''; $rt = isset($_REQUEST['Rt']) ? $_REQUEST['Rt'] : ''; $where = '1=1 '; if ($noKKI) { $where .= 'AND NoKKI=\'' . $noKKI . '\''; } if ($namaKK) { $where .= 'AND KepalaKeluarga LIKE \'%' . $namaKK . '%\''; } if ($bulan) { $where .= 'AND BulanId=' . $bulan; } if ($tahun) { $where .= 'AND Tahun=' . $tahun; } if ($kecamatan) { $where .= 'AND KecamatanId=' . $kecamatan; } if ($kelurahan) {