Esempi in PHP per Conn::openMssqlConnection

Esempio n. 1

File: search-keluarga-kb-json.php Progetto: aldrymaulana/mdk-php

<?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) {