PHP getsiswakamar Examples

Example #1

File: admin_laporanreservasi.php Project: rekysda/hotelfratz

			</div>';
    if (in_array($_GET['aksi'], array('', 'detail'))) {
        /*****************************************/
        /************************************/
        $admin .= '
<table><tr>
<td>Kamar</td>
<td>&nbsp;&nbsp;</td>
<td><select  name="kategori"class="form-control" required onchange="redir(this)">';
        $s = mysql_query("SELECT * FROM `kamar` ORDER BY kamar ASC");
        $admin .= '<option value="">== Pilih Kamar ==</option>';
        $admin .= '<option value="admin.php?pilih=laporanreservasi&mod=yes&aksi=detail&id=semua"> Semua Kamar</option>';
        while ($datas = mysql_fetch_array($s)) {
            $id = $datas['id'];
            $kamar = $datas['kamar'];
            $admin .= '<option value="admin.php?pilih=laporanreservasi&mod=yes&aksi=detail&id=' . $id . '" title="' . $kamar . '">' . $datas['kamar'] . ' ,Kapasitas (' . $datas['kapasitas'] . '), Terisi (' . getsiswakamar($datas['id']) . ')</option>';
        }
        $admin .= '</select></td><td>&nbsp;&nbsp;<a href="cetakreservasi.php"class="btn btn-danger" target="_blank"><i class="icon_printer"></i></a>&nbsp;&nbsp;<a href="cetakreservasi_2.php"class="btn btn-success" target="_blank">Excell</a></td>';
        $admin .= "<form method='get' action='excellkamar.php' enctype ='multipart/form-data' id='posts' target='_blank'>";
        $admin .= '<input type="hidden" name="id" value="' . $id . '"/>';
        $admin .= '<td></td></form>';
        $admin .= '</tr>';
        $admin .= '</table>';
    }
    if ($_GET['aksi'] == "detail") {
        $id = int_filter($_GET['id']);
        if ($id != 'semua') {
            $namakamar = getkamar($id);
            $wherekamar = "where kamar='{$id}'";
        } else {
            $namakamar = 'Semua';

Example #2

File: user_reservasi.php Project: rekysda/hotelfratz

                          <header class="panel-heading">
                              Tambah
                          </header><div class="panel-body">';
        $admin .= '<div class="sukses"><b> Harap diperhatikan : Pemesanan kamar tidak dapat di Edit / Hapus. <br>Apabila terdapat Input data dobel atau ingin pindah Kamar harap menghubungi Ibu. Meliana</b></div>';
        $admin .= '
<form method="post" action="" class="form-inline">
<table class="table table-striped table-hover">';
        $admin .= '<tr>
	<td>Kamar</td>
		<td>:</td>
	<td><select name="kamar" class="form-control" id="kamar"required>';
        $hasilj = $koneksi_db->sql_query("SELECT * FROM kamar ORDER BY kamar asc");
        $admin .= '<option value="">== Pilih Kamar ==</option>';
        while ($datasj = $koneksi_db->sql_fetchrow($hasilj)) {
            $pilihan = $datasj['id'] == $kamar ? "selected" : '';
            $admin .= '<option value="' . $datasj['id'] . '"' . $pilihan . '>' . $datasj['kamar'] . ',Kapasitas (' . $datasj['kapasitas'] . '), Terisi (' . getsiswakamar($datasj['id']) . ')</option>';
        }
        $admin .= '</select></td>
</tr>';
        $admin .= '<tr>
	<td>Kelas</td>
		<td>:</td>
	<td><select name="kelas" class="form-control" id="kelas"required>';
        $hasilj = $koneksi_db->sql_query("SELECT * FROM kelas ORDER BY kelas asc");
        $admin .= '<option value="">== Pilih Kelas ==</option>';
        while ($datasj = $koneksi_db->sql_fetchrow($hasilj)) {
            $pilihan = $datasj['id'] == $kelas ? "selected" : '';
            $admin .= '<option value="' . $datasj['id'] . '"' . $pilihan . '>' . $datasj['kelas'] . '</option>';
        }
        $admin .= '</select></td>
</tr>';