本文整理汇总了PHP中bukaquery函数的典型用法代码示例。如果您正苦于以下问题：PHP bukaquery函数的具体用法？PHP bukaquery怎么用？PHP bukaquery使用的例子？那么, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了bukaquery函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: paging
function paging($sql, $item_per_page, $page_per_block, $url, $page, $block)
{
/*The Simple Advanced Paging by Bimosaurus..
Please make it sure that this page is load the code like it
********************************************
$item_per_page = 10;
$page_per_block= 10;
if (!isset($_GET[page]) ){
$page = 1;
$block = 1;
}else{
$page = ($_GET[page]);
$block = ceil($page/$page_per_block);
}
$offset = ($page - 1) * $item_per_page ;
********************************************
*/
$q = bukaquery($sql);
$n = mysql_num_rows($q);
$jumdata = $n;
$jumhal = ceil($n / $item_per_page);
$jumblock = ceil($jumhal / $page_per_block);
/*Prevent from Paging Hacking*/
if ($_GET[page] > $jumhal) {
$page = $jumhal;
$block = ceil($page / $page_per_block);
} elseif ($_GET[page] < 1) {
$page = 1;
$block = 1;
}
/*end of prevention*/
if ($jumhal > 1) {
?>
<span style="float:left; margin-right:10px; font-size:13px; color:#333;">Halaman : </span>
<?php
if ($block <= 1) {
$prev = "no";
$next = "yes";
} elseif ($block >= $jumblock) {
$prev = "yes";
$next = "no";
} else {
$prev = "yes";
$next = "yes";
}
if ($prev == "yes") {
$prev_page = ($block - 1) * $page_per_block;
$prev_block = $block - 1;
?>
<span class="block_nav_page"><a href="<?php
echo $url;
?>
&page=1">««First</a></span>
<span class="block_nav_page" style="margin-right:8px;"><a href="<?php
echo $url;
?>
&page=<?php
echo $prev_page;
?>
">«Prev</a></span>
<?php
} elseif ($prev == "no" && $jumblock > 1) {
?>
<span class="block_nav_page" style="color:#ccc;">««First</span>
<span class="block_nav_page" style="margin-right:8px; color:#ccc;">«Prev</span>
<?php
}
$startblock = ($block - 1) * $page_per_block + 1;
$endblock = $block * $page_per_block;
while ($startblock <= $endblock && $startblock <= $jumhal) {
if ($startblock == $page) {
?>
<span class="item_paging_current"><?php
echo $startblock;
?>
</span>
<?php
} else {
?>
<span class="item_paging_active"><a href="<?php
echo $url;
?>
&page=<?php
echo $startblock;
?>
"><?php
echo $startblock;
?>
</a></span>
<?php
}
$startblock++;
}
if ($next == "yes") {
$next_page = $block * $page_per_block + 1;
$next_block = $block + 1;
if ($next_page <= $jumhal) {
?>
//.........这里部分代码省略.........
示例2: formatDuit
<?php
echo "</center>\n </td>\n <td>{$baris['0']}</td>\n <td>" . formatDuit($baris[1]) . "</td>\n </tr>";
}
echo "</table>";
} else {
echo "<b>Data Status Keanggotaan Jamsostek masih kosong !</b>";
}
?>
</div>
</form>
<?php
if ($_GET['action'] == "HAPUS") {
Hapus(" jamsostek ", " stts ='" . $stts . "' ", "?act=DetailJamsostek&action=TAMBAH&stts={$stts}");
}
if (mysql_num_rows($hasil) != 0) {
$hasil1 = bukaquery("SELECT stts,biaya from jamsostek ORDER BY stts ");
$jumlah1 = mysql_num_rows($hasil1);
$i = $jumlah1 / 19;
$i = ceil($i);
echo " Data : {$jumlah}";
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>示例3: bukaquery
}
$hasil23 = bukaquery($_sql23);
$baris23 = mysql_fetch_array($hasil23);
$ttlinsentif = $baris23[0];
$ttlttlinsentif = $ttlttlinsentif + $ttlinsentif;
$jmltmb = $ttlinsentif + $jm + $jl;
$ttljmltmb = $ttljmltmb + $jmltmb;
$ttlgaji = $jmltmb + $lemburhb + $lemburhr + $gapok + $tnjjbtn + $tnjtnj + $tnjtnjbln + $ttlkasift + $tmbhjgmlm + $tmbahanjg + $tnjhadir;
$ttlttlgaji = $ttlttlgaji + $ttlgaji;
$_sql30 = "select master_tindakan.nama,sum(tindakan.jm)\n from master_tindakan,tindakan\n where tindakan.tnd=master_tindakan.id and\n tindakan.id='{$baris['0']}'\n and tgl like '%" . $tahun . "-" . $bulan . "%'\n group by tindakan.tnd ";
$hasil30 = bukaquery($_sql30);
while ($baris30 = mysql_fetch_array($hasil30)) {
}
echo " \n <td><font size='2' color='green'><i>" . formatDuit($ttlgaji) . "</i></font></td>\n <td>";
$_sql25 = "select potongan.jamsostek,\n potongan.dansos,\n potongan.simwajib,\n potongan.angkop,\n potongan.angla,\n potongan.telpri,\n potongan.pajak,\n potongan.pribadi,\n potongan.lain from potongan\n where potongan.id='{$baris['0']}' and\n potongan.tahun='{$tahun}' and potongan.bulan='{$bulanindex}' ";
$hasil25 = bukaquery($_sql25);
$baris25 = mysql_fetch_array($hasil25);
$jamsostek = $baris25[0];
$dansos = $baris25[1];
$simwajib = $baris25[2];
$angkop = $baris25[3];
$angla = $baris25[4];
$telpri = $baris25[5];
$pajak = $baris25[6];
$pribadi = $baris25[7];
$lain = $baris25[8];
if (empty($baris25[0])) {
$jamsostek = 0;
} else {
$jamsostek = $baris25[0];
}示例4: Hapus
echo "</table>";
} else {
echo "<b>Data Bidang masih kosong !</b>";
}
?>
<?php
if ($_GET['action'] == "HAPUS") {
Hapus(" bidang ", " nama ='" . $_GET['nama'] . "' ", "?act=ListBidang");
}
?>
</div>
<?php
if (mysql_num_rows($hasil) != 0) {
$hasil1 = bukaquery("SELECT nama FROM bidang");
$jumlah1 = mysql_num_rows($hasil1);
$i = $jumlah1 / 19;
$i = ceil($i);
echo "Data : {$jumlah} ";
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>示例5: bukaquery
<ul class="left_menu">
<?php
$x = bukaquery("select * from kategori order by nm_kategori");
while ($row = mysql_fetch_row($x)) {
$x2 = bukaquery("select * from subkategori where kd_kategori='{$row['0']}' order by nm_subktg");
echo "<li class='even'><a href=?act=ListKategoriProduk&action=KATEGORI&kd_kategori={$row['0']}&nm_kategori={$row['1']}>{$row['1']} (" . mysql_num_rows($x2) . ")</a></li>";
}
?>
</ul>
<br/>示例6: mysql_fetch_row
$baris = mysql_fetch_row($hasil);
$tahun = $baris[0];
$bln_leng = strlen($baris[1]);
$bulan = "0";
if ($bln_leng == 1) {
$bulan = "0" . $baris[1];
} else {
$bulan = $baris[1];
}
$id = $_GET['id'];
$_sql = "SELECT nik,nama FROM pegawai where id='{$id}'";
$hasil = bukaquery($_sql);
$baris = mysql_fetch_row($hasil);
$nik = $baris[0];
$nama = $baris[1];
$_sql = "select rawatjalan.tgl,\n rawatjalan.id,\n rawatjalan.tnd,\n master_tindakan.nama,\n rawatjalan.jm,\n rawatjalan.nm_pasien,\n rawatjalan.kamar,\n rawatjalan.diagnosa,\n rawatjalan.jmlh\n from rawatjalan inner join master_tindakan\n where rawatjalan.tnd=master_tindakan.id and rawatjalan.id='{$id}'\n\t\t\t and tgl like '%" . $tahun . "-" . $bulan . "%' ORDER BY tgl ";
$hasil = bukaquery($_sql);
$jumlah = mysql_num_rows($hasil);
$ttljm = 0;
if (mysql_num_rows($hasil) != 0) {
echo "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='0' class='tbl_form'>\n <caption><h3 class=title><font color='999999'>Laporan Rawat Jalan Dokter " . $nik . " " . $nama . "<br>Tahun " . $tahun . " Bulan " . $bulan . "</font></h3><br>\n\t\t\t\t\t</caption>\n <tr class='head'>\n <td width='20%'><div align='center'><font size='2' face='Verdana'><strong>Jmlh.Tindakan</strong></font></div></td>\n <td width='50%'><div align='center'><font size='2' face='Verdana'><strong>Nama Tindakan</strong></font></div></td>\n <td width='30%'><div align='center'><font size='2' face='Verdana'><strong>JM Tindakan</strong></font></div></td>\n </tr>";
while ($baris = mysql_fetch_array($hasil)) {
$ttljm = $ttljm + $baris[4];
echo "<tr class='isi'>\n <td>{$baris['8']} </td>\n <td>{$baris['3']} </td>\n <td>" . formatDuit($baris[4]) . " </td>\n </tr>";
}
echo "</table>";
echo "<br><font color='999999' size='3'><b>Jumlah Total JM : " . formatDuit($ttljm) . "</b></font>";
}
?>
</body>
</html>示例7: bukaquery
<option id='TxtIsi17' value='FT>1'>FT>1</option>
</select>
<span id="MsgIsi17" style="color:#CC0000; font-size:10px;"></span>
</td>
</tr>
<tr class="head">
<td width="25%" >Kode Index</td><td width="">:</td>
<td width="75%">
<select name="indexins" class="text2" onkeydown="setDefault(this, document.getElementById('MsgIsi18'));" id="TxtIsi18">
<!--<option id='TxtIsi12' value='null'>- Ruang -</option>-->
<?php
$_sql = "SELECT dep_id,persen FROM indexins ORDER BY dep_id";
$hasil = bukaquery($_sql);
if ($action == "UBAH") {
$_sql2 = "SELECT dep_id,persen FROM indexins where dep_id='{$indexins}' ORDER BY dep_id";
$hasil2 = bukaquery($_sql2);
while ($baris2 = mysql_fetch_array($hasil2)) {
echo "<option id='TxtIsi18' value='{$baris2['0']}'>{$baris2['0']} {$baris2['1']}%</option>";
}
}
while ($baris = mysql_fetch_array($hasil)) {
echo "<option id='TxtIsi18' value='{$baris['0']}'>{$baris['0']} {$baris['1']}%</option>";
}
?>
</select>
<span id="MsgIsi18" style="color:#CC0000; font-size:10px;"></span>
</td>
</tr>
<tr class="head">
<td width="25%" >BPD</td><td width="">:</td>
<td width="75%">示例8: formatDuit
<?php
echo "</center>\n </td>\n <td>{$baris['1']}</td>\n <td>" . formatDuit($baris[2]) . "</td>\n <td>{$baris['3']}</td>\n </tr>";
}
echo "</table>";
} else {
echo "<b>Data master tindakan masih kosong !</b>";
}
?>
</div>
</form>
<?php
if ($_GET['action'] == "HAPUS") {
Hapus(" master_tindakan ", " id ='" . $_GET['id'] . "' ", "?act=DetailTindakanRj&action=TAMBAH&nama={$nama}");
}
if (mysql_num_rows($hasil) != 0) {
$hasil1 = bukaquery("SELECT id,nama,jm from master_tindakan ORDER BY nama ASC ");
$jumlah1 = mysql_num_rows($hasil1);
$i = $jumlah1 / 19;
$i = ceil($i);
echo " Data : {$jumlah} ";
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>示例9: bukaquery
<?php
include_once "conf/command.php";
include_once "conf/conf.php";
if (isset($_GET['act']) && $_GET['act'] == "login") {
$sql = "SELECT nip,usere,passwordte,type FROM user WHERE usere='" . $_POST['usere'] . "' AND passwordte='" . $_POST['passwordte'] . "'";
$hasil = bukaquery($sql);
$baris = mysql_fetch_row($hasil);
$nip = $baris[0];
$usere = $baris[1];
$passwordte = $baris[2];
$type = $baris[3];
$hasil = bukaquery($sql);
$baris = mysql_fetch_row($hasil);
if (JumlahBaris($hasil) == 0) {
header("Location:index.php");
} else {
session_start();
HapusAll(" sesion ");
InsertData(" sesion ", "'{$nip}'");
/*$ses_admin = $hasil[0];
session_register("ses_admin");
$url = "index.php?act=HomeAdmin&type=$type";*/
if ($type == 'ADMIN') {
$ses_admin = $hasil[0];
session_register("ses_admin");
$url = "index.php?act=HomeAdmin&nip={$nip}";
} elseif ($type == 'PEGAWAI') {
$ses_pegawai = $hasil[0];
session_register("ses_pegawai");
$url = "index.php?act=HomeAdmin&nip={$nip}";示例10: mysql_num_rows
$jumlah = mysql_num_rows($hasil);
if (mysql_num_rows($hasil) != 0) {
echo "<table width='600px' border='0' align='center' cellpadding='0' cellspacing='0' class='tbl_form'>\r\n <tr class='head'>\r\n <td width='70px'><div align='center'><font size='2' face='Verdana'><strong>Proses</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>NIK</strong></font></div></td>\r\n <td width='250px'><div align='center'><font size='2' face='Verdana'><strong>Nama</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Anggota Koperasi</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Anggota Jamsostek</strong></font></div></td>\r\n </tr>";
while ($baris = mysql_fetch_array($hasil)) {
echo "<tr class='isi'>\r\n <td>\r\n <center>\r\n <a href=?act=InputKeanggotaan&action=UBAH&id={$baris['0']}>[Update]</a>\r\n </center>\r\n </td>\r\n <td>{$baris['1']}</td>\r\n <td>{$baris['2']}</td>\r\n <td>{$baris['3']}</td>\r\n <td>{$baris['4']}</td>\r\n </tr>";
}
echo "</table>";
} else {
echo "<b>Data keanggotaan masih kosong !</b>";
}
?>
</div>
</form>
<?php
if (mysql_num_rows($hasil) != 0) {
$hasil1 = bukaquery("select pegawai.id,pegawai.nik,pegawai.nama,\r\n keanggotaan.koperasi, keanggotaan.jamsostek\r\n from keanggotaan right OUTER JOIN pegawai\r\n on keanggotaan.id=pegawai.id\r\n\t\t\t\twhere pegawai.nik like '%" . $keyword . "%' or \r\n\t\t\t\tpegawai.nama like '%" . $keyword . "%' or\r\n\t\t\t\tkeanggotaan.koperasi like '%" . $keyword . "%' or\r\n\t\t\t\tkeanggotaan.jamsostek like '%" . $keyword . "%'\r\n\t\t\t\torder by pegawai.id ASC ");
$jumlah1 = mysql_num_rows($hasil1);
$i = $jumlah1 / 19;
$i = ceil($i);
echo "Data : {$jumlah} <a target=_blank href=/penggajian/pages/keanggotaan/LaporanKeanggotaan.php?&keyword={$keyword}>| Laporan |</a> ";
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>示例11: Hapus
<?php
echo "</center>\n </td>\n <td>{$baris['2']}</td>\n </tr>";
}
echo "</table>";
} else {
echo "<b>Data Jaga Malam masih kosong !</b>";
}
?>
</div>
</form>
<?php
if ($_GET['action'] == "HAPUS") {
Hapus(" jgmlm ", " id ='" . $_GET['id'] . "' and tgl ='" . $_GET['tgl'] . "'", "?act=InputJagaMalam&action=TAMBAH&id={$id}");
}
if (mysql_num_rows($hasil) != 0) {
$hasil1 = bukaquery("SELECT tgl,id,jml\n from jgmlm where id='{$id}'\n\t\t\t and tgl like '%" . $tahun . "-" . $bulan . "%' ORDER BY tgl ASC ");
$jumlah1 = mysql_num_rows($hasil1);
$i = $jumlah1 / 19;
$i = ceil($i);
echo "Data : {$jumlah} <a target=_blank href=http://" . host() . "/penggajian/pages/presensi/laporanpresensidetail.php?&id={$id}>| Laporan |</a>";
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>示例12: Hapus
}
echo "</table>";
} else {
echo "<b>Data Jabatan Fungsional masih kosong !</b>";
}
?>
<?php
if ($_GET['action'] == "HAPUS") {
Hapus(" fungsional ", " kode ='" . $_GET['kode'] . "' ", "?act=ListFungsional");
}
?>
</div>
<?php
if (mysql_num_rows($hasil) != 0) {
$hasil1 = bukaquery("SELECT kode,nama FROM fungsional");
$jumlah1 = mysql_num_rows($hasil1);
$i = $jumlah1 / 19;
$i = ceil($i);
echo "<br/>Jumlah Record : {$jumlah} ";
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>示例13: bukaquery
}
echo "</table>";
} else {
echo "<b>Data Index Pegawai masih kosong !</b>";
}
$BtnPrint = $_POST['BtnPrint'];
if (isset($BtnPrint)) {
echo "<html><head><title></title><meta http-equiv='refresh' content='2;pages/pegawai/LaporanIndex.php?&keyword={$keyword}'></head><body></body></html>";
}
?>
</div>
</form>
<?php
if (mysql_num_rows($hasil) != 0) {
$say = " pegawai.pendidikan=pendidikan.tingkat\r\n and pegawai.stts_kerja =stts_kerja.stts\r\n and pegawai.jnj_jabatan=jnj_jabatan.kode ";
$hasil1 = bukaquery("select pegawai.id,\r\n pegawai.nik,\r\n pegawai.nama,\r\n pegawai.jbtn,\r\n pegawai.pendidikan,\r\n pegawai.mulai_kerja,\r\n CONCAT(FLOOR(PERIOD_DIFF(DATE_FORMAT('{$tahun}-{$bulan}-{$hari}', '%Y%m'),DATE_FORMAT(mulai_kerja, '%Y%m'))/12), ' Tahun ',MOD(PERIOD_DIFF(DATE_FORMAT('{$tahun}-{$bulan}-{$hari}', '%Y%m'), DATE_FORMAT(mulai_kerja, '%Y%m')),12), ' Bulan ') as lama,\r\n pendidikan.indek as index_pendidikan,\r\n (To_days('{$tahun}-{$bulan}-{$hari}')-to_days(mulai_kerja))/365 as masker,\r\n stts_kerja.indek as index_status,\r\n pegawai.indek as index_struktural,\r\n pegawai.pengurang,\r\n pegawai.mulai_kontrak,\r\n CONCAT(FLOOR(PERIOD_DIFF(DATE_FORMAT('{$tahun}-{$bulan}-{$hari}', '%Y%m'),DATE_FORMAT(mulai_kontrak, '%Y%m'))/12), ' Tahun ',MOD(PERIOD_DIFF(DATE_FORMAT('{$tahun}-{$bulan}-{$hari}', '%Y%m'), DATE_FORMAT(mulai_kontrak, '%Y%m')),12), ' Bulan ') as lamakontrak,\r\n (To_days('{$tahun}-{$bulan}-{$hari}')-to_days(mulai_kontrak))/365 as maskon\r\n from pegawai inner join pendidikan\r\n inner join stts_kerja\r\n inner join jnj_jabatan\r\n where " . $say . " and pegawai.nik like '%" . $keyword . "%' or\r\n " . $say . " and pegawai.nama like '%" . $keyword . "%' or\r\n " . $say . " and pegawai.jbtn like '%" . $keyword . "%' or\r\n " . $say . " and pegawai.pendidikan like '%" . $keyword . "%' or\r\n " . $say . " and pegawai.mulai_kontrak like '%" . $keyword . "%' or\r\n " . $say . " and pegawai.mulai_kerja like '%" . $keyword . "%'\r\n order by pegawai.id ASC");
$jumlah1 = mysql_num_rows($hasil1);
$i = $jumlah1 / 19;
$i = ceil($i);
echo "Data : {$jumlah} <a target=_blank href=/penggajian/pages/pegawai/LaporanIndex.php?&keyword={$keyword}>| Laporan |</a> ";
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>示例14: bukaquery
$hasilobat = bukaquery($_sqlobat);
while ($obat = mysql_fetch_array($hasilobat)) {
echo "{$obat['0']}, ";
}
echo "<br/><br/>Hasil pemeriksaan penunjang :<br/>";
$_sqljalandr = "select hasil from rawat_jl_dr where rawat_jl_dr.no_rawat='{$norw}' group by hasil";
$hasiljalandr = bukaquery($_sqljalandr);
$no = 1;
while ($pemeriksaan = mysql_fetch_array($hasiljalandr)) {
if (!empty($pemeriksaan[0])) {
echo "{$no}. {$pemeriksaan['0']}<br/> ";
$no++;
}
}
$_sqlinapdr = "select hasil from rawat_inap_dr where rawat_inap_dr.no_rawat='{$norw}' group by hasil ";
$hasilinapdr = bukaquery($_sqlinapdr);
while ($pemeriksaan = mysql_fetch_array($hasilinapdr)) {
if (!empty($pemeriksaan[0])) {
echo "{$no}. {$pemeriksaan['0']}<br/> ";
$no++;
}
}
echo "<br/>\n Mohon Penatalaksanaan selanjutnya.<br/>\n Demikian rujukan ini, mohon balasan rujukan (Dx dan Tx). Atas kerjasamanya kami ucapkan terima kasih.<br/><br/>\n Wonogiri, " . substr($tanggal, 8, 2) . "-" . substr($tanggal, 5, 2) . "-" . substr($tanggal, 0, 4) . "<br/>\n Salan dan Hormat Kami, <br/><br/><br/><br/>\n <u>( {$dokter} )</u>\n </font>\n \n </td>\n </tr>\n </table>";
} else {
echo "<font color='999999' size='2' face='Tahoma'><b>Data Billing masih kosong !</b>";
}
?>
</body>
</html>示例15: reportsqlinjection
<body>
<?php
reportsqlinjection();
$tanggal1 = $_GET['tanggal1'];
$tanggal2 = $_GET['tanggal2'];
$_sql = "select left(tgl_registrasi,7) from reg_periksa where tgl_registrasi between '{$tanggal1}' and '{$tanggal2}' group by left(tgl_registrasi,7) order by tgl_registrasi";
$hasil = bukaquery($_sql);
if (mysql_num_rows($hasil) != 0) {
echo "<table width='100%' border='1' align='left' cellpadding='0' cellspacing='0' class='tbl_form'>\r\n <caption><br/><center><font color='000000' size='4' face='Arial'>Laporan Kunjuangan Bulanan<br> Periode {$tanggal1} s.d. {$tanggal2} </font></center><br/></caption>\r\n <tr class=isi15>\r\n <td width='5%' align=center>No</td>\r\n <td width='20%' align=center>Bulan</td>\r\n <td width='15%' align=center>Tahun</td>\r\n <td width='25%' align=center>Poli</td>\r\n <td width='10%' align=center>Pasien Lama</td>\r\n <td width='10%' align=center>Pasien Baru</td>\r\n <td width='15%' align=center>Jumlah Pasien</td>\r\n </tr>";
$i = 1;
$lama = 0;
$baru = 0;
$total = 0;
while ($baris = mysql_fetch_array($hasil)) {
$hasil2 = bukaquery("select kd_poli, nm_poli from poliklinik");
while ($baris2 = mysql_fetch_array($hasil2)) {
$lama = $lama + getOne("select count(no_rawat) from reg_periksa where tgl_registrasi like '%{$baris['0']}%' and kd_poli='{$baris2['0']}' and stts_daftar='Lama'");
$baru = $baru + getOne("select count(no_rawat) from reg_periksa where tgl_registrasi like '%{$baris['0']}%' and kd_poli='{$baris2['0']}' and stts_daftar='Baru'");
$total = $total + getOne("select count(no_rawat) from reg_periksa where tgl_registrasi like '%{$baris['0']}%' and kd_poli='{$baris2['0']}'");
echo "<tr class='isi15'>\r\n\t\t\t\t\t\t\t\t <td>{$i} </td>\r\n\t\t\t\t\t\t\t\t <td>" . konversiBulan(substr($baris[0], 5, 2)) . " </td>\r\n\t\t\t\t\t\t\t\t <td>" . substr($baris[0], 0, 4) . " </td>\r\n\t\t\t\t\t\t\t\t <td>" . $baris2[1] . " </td>\r\n\t\t\t\t\t\t\t\t <td>" . getOne("select count(no_rawat) from reg_periksa where tgl_registrasi like '%{$baris['0']}%' and kd_poli='{$baris2['0']}' and stts_daftar='Lama'") . " </td>\r\n\t\t\t\t\t\t\t\t <td>" . getOne("select count(no_rawat) from reg_periksa where tgl_registrasi like '%{$baris['0']}%' and kd_poli='{$baris2['0']}' and stts_daftar='Baru'") . " </td>\r\n\t\t\t\t\t\t\t\t <td>" . getOne("select count(no_rawat) from reg_periksa where tgl_registrasi like '%{$baris['0']}%' and kd_poli='{$baris2['0']}'") . " </td>\r\n\t\t\t\t\t\t </tr>";
$i++;
}
}
echo "\r\n <tr class=isi15>\r\n <td> </td>\r\n <td>Total</td>\r\n <td> </td>\r\n <td> </td>\r\n <td>{$lama} </td>\r\n <td>{$baru} </td>\r\n <td>{$total} </td>\r\n </tr> \r\n </table>";
} else {
echo "<b>Data masih kosong !</b>";
}
?>
</body>